PreparedStatement parameters and mutable objects

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: PreparedStatement parameters and mutable objects
Date: 2004-01-07 01:05:09
Message-ID: 3FFB5B45.80702@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I'm examining ways to reduce the amount of garbage generated by the
driver, and one approach I'm looking at is to delay converting the
parameters of a PreparedStatement to string form until we're actually
streaming data to the backend, to avoid creating an intermediate copy.

This leads to a question .. does this code have well-defined behaviour:

Connection conn = /* ... */;
PreparedStatement pstmt =
conn.prepareStatement("INSERT INTO t(data) VALUES (?)");
byte[] data = new byte[] { (byte)1, (byte)2, (byte)3 };
pstmt.setBytes(1, data);
data[0] = (byte)42;
pstmt.executeUpdate();

i.e. is the driver required to capture the value of the byte array
passed to setBytes() at a particular time (either the time of the call
or the time of execution), or is it free to choose? Currently we capture
the value at the time of call.

The same problem applies to all parameter-setting methods that take
mutable objects.

I can't see anything about this in the (PDF) JDBC specification. The
javadoc says:

The driver converts this to an SQL VARBINARY or LONGVARBINARY
(depending on the argument's size relative to the driver's limits on
VARBINARY values) when it sends it to the database.

which implies the driver can delay the conversion (or perhaps must delay
the conversion).

Anyone have an opinion on this?

-O

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2004-01-07 12:59:40 Re: PreparedStatement parameters and mutable objects
Previous Message Kris Jurka 2004-01-06 23:37:31 Re: odd jdbc driver synchronization issue