1 Reply Latest reply on Nov 3, 2003 11:18 AM by Darran Lofthouse

    Debugging MySQL CMP

    Paul Malone Newbie

      I am trying to deploy my entity beans using mysql DS. I get the following error which is not ver explicit.... and not very useful:

      Error while creating table; - nested throwable: (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 ')' at line 1")
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:175)


      how can i get a more detailed output of what is the actual sql statement. My guess is that it is a create table statement, but I would like to see it.....

      How do I get to see what the sql being executed actually is?