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 View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3849975#3849975 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3849975 ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
