3 Replies Latest reply on Aug 29, 2003 5:18 AM by maciek

    wrong sql generated by jboss?

    maciek Newbie

      hello

      i switched my simple cmp from hypersonic to mysql and then get a strange exception
      java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
      java.rmi.ServerException: EJBException:; nested exception is:
      javax.ejb.EJBException: Load failed; CausedByException is:
      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 'key=1)' at line 1"

      how can i see this sql piece of code?

      what can be the cause of such exception?

      thanks

      ----
      also posted to cmp/persistence forum