0000212: JMS with MySql Error

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ Issue History ] [ Print ]

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[^]

33 total queries executed.
27 unique queries executed.