Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SET CHAINED command not allowed within multi-statement transaction

308 views
Skip to first unread message

francisn

unread,
Nov 4, 2011, 10:05:23 AM11/4/11
to
Help please, I'm getting this trace on weblogic 10.3.5 and these
versions of jConnect-6:
EBF16903 - build 26564 (31/05/2009)
EBF19528 - build 26686 (09/2011)

The datasource definition is XA enabled, using
com.sybase.jdbc3.jdbc.SybXADataSource in jconn3.jar, the only sybase
specific connection flag is IS_CLOSED_TEST=INTERNAL (as per advise
from Sybase support when we were having XA errors).

The call to XAConnection.setAutoCommit below has the parameter 'false'
supplied to it.

Caused by: com.sybase.jdbc3.jdbc.SybSQLException: SET CHAINED command
not allowed within multi-statement transaction.

at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown
Source)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown
Source)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown
Source)
at com.sybase.jdbc3.jdbc.SybStatement.updateLoop(Unknown
Source)
at com.sybase.jdbc3.jdbc.SybStatement.executeUpdate(Unknown
Source)
at
com.sybase.jdbc3.jdbc.SybPreparedStatement.executeUpdate(Unknown
Source)
at com.sybase.jdbc3.tds.Tds.setOption(Unknown Source)
at com.sybase.jdbc3.jdbc.SybConnection.setAutoCommit(Unknown
Source)
at
com.sybase.jdbc3.jdbc.SybConnectionProxy.setAutoCommit(Unknown Source)
at
weblogic.jdbc.wrapper.XAConnection.setAutoCommit(XAConnection.java:
833)
at
weblogic.jdbc.wrapper.JTAConnection.recoverAutoCommitState(JTAConnection.java:
237)
at
weblogic.jdbc.wrapper.JTAConnection.getXAConn(JTAConnection.java:222)
at
weblogic.jdbc.wrapper.JTAConnection.checkConnection(JTAConnection.java:
74)
at
weblogic.jdbc.wrapper.JTAConnection.checkConnection(JTAConnection.java:
65)
at
weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:
94)
at
weblogic.jdbc.wrapper.Connection.prepareStatement(Connection.java:496)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:
534)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:
452)
at
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:
161)
0 new messages