Mantis Bugtracker
  

Viewing Issue Simple Details Jump to Notes ] View Advanced ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0000212 [Resin] minor always 05-24-05 00:00 11-30-05 14:44
Reporter user196 View Status public  
Assigned To
Priority normal Resolution fixed  
Status closed   Product Version 3.0.13
Summary 0000212: JMS with MySql Error
Description RSN-231
[09:58:12.173] creating JMS subscriber table resin_jms_consumer
[09:58:12.183] com.caucho.config.LineConfigException: C:\Java\resin-3.0.13\conf/resin.conf:281: java.sql.SQLException: 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 'read BIGINT, ack BIGINT)' at line 1

Here's the JMS configuration in resin.conf file.


    <resource jndi-name="jms/QFactory/Email" type="com.caucho.jms.ConnectionFactoryImpl">
      <init>
        <data-source>jdbc/MySQL/Email</data-source>
      </init>
    </resource>
    
    <resource jndi-name="jms/Q/Email" type="com.caucho.jms.jdbc.JdbcQueue">
      <init>
        <queue-name>LessonEmailQ</queue-name>
        <data-source>jdbc/MySQL/Email</data-source>
      </init>
    </resource>
Additional Information resin-3.0.13, JDK 1.5_03, WindowsXP, MySQL v4.1.12-nt, mysql-connector-java-3.1.8-bin.jar
Attached Files

- Relationships

- Notes
(0000245)
ferg
05-24-05 00:00

ejb/67a0
 

- Issue History
Date Modified Username Field Change
05-24-05 00:00 user196 New Issue
11-30-05 00:00 administrator Fixed in Version  => 3.0.14
11-30-05 14:44 ferg Status resolved => closed


Mantis 1.0.0rc3[^]
Copyright © 2000 - 2005 Mantis Group
33 total queries executed.
27 unique queries executed.
Powered by Mantis Bugtracker