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
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
