francisn
unread,Nov 4, 2011, 10:05:23 AM11/4/11You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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)