[jboss-user] [JCA/JBoss] - Re: MSSQL XA datasource throws RollbackException on cluster

[vickyk]

No you don't need to  create SQL function , the org.jboss.mq.pm.jdbc2.PersistenceManager takes care of creation of the tables . Table creation is controlled by defining the sqlproperties , have a look at 
http://wiki.jboss.org/wiki/Wiki.jsp?page=ConfigJBossMQStateJDBC

I don't understand why the setting of CREATE_TABLES_ON_STARTUP= false is still creating the SQL tables , you seem to be doing something wrong . You should  enable trace logging for org.jboss.mq to  troubleshoot this issue .
Go to the Jboss Messaging user forum , this issues is not JCA related .

Let me point out the code which reads the CREATE_TABLES_ON_STARTUP property 

  |  public void startService() throws Exception
  |    {
  | .....................................
  |       createTables = sqlProperties.getProperty("CREATE_TABLES_ON_STARTUP", "true").equalsIgnoreCase("true");
  | ......................................
  |       }
  | 
  | 
  | 
  | 
if (createTables)
  |          {
  |             c = this.getConnection();
  | 
  |             boolean createdMessageTable = false;
  |             try
  |             {
  |                stmt = c.prepareStatement(CREATE_MESSAGE_TABLE);
  |                stmt.executeUpdate();
  |                createdMessageTable = true;
http://anonsvn.jboss.org/repos/jbossas/branches/Branch_4_0/messaging/src/main/org/jboss/mq/pm/jdbc2/PersistenceManager.java
http://anonsvn.jboss.org/repos/jbossas/branches/Branch_4_0/messaging/src/main/org/jboss/mq/pm/jdbc2/MSSQLPersistenceManager.java

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4113178#4113178

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4113178