Hi all! I've setup MySQL and JBoss and have the following problem:
"Caused by: java.sql.SQLException: Syntax error or access violation, message from server: "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 'SELECT TXID FROM JMS_TRANSACTIONS) AND TXOP='A'' at line 1" I read here (http://www.cotsec.com/documentation/installation/j2ee_jboss_mysql/) that this behavior is normal if I don't use JMS ("Note well: You may see the following JMS error - this can safely be ignored if you are not using JMS"). In fact, when I try to setup some queues I run into some problems. I'm using jboss 3.2.3 and MySQL 4.0.11. Is this some known issue or am I missing something?? Thanks. Regards, Tiago View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3835807#3835807 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3835807 ------------------------------------------------------- This SF.Net email is sponsored by: Oracle 10g Get certified on the hottest thing ever to hit the market... Oracle 10g. Take an Oracle 10g class now, and we'll give you the exam FREE. http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user