[jboss-user] [JBoss Messaging Users] - Re: sybase-persistence-service.xml

| 2009-11-03 14:21:44,515 DEBUG [org.jboss.messaging.core.impl.JDBCSupport] (main) Failed to execute: CREATE TABLE JBM_MSG_REF (MESSAGE_ID DECIMAL(19, 0) NOT NULL, CHANNEL_ID DECIMAL(19, 0) NOT NULL, TRANSACTION_ID DECIMAL(19, 0) NULL, STATE CHAR(1), ORD DECIMAL(19, 0), PAGE_ORD DECIMAL(19, 0) NULL, DELIVERY_COUNT INTEGER, SCHED_DELIVERY DECIMAL(19, 0), PRIMARY KEY(MESSAGE_ID, CHANNEL_ID)) | com.sybase.jdbc3.jdbc.SybSQLException: The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'JBOSS' database. | I found how to configure it in Sybase to allow this (sp_dboption JBOSS, "allow ddl in tran", true), but I'm wondering if there's a way to configure the connection in the connection pool so it doesn't behave like that. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4263802#... Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...