Subject | Another problem with blobs BLOBS? |
---|---|
Author | Kenneth Foo |
Post date | 2002-02-25T08:31:44Z |
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
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