You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by Emmanuel Dupont <em...@jwaretechnologies.com> on 2003/06/20 15:36:11 UTC

: Commit on underlying connection failed

All what is a "Commit on underlying connection"

 

I have this on a commit. I update only one table where there is a Clob
column type.

 

 

No read-only option in the repository .

 

 

???

 

Tx !

 

 

[org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] ERROR: Commit on
underlying connection failed, try to rollback

[IBM][CLI Driver] CLI0125E  Function sequence error. SQLSTATE=HY010

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0125E  Function sequence
error. SQLSTATE=HY010

      at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGe
nerator.java:174)

      at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGen
erator.java:431)

      at COM.ibm.db2.jdbc.app.DB2Connection.commit(DB2Connection.java:640)

      at
com.p6spy.engine.logging.P6LogConnection.commit(P6LogConnection.java:141)

      at
org.apache.ojb.broker.util.batch.BatchConnection.commit(BatchConnection.java
:337)

      at
org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.localCommit(Connecti
onManagerImpl.java:200)

      at
org.apache.ojb.broker.core.PersistenceBrokerImpl.commitTransaction(Persisten
ceBrokerImpl.java:385)

      at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.commitTransaction(Del
egatingPersistenceBroker.java:120)

      at
org.apache.ojb.odmg.TransactionImpl.commit(TransactionImpl.java:554)

      at
com.jware.persistence.ojb.JwtTransactionImpl.commit(JwtTransactionImpl.java:
102)

      at
com.jware.test.businessobjects.JwtBOACL.setACLInfo(JwtBOACL.java:149)

      at
com.jware.test.businessobjects.ApplicationACL.run(ApplicationACL.java:55)

      at
com.jware.test.businessobjects.ApplicationACL.main(ApplicationACL.java:38)


Re: Commit on underlying connection failed

Posted by Armin Waibel <ar...@code-au-lait.de>.
Hi,

> All what is a "Commit on underlying connection"
Means that the connection used by the PB instance
(more exact: used by the ConnectionManager associated
with PB) received an exception.

> [IBM][CLI Driver] CLI0125E  Function sequence error. SQLSTATE=HY010
sorry, don't know what DB2 want to say.

> I have this on a commit. I update only one table where there is a Clob
> column type.
Did you have tried to do this update with
the PB-api only? If this fails too, I think then it's safe to say
the problem is caused by DB2/db-driver

regards,
Armin


----- Original Message -----
From: "Emmanuel Dupont" <em...@jwaretechnologies.com>
To: "OJB Users List" <oj...@db.apache.org>
Sent: Friday, June 20, 2003 3:36 PM
Subject: : Commit on underlying connection failed


All what is a "Commit on underlying connection"



I have this on a commit. I update only one table where there is a Clob
column type.





No read-only option in the repository .





???



Tx !





[org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] ERROR: Commit
on
underlying connection failed, try to rollback

[IBM][CLI Driver] CLI0125E  Function sequence error. SQLSTATE=HY010

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0125E  Function
sequence
error. SQLSTATE=HY010

      at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExcepti
onGe
nerator.java:174)

      at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptio
nGen
erator.java:431)

      at
COM.ibm.db2.jdbc.app.DB2Connection.commit(DB2Connection.java:640)

      at
com.p6spy.engine.logging.P6LogConnection.commit(P6LogConnection.java:141
)

      at
org.apache.ojb.broker.util.batch.BatchConnection.commit(BatchConnection.
java
:337)

      at
org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.localCommit(Conn
ecti
onManagerImpl.java:200)

      at
org.apache.ojb.broker.core.PersistenceBrokerImpl.commitTransaction(Persi
sten
ceBrokerImpl.java:385)

      at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.commitTransaction
(Del
egatingPersistenceBroker.java:120)

      at
org.apache.ojb.odmg.TransactionImpl.commit(TransactionImpl.java:554)

      at
com.jware.persistence.ojb.JwtTransactionImpl.commit(JwtTransactionImpl.j
ava:
102)

      at
com.jware.test.businessobjects.JwtBOACL.setACLInfo(JwtBOACL.java:149)

      at
com.jware.test.businessobjects.ApplicationACL.run(ApplicationACL.java:55
)

      at
com.jware.test.businessobjects.ApplicationACL.main(ApplicationACL.java:3
8)