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

From: Alan Baltazar (acatalan..ahoo.com)
Date: Tue Apr 04 2006 - 12:18:06 EDT

  • Next message: Andrea Borgogelli Avveduti: "It's a long night.."

      It's working now. Thanks!

    --- Andrus Adamchik <andru..bjectstyle.org> wrote:

    > 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)
    >
    >

    __________________________________________________
    Do You Yahoo!?
    Tired of spam? Yahoo! Mail has the best spam protection around
    http://mail.yahoo.com

    This archive was generated by hypermail 2.0.0 : Tue Apr 04 2006 - 12:18:35 EDT