Hello, I'm new here and I would appreciate a little help about one problem we are experiencing:
when starting JBoss and running the default server, we get this error:
Could not create table with SQL: CREATE CACHED TABLE JMS_MESSAGES [...] "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CACHED TABLE JMS_MESSAGES ( MESSAGEID INTEGER NOT NULL, DESTINA"
[..]
ERROR [org.jboss.mq.pm.jdbc2.PersistenceManager] Starting failed jboss.mq:service=PersistenceManager
org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: General error, message from server: "Table 'accounts.jms_messages' doesn't exist")
We are using mySQL but, from the commands that JBoss tries to execute, it is clear to me that he tries to call on the configuration file:
hsqldb-jdbc2-service.xml
that uses HSQL
Does anybody know where is the configuration problem? Where are the settings I have to change?
Thank you
Raffaele Litto
Remove the 'hsqldb-jdbc2-service.xml' and replace it with the 'mysql-jdbc2-service.xml' file available in the 'docs\examples\jms' folder.