Discussions

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

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

    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

    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)