Subject Invalid Blob ID
Author Ian A. Newby
Hi All,
Firebird 1.0, JayBird 1.0RC1.

I have an application which stores information in blobs (sub type
1). if A blob is set in a prepared statement using

statement.setNull(paramPosition, LONGVARCHAR);

I get the following error when the statement is executed
:
java.sql.SQLException: GDS exception:
org.firebirdsql.gds.GDSException: invalid BLOB ID
at org.firebirdsql.jdbc.FBPreparedStatement.internalExecute
(FBPreparedStatement.java:458)
at org.firebirdsql.jdbc.FBPreparedStatement.executeUpdate
(FBPreparedStatement.java:130)
at uk.co.wmeng.webframework.StoreData.update
(StoreData.java:307)

I believe that there must be a problem with the driver accepting
null for blobs.

Regards
Ian Newby