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