Subject | Stuck with a SQLException after setString() to a BLOB |
---|---|
Author | Cor Hofman |
Post date | 2001-10-19T14:18:16Z |
I am using Interbase 6.0. with JDBC within a J2EE environment and I
discovered a most annoying behaviour.
Every other record I try to insert in a table containing a BLOB runs
into an
[Default] interbase.interclient.SQLException: [interclient][interbase]
invalid transaction handle (expecting explicit transaction start)
[Default] at
interbase.interclient.RecvMessage.createSQLException(interbase/interclient/R
ecvMessage.java:694)
[Default] at
interbase.interclient.RecvMessage.makeSQLException(interbase/interclient/Rec
vMessage.java:593)
[Default] at
interbase.interclient.RecvMessage.get_EXCEPTIONS(interbase/interclient/RecvM
essage.java:554)
[Default] at
interbase.interclient.BlobInput.<init>(interbase/interclient/BlobInput.java:
50)
[Default] at
interbase.interclient.JDBCNet.setBlobString(interbase/interclient/JDBCNet.ja
va:561)
[Default] at
interbase.interclient.PreparedStatement.setString(interbase/interclient/Prep
aredStatement.java:987)
[Default] at
org.jboss.pool.jdbc.PreparedStatementInPool.setString(PreparedStatementInPoo
l.java:182)
[Default] at
org.companion.entity.pim.NoteBean.ejbPostCreate(NoteBean.java:174)
more lines...
I have the following table
CREATE TABLE "NOTE"
(
"NOTEID" VARCHAR(32) NOT NULL,
"ORGID" INTEGER,
"DIVID" INTEGER,
"DEPID" INTEGER,
"USERID" INTEGER NOT NULL,
"ACCESSMASK" INTEGER,
"CREATION" TIMESTAMP NOT NULL,
"CREATEUSERID" INTEGER NOT NULL,
"MODIFICATION" TIMESTAMP,
"MODIFYUSERID" INTEGER,
"DELETION" TIMESTAMP,
"DELETEUSERID" INTEGER,
"NOTE" BLOB SUB_TYPE 0 SEGMENT SIZE 80,
PRIMARY KEY ("NOTEID")
);
Is there anybody who knows what is going on.
Many thanks in advance to those who react.
Regards,
Cor.
discovered a most annoying behaviour.
Every other record I try to insert in a table containing a BLOB runs
into an
[Default] interbase.interclient.SQLException: [interclient][interbase]
invalid transaction handle (expecting explicit transaction start)
[Default] at
interbase.interclient.RecvMessage.createSQLException(interbase/interclient/R
ecvMessage.java:694)
[Default] at
interbase.interclient.RecvMessage.makeSQLException(interbase/interclient/Rec
vMessage.java:593)
[Default] at
interbase.interclient.RecvMessage.get_EXCEPTIONS(interbase/interclient/RecvM
essage.java:554)
[Default] at
interbase.interclient.BlobInput.<init>(interbase/interclient/BlobInput.java:
50)
[Default] at
interbase.interclient.JDBCNet.setBlobString(interbase/interclient/JDBCNet.ja
va:561)
[Default] at
interbase.interclient.PreparedStatement.setString(interbase/interclient/Prep
aredStatement.java:987)
[Default] at
org.jboss.pool.jdbc.PreparedStatementInPool.setString(PreparedStatementInPoo
l.java:182)
[Default] at
org.companion.entity.pim.NoteBean.ejbPostCreate(NoteBean.java:174)
more lines...
I have the following table
CREATE TABLE "NOTE"
(
"NOTEID" VARCHAR(32) NOT NULL,
"ORGID" INTEGER,
"DIVID" INTEGER,
"DEPID" INTEGER,
"USERID" INTEGER NOT NULL,
"ACCESSMASK" INTEGER,
"CREATION" TIMESTAMP NOT NULL,
"CREATEUSERID" INTEGER NOT NULL,
"MODIFICATION" TIMESTAMP,
"MODIFYUSERID" INTEGER,
"DELETION" TIMESTAMP,
"DELETEUSERID" INTEGER,
"NOTE" BLOB SUB_TYPE 0 SEGMENT SIZE 80,
PRIMARY KEY ("NOTEID")
);
Is there anybody who knows what is going on.
Many thanks in advance to those who react.
Regards,
Cor.