Subject Another problem with blobs BLOBS?
Author Kenneth Foo
Hi

I tried the following using a PreparedStatement.

ps.setObject (i, value, java.sql.Types.BINARY)

and the following exception

java.sql.SQLException: GDS exception: Incorrect values within SQLDA
structure
at
org.firebirdsql.jdbc.FBPreparedStatement.internalExecute(FBPreparedStatement
.java:890)
at
org.firebirdsql.jdbc.FBPreparedStatement.executeUpdate(FBPreparedStatement.j
ava:162)
at
com.nic.connect.db.MessageDB.internalUpdateMessage(MessageDB.java:1681)
at com.nic.connect.db.MessageDB.createMessage(MessageDB.java:1559)
at com.nic.connect.db.MessageDB.main(MessageDB.java:2194)

I tried using setBytes, and the thing worked fine.

ps.setBytes (i, value);

Btw, I'm explicitly controlling the transaction.


Regards
Kenneth