Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (herse.apache.org: domain of blacknext@gmail.com designates
 64.233.166.177 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=s2XgCRcdzzCoo49EBfR+HY/lJTWbF410AjkUVKM+iRf3Ks03dpXdm2r10KJL0Euvs4PrUGLEXpXWefVOsf+ITCx5rtRNPW5tDY2lE/n2zESgyu46tCsrXQWk80yDloVvw03meMB1l0TLjN10PzqvrbBV9wTds+cedEOV11gp7GI=
Message-ID: <f65b8ae30702160521h107048f3rcc6a63fadf15e5c7@mail.gmail.com>
Date: Fri, 16 Feb 2007 08:21:05 -0500
From: "Michael Gentry" <blacknext@gmail.com>
To: user@cayenne.apache.org
Subject: Re: AUTO_PK_SUPPORT Error
In-Reply-To: <110923.25994.qm@web53704.mail.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <8f985b960702150722m314211d3vd111d48249c87b5f@mail.gmail.com>
	 <110923.25994.qm@web53704.mail.yahoo.com>

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_cloo@yahoo.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 <mkienenb@gmail.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.