Re: AUTO_PK_SUPPORT Error

From: Michael Gentry (blacknex..mail.com)
Date: Fri Feb 16 2007 - 08:21:05 EST

  • Next message: Mike Kienenberger: "Re: AUTO_PK_SUPPORT Error"

    Can you send us the SQL (when you choose Generate Database Schema) it
    is showing so we can see the PK statements the modeler is generating
    for you?

    Thanks,

    /dev/mrg

    On 2/16/07, Pogs <bloo_clo..ahoo.com> wrote:
    > The only options available are as follows:
    >
    > Drop Tables (unchecked)
    > Drop Primary Key Support (unchecked)
    > Create Tables (checked)
    > Create FK Support (checked)
    > Create Primary Key Support (checked
    >
    > I believe these should create the table AUTO_PK_SUPPORT as I can see it on the SQL convertion. But still I receive this exception. What other strategies should I use for generating my primary keys? Please advice.
    >
    > Thanks,
    > Jeff
    >
    > Mike Kienenberger <mkienen..mail.com> wrote: Open up the Cayenne modeler, go to the generate schema panel, and
    > generate your primary key information to create and setup this table.
    >
    > Alternately, choose a different primary key generation strategy other
    > than the default.
    >
    > On 2/15/07, Pogs wrote:
    > > Please advice on what to with the following error.
    > >
    > > Thanks,
    > > Jeff
    > >
    > > Complete Stacktrace:
    > >
    > > INFO QueryLogger: Created connection pool: jdbc:derby:testdb;create=true
    > > Driver class: org.apache.derby.jdbc.EmbeddedDriver
    > > Min. connections in the pool: 1
    > > Max. connections in the pool: 1
    > > INFO QueryLogger: Opening connection: jdbc:derby:testdb;create=true
    > > Login: null
    > > Password: *******
    > > INFO QueryLogger: +++ Connecting: SUCCESS.
    > > INFO QueryLogger: Detected and installed adapter: org.objectstyle.cayenne.dba.derby.DerbyAdapter
    > > INFO QueryLogger: SELECT NEXT_ID FROM AUTO_PK_SUPPORT WHERE TABLE_NAME = ? FOR UPDATE [bind: 'ARTIST']
    > > INFO QueryLogger: --- transaction started.
    > > INFO QueryLogger: Opening connection: jdbc:derby:testdb;create=true
    > > Login: null
    > > Password: *******
    > > INFO QueryLogger: +++ Connecting: SUCCESS.
    > > Exception in thread "main" org.objectstyle.cayenne.CayenneRuntimeException: [v.1.2.1 August 30 2006] Commit Exception
    > > at org.objectstyle.cayenne.access.DataContext.flushToParent(DataContext.java:1289)
    > > at org.objectstyle.cayenne.access.DataContext.commitChanges(DataContext.java:1165)
    > > at src.cayenne.tutorial.Main.main(Main.java:30)
    > > Caused by: java.sql.SQLException: Table/View 'AUTO_PK_SUPPORT' does not exist.
    > > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
    > > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
    > > at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
    > > at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
    > > at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
    > > at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
    > > at org.apache.derby.impl.jdbc.EmbedPreparedStatement.(Unknown Source)
    > > at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.(Unknown Source)
    > > at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.(Unknown Source)
    > > at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)
    > > at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
    > > at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
    > > at org.objectstyle.cayenne.conn.ConnectionWrapper.prepareStatement(ConnectionWrapper.java:325)
    > > at org.objectstyle.cayenne.conn.ConnectionWrapper.prepareStatement(ConnectionWrapper.java:331)
    > > at org.objectstyle.cayenne.access.TransactionConnectionDecorator.prepareStatement(TransactionConnectionDecorator.java:196)
    > > at org.objectstyle.cayenne.dba.derby.DerbyPkGenerator.pkFromDatabase(DerbyPkGenerator.java:91)
    > > at org.objectstyle.cayenne.dba.JdbcPkGenerator.generatePkForDbEntity(JdbcPkGenerator.java:326)
    > > at org.objectstyle.cayenne.access.DataDomainInsertBucket.createPermIdsForObjEntity(DataDomainInsertBucket.java:194)
    > > at org.objectstyle.cayenne.access.DataDomainInsertBucket.appendQueriesInternal(DataDomainInsertBucket.java:122)
    > > at org.objectstyle.cayenne.access.DataDomainSyncBucket.appendQueries(DataDomainSyncBucket.java:108)
    > > at org.objectstyle.cayenne.access.DataDomainFlushAction.preprocess(DataDomainFlushAction.java:211)
    > > at org.objectstyle.cayenne.access.DataDomainFlushAction.flush(DataDomainFlushAction.java:167)
    > > at org.objectstyle.cayenne.access.DataDomain.onSyncFlush(DataDomain.java:830)
    > > at org.objectstyle.cayenne.access.DataDomain$2.transform(DataDomain.java:801)
    > > at org.objectstyle.cayenne.access.DataDomain.runInTransaction(DataDomain.java:856)
    > > at org.objectstyle.cayenne.access.DataDomain.onSync(DataDomain.java:798)
    > > at org.objectstyle.cayenne.access.DataContext.flushToParent(DataContext.java:1261)
    > > ... 2 more
    > >
    > >
    > >
    > > ---------------------------------
    > > Now that's room service! Choose from over 150,000 hotels
    > > in 45,000 destinations on Yahoo! Travel to find your fit.
    >
    >
    >
    > ---------------------------------
    > Be a PS3 game guru.
    > Get your game face on with the latest PS3 news and previews at Yahoo! Games.

    This archive was generated by hypermail 2.0.0 : Fri Feb 16 2007 - 08:21:40 EST