db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@apache.org>
Subject Re: [jira] Updated: (DERBY-1253) Verify that we don't raise SQLFeatureNotSupportedException for mandatory methods
Date Tue, 02 May 2006 20:04:42 GMT
Dyre.Tjeldvoll@Sun.COM wrote:

> "Lance J. Andersen" <Lance.Andersen@Sun.COM> writes:
>>If you support a data type such as Blob/Clob, you must implement all
>>methods on the interface, not pick and choose.
>>If your backend does not support the data type, then all methods
>>should throw SQLFeatureNotSupportedException.
>>This was a problem in the earlier JDBC specs as it did not clarify
>>which methods were required and which were not.
> Hi Lance, thanks for the clarification. 
> Currently we are missing:
> Blob.getBinaryStream(long,long)
> Blob.setBinaryStream(long)
> Blob.setBytes(long, byte[])
> Blob.setBytes(long, byte[], int, int)
> Blob.truncate(long)
> Blob.free() {DERBY-1145}
> Clob.getCharacterStream(long,long) 
> Clob.setAsciiStream(long)
> Clob.setCharacterStream(long)
> Clob.setString(long, String)
> Clob.setString(long, String, int, int)
> Clob.truncate(long)
> Clob.free() {DERBY-1145}
> I assume that this means that we also need to implement:
> Connection.create[BC]lob()
> PreparedStatement.set[BC]lob()
> CallableStatement.set[BC]lob() (except named parameter variants)
> CallableStatement.get[BC]lob() (except named parameter variants) ?
> If so; there is indeed much work that needs to be done before Derby
> can claim to support Blob/Clob in Jdbc4 :(

And some thought needs to go into supporting these methods, see section
3.3 of JDBC 3.0. Do we implement updating the LOB updates the column or
updates a copy, does the client need to match embedded here?


View raw message