3 Replies Latest reply on Nov 19, 2003 12:10 PM by Frederic Perez Ordeig

    strange mysql exception in jboss3.2.3

    Frederic Perez Ordeig Newbie

      When I try to do anything in nukes that involves a INSERT I get an exception like the attached one(example from faq adding a faq category but it happens everywhere).
      I think i've done all the steps for building and deploying ok... Might it be a bug?

      my system:

      windows 2000
      mysql Ver 12.20 Distrib 4.0.13, for Win95/Win98 (i32)
      mysql-connector-java-3.0.8-stable-bin.jar
      jboss 3.2.3RC1
      and nukes from CVS two or three days ago.

      Thank you!

      FRiDeRMaN

      -- exception reported -- extract

      2003-11-18 20:19:27,781 ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackLocalException in method: public abstract org.jboss.nukes.addons.modules.faq.ejb.FaqCategoryEJBLocal org.jboss.nukes.addons.modules.faq.ejb.FaqCategoryEJBLocalHome.create(org.jboss.nukes.addons.modules.faq.ejb.FaqCategoryEJBLocal,java.lang.String,java.lang.String) throws javax.ejb.CreateException, causedBy:
      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"
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1651)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:889)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:956)
      at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:928)

      [...] see full exception in attached file