com.sybase.jdbc2.jdbc.SybSQLException

SET CHAINED command not allowed within multi-statement transaction.

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web69

  • via Unknown by G. Wayne Kidd,
  • via Unknown by G. Wayne Kidd,
  • via Unknown by 3004,
  • Stack trace

    • com.sybase.jdbc2.jdbc.SybSQLException: SET CHAINED command not allowed within multi-statement transaction. at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2636) at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:1996) 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:1615) at com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:1598) at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:89) at com.sybase.jdbc2.tds.Tds.setOption(Tds.java:1111) at com.sybase.jdbc2.jdbc.SybConnection.setAutoCommit(SybConnection.java:634) at net.sf.hibernate.id.TableGenerator.generate(TableGenerator.java:85) at net.sf.hibernate.id.TableHiLoGenerator.generate(TableHiLoGenerator.java:59) at net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:774) at net.sf.hibernate.impl.SessionImpl.save(SessionImpl.java:747) at net.sf.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:1397) at net.sf.hibernate.engine.Cascades$4.cascade(Cascades.java:114) at net.sf.hibernate.engine.Cascades.cascade(Cascades.java:436) at net.sf.hibernate.engine.Cascades.cascadeCollection(Cascades.java:526) at net.sf.hibernate.engine.Cascades.cascade(Cascades.java:452) at net.sf.hibernate.engine.Cascades.cascade(Cascades.java:503) at net.sf.hibernate.engine.Cascades.cascade(Cascades.java:482) at net.sf.hibernate.impl.SessionImpl.doUpdate(SessionImpl.java:1484) at net.sf.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:1402) at edu.ucop.ers.domain.base._BaseRootDAO.saveOrUpdate(_BaseRootDAO.java:656) at edu.ucop.ers.domain.base._BaseRootDAO.saveOrUpdate(_BaseRootDAO.java:638) at edu.ucop.ers.domain.base.BaseCustomerDAO.saveOrUpdate(BaseCustomerDAO.java:84) at edu.ucop.erstest.chain.AddOrderCommand.execute(AddOrderCommand.java:63) at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:166) at edu.ucop.ers.erstest.HibernateCommandTest.testAddOrders(HibernateCommandTest.java:92) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at junit.framework.TestCase.runTest(TestCase.java:154) at junit.framework.TestCase.runBare(TestCase.java:127) at junit.framework.TestResult$1.protect(TestResult.java:106) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.framework.TestResult.run(TestResult.java:109) at junit.framework.TestCase.run(TestCase.java:118) at junit.framework.TestSuite.runTest(TestSuite.java:208) at junit.framework.TestSuite.run(TestSuite.java:203) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:421) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:305) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:186)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,