Yes. It is also being created on the same schema. The modeler generated it automatically.
Mike Kienenberger <mkienen..mail.com> wrote: I'm not sure if this is relevent in derby, but is your auto_pk_table
being created in the same schema as your other tables? I know that
this can be an issue with schemas in recent versions of hsqldb.
On 2/16/07, Michael Gentry wrote:
> 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 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 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.
>
---------------------------------
8:00? 8:25? 8:40? Find a flick in no time
with theYahoo! Search movie showtime shortcut.
This archive was generated by hypermail 2.0.0 : Fri Feb 16 2007 - 09:06:32 EST