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)

Reply via email to