0000212: JMS with MySql Error

Viewing Issue Advanced Details [ Jump to Notes ]

[ View Simple ] [ 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

Platform

Status

closed

Projection

none

OS Version

ETA

none

Fixed in Version

3.0.14

Product Version

3.0.13

Product Build

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>

Steps To Reproduce

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.