FAQ module problem

[cchris]

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

[julien1]

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