Re: commit error with cayenne 1.1.4 ,tomcat 5 and mysql 5

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Tue Apr 04 2006 - 11:58:17 EDT

  • Next message: Alan Baltazar: "Re: commit error with cayenne 1.1.4 ,tomcat 5 and mysql 5"

    Cool, now I see what it is - a special table used to store generated
    PK has not been created. In the Modeler go to "Tools -> generate
    Database Schema" and uncheck all checkboxes except for "Create
    Primary Key Support" and then click "generate":

    http://objectstyle.org/confluence/display/CAYDOC/Generate+Primary+Key
    +Support

    Andrus

    On Apr 4, 2006, at 7:52 PM, Alan Baltazar wrote:

    > Caused by: java.sql.SQLException: Table 'art.auto_pk_support'
    > doesn't exist
    > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
    > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
    > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
    > at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
    > at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)
    > at com.mysql.jdbc.Statement.execute(Statement.java:529)
    > at org.objectstyle.cayenne.dba.mysql.MySQLPkGenerator.getPrimaryKey
    > (MySQLPkGenerator.java:161)
    > at
    > org.objectstyle.cayenne.dba.mysql.MySQLPkGenerator.pkFromDatabase
    > (MySQLPkGenerator.java:93)
    > at
    > org.objectstyle.cayenne.dba.JdbcPkGenerator.generatePkForDbEntity
    > (JdbcPkGenerator.java:325)

    This archive was generated by hypermail 2.0.0 : Tue Apr 04 2006 - 11:58:43 EDT