[jboss-user] [JBoss Messaging Users] - Re: sybase-persistence-service.xml
do-not-reply at jboss.com
Tue Nov 3 14:41:57 EST 2009
| 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#4263802
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4263802
More information about the jboss-user