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

[yushuxin]

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

[friderman]

I had the same problem.
look at http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t=