Hi,
We are currently migrating our server to Sybase ASE 12.0 and we keep
getting SET CHAINED messages from the Sybase driver. I know this used to
happen, and there was even a fix for this problem in 3.0.1RC1 (I have been
trawling the archives!).
The code that fails gets a connection from JNDI and uses JDBC calls to
read a table. Sadly, I haven't tried using CMP to do the same thing yet.
Here's the exception stack trace.
2003-07-29 18:08:52,272 71553 ERROR
[xcom.traxbahn.util.sysconfig.SysConfig] (main:) Exception while reading
System Configuration parameters from the database: SET CHAINED command not
allowed within multi-statement transaction.
com.sybase.jdbc2.jdbc.SybSQLException: SET CHAINED command not allowed
within multi-statement transaction.
at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2672)
at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2032)
at
com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
at
com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:204)
at
com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:187)
at
com.sybase.jdbc2.jdbc.SybStatement.updateLoop(SybStatement.java:1642)
at
com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:1625)
at
com.sybase.jdbc2.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:91)
at com.sybase.jdbc2.tds.Tds.setOption(Tds.java:1111)
at
com.sybase.jdbc2.jdbc.SybConnection.setAutoCommit(SybConnection.java:769)
at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.checkTransaction(LocalManagedConnection.java:432)
at
org.jboss.resource.adapter.jdbc.local.LocalConnection.checkTransaction(LocalConnection.java:756)
at
org.jboss.resource.adapter.jdbc.local.LocalStatement.checkTransaction(LocalStatement.java:771)
at
org.jboss.resource.adapter.jdbc.local.LocalPreparedStatement.executeQuery(LocalPreparedStatement.java:286)
at
xcom.traxbahn.util.sysconfig.SysConfig.getConfigDataFromDb(SysConfig.java:146)
at
xcom.traxbahn.util.sysconfig.SysConfig.refresh(SysConfig.java:48)
at
xcom.traxbahn.util.sysconfig.SysConfig.<clinit>(SysConfig.java:39)
at
xcom.traxbahn.util.issuer.IssuerManager.loadIssuers(IssuerManager.java:32)
at
xcom.traxbahn.system.TraxbahnManagement.refreshIssuers(TraxbahnManagement.java:51)
at
xcom.traxbahn.system.TraxbahnManagement.startService(TraxbahnManagement.java:77)
at
org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:165)
Ciao,
Jonathan O'Connor
Development Manager
XCOM Dublin
Phone: +353 1 872 3305
Mobile: +353 86 824 9736
-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
