| 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...