1 Reply Latest reply on Nov 1, 2003 7:06 AM by Viet

    FAQ module problem

    chris chris Newbie

      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