Hi,
I'm new to JBoss Nuke and I use JBoss 3.2.2RC2, MySql 3.23.57, mysql-connector-java-2.0.14-bin.jar.
I've made no source code changes.
It compiles OK but after deploying the FAQ module when I try to add a new FAQ from the web interface the following exception occurs (see attached file for further details) :
12:51:56,343 ERROR [Page] Module faq raised a runtime exception when invoking operation faqadd
javax.ejb.TransactionRolledbackLocalException: Error extracting generated key; CausedByException is:
Syntax error or access violation: You have an error in your SQL syntax near 'CALL IDENTITY()' at line 1; CausedByException is:
Error extracting generated key; CausedByException is:
Syntax error or access violation: You have an error in your SQL syntax near 'CALL IDENTITY()' at line 1
...
Any idea? I've also test it using 3.0 and 3.1 mysql connector library and nothing changes.
Thank you
Chris
this is because you have not build nukes with the mysql enabled.
you have to copy the file build/etc/local.properties-mysql to build/local.properties before doing any build operation.
julien