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: