The AUTO_PK_SUPPORT table is used (and created) by Cayenne to generate
primary keys. When you create your DB schema in Cayenne Modeler it
can automatically create that table for you (this is the "Create
Primary Key Support" checkbox option). The easiest thing to do,
probably, is use Cayenne Modeler to generate that table for you (only
select the "Create Primary Key Support" option so you don't overwrite
other tables/etc).
mrg
On Wed, Feb 3, 2010 at 10:00 AM, jmp5167 <jmp516..mail.com> wrote:
>
>
> Andrey Razumovsky wrote:
>>
>> commit exception always has its cause, so you need to investigate (and
>> post
>> here if needed) bottom stack trace of the exception
>>
>> 2010/2/3 jmp5167 <jmp516..mail.com>
>>
>>>
>>> Thanks for you reply. I think I have fixed my initial problem, there was
>>> a
>>> problem with the cayenne.xml file. But now I am having trouble with my
>>> context.commitChanges() line. I am getting this error:
>>>
>>> Exception in thread "main" org.apache.cayenne.CayenneRuntimeException:
>>> [v.3.0RC1 Jan 05 2010 14:44:59] Commit Exception
>>> at
>>> org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1134)
>>> at
>>> org.apache.cayenne.access.DataContext.commitChanges(DataContext.java:1045)
>>> at org.example.cayenne.persistent.Main.main(Main.java:30)
>>>
>>> which doesnt make much sense to me except that I understand that
>>> commitChanges actually sends the data to the database to be saved.
>>> Otherwise I'm lost.
>>> --
>>> View this message in context:
>>> http://n3.nabble.com/Class-is-not-mapped-tp183513p184666.html
>>> Sent from the Cayenne - User mailing list archive at Nabble.com.
>>>
>>
>>
>>
>> --
>> Andrey
>>
>>
>
>
> By bottom stack trace do you mean this:
>
> aused by: java.sql.SQLSyntaxErrorException: Table/View 'AUTO_PK_SUPPORT'
> does not exist.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory40.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.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown
> Source)
> at org.apache.derby.jdbc.Driver40.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.apache.cayenne.conn.ConnectionWrapper.prepareStatement(ConnectionWrapper.java:296)
> at
> org.apache.cayenne.conn.ConnectionWrapper.prepareStatement(ConnectionWrapper.java:302)
> at
> org.apache.cayenne.access.TransactionConnectionDecorator.prepareStatement(TransactionConnectionDecorator.java:167)
> at
> org.apache.cayenne.dba.derby.DerbyPkGenerator.longPkFromDatabase(DerbyPkGenerator.java:69)
> at
> org.apache.cayenne.dba.JdbcPkGenerator.generatePk(JdbcPkGenerator.java:270)
> at
> org.apache.cayenne.access.DataDomainInsertBucket.createPermIds(DataDomainInsertBucket.java:165)
> at
> org.apache.cayenne.access.DataDomainInsertBucket.appendQueriesInternal(DataDomainInsertBucket.java:76)
> at
> org.apache.cayenne.access.DataDomainSyncBucket.appendQueries(DataDomainSyncBucket.java:79)
> at
> org.apache.cayenne.access.DataDomainFlushAction.preprocess(DataDomainFlushAction.java:182)
> at
> org.apache.cayenne.access.DataDomainFlushAction.flush(DataDomainFlushAction.java:134)
> at org.apache.cayenne.access.DataDomain.onSyncFlush(DataDomain.java:824)
> at org.apache.cayenne.access.DataDomain$2.transform(DataDomain.java:791)
> at
> org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:850)
> at org.apache.cayenne.access.DataDomain.onSync(DataDomain.java:788)
> at
> org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1106)
> ... 2 more
> 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.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
> ... 30 more
> Caused by: ERROR 42X05: Table/View 'AUTO_PK_SUPPORT' does not exist.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> at
> org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown
> Source)
> at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown
> Source)
> at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source)
> at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown
> Source)
> at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown
> Source)
> at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
> at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown
> Source)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
> at
> org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
> Source)
> ... 24 more
>
>
> because I was looking at this but the only thing I recognize is that it says
> AUTO_PK_SUPPORT does not exist. I have primary keys set but I dont know
> what the rest of it means
> --
> View this message in context: http://n3.nabble.com/Class-is-not-mapped-tp183513p184713.html
> Sent from the Cayenne - User mailing list archive at Nabble.com.
>
This archive was generated by hypermail 2.0.0 : Wed Feb 03 2010 - 10:38:52 EST