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:00:43 EST