Discussions

EJB programming & troubleshooting: Problem with Entity beans in JRun 4.0 and MySQL 4.0.15

Bookmark and Share Get thread feed

  1. Problem with Entity beans in JRun 4.0 and MySQL 4.0.15 (1 messages)

    • Posted by: Mag F
    • Posted on: September 30 2004 11:20 EDT
    Hi,
    I just switched to JRun from WebLogic. I am trying to run a test for an entity bean. I successfully created a data source in JRun. My problem is when I try to create a new entity bean, I got an exception from MySql complaining about the query syntax. It looks like JRun does not build the query correctly. I’ve tested the same bean on MSSQLServer and it worked fine. Any suggestions?
    Thanks,
    Mag
    BTW: I'm using WinXP Pro
    Reply to this

    Threaded Messages (1)

  2. Here is the exception[ Go to top ]

    09/30 15:27:37 error Syntax error or access violation: 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 '"Test" WHERE "id" = '3'' at line 1

    java.sql.SQLException: Syntax error or access violation: 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 '"Test" WHERE "id" = '3'' at line 1

    at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source)
    Reply to this Reply to original