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

[bdamato]

  | 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