1 Reply Latest reply on Nov 19, 2003 12:17 PM by Frederic Perez Ordeig

    java.sql.SQLException for "CALL IDENTITY()"

    yushuxin Newbie

      Hi experts,

      I just installed mysql+jboss+nukes on windows2000.

      I can start the jboss and visit :http://localhost:8080/nukes/. I logined in as admin and edited the home page. When I clicked the update html page, it said "An error has occured". I seeked in the server window, find the following error:

      java.sql.SQLException: Syntax error or access violation, message from server: "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 'CALL IDENTITY()' at line 1"

      Who can kindly tell me why and how to solve this problem?


      Thanks

      Harry