0 Replies Latest reply on Feb 25, 2002 10:29 AM by Chris Davis

    multi-statement transaction error

    Chris Davis Newbie

      I'm trying to port a weblogic/solaris ejb app to jboss/jetty/linux. I using the current stable jboss 2.4.4. I'm using sybase as my databases (will move to postgress after I get my java into jboss/jetty).

      I got most things working (kudos to the jboss developers!), but I'm running into this error with some of my SQL stored procs:

      [ERROR,Default] com.sybase.jdbc2.jdbc.SybSQLException: The 'CREATE TABLE' comman
      d is not allowed within a multi-statement transaction in the 'tempdb' database.


      Is there a way to lower the transaction level or turn it off? or anyother way I can fix this error sans editing my stored procs. I don't mind lossing transaction support for the time being.

      Here's my connection XML from jboss.jcml:


      KRSSchoolDB
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl

      jdbc:sybase:Tds:application:4100/KRSSchoolDB_prod
      1200000
      user
      16
      password
      false
      false
      false
      true
      120000
      1800000
      false
      false
      1.0
      0