Ok.. I found the problem.. It is not related to Cayenne, but to our environment.
So.. the question becomes: how can I integrate Cayenne in an OSGi Environmnet?
Francesco
On Sep 6, 2012, at 5:00 PM, Francesco Romano wrote:
> Hi everybody.
>
> I have a problem with cayenne.
> I migrated a table from having a PK autogenerated by the db on a field ID, to
> a table without autogenerated pks (now my PK is a multi-column table).
>
> The problem is that I have this exception during execution:
>
> [06Sep 16:55:16,714] (CommitObjects@295) WARN KPIServiceImpl - Error
> committing kpiManager.TotalLatencyStat
> org.apache.cayenne.CayenneRuntimeException: [v.3.0 Apr 26 2010 09:59:17]
> Commit Exception
> at
> org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1134)
> at
> org.apache.cayenne.access.DataContext.commitChanges(DataContext.java:1045)
> at kpi.impl.KPIServiceImpl.CommitObjects(KPIServiceImpl.java:285)
> at kpi.impl.KPIServiceImpl.saveObj(KPIServiceImpl.java:2518)
> at impl.KPIServiceImpl.addTotalLatencyStat(KPIServiceImpl.java:989)
> at timertask.JMSMsgStatKPITimerTask.run(JMSMsgStatKPITimerTask.java:47)
> at java.util.TimerThread.mainLoop(Timer.java:512)
> at java.util.TimerThread.run(Timer.java:462)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> 'kpidb.auto_pk_support' doesn't exist
> at sun.reflect.GeneratedConstructorAccessor143.newInstance(Unknown
> Source)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
> at com.mysql.jdbc.Util.getInstance(Util.java:381)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
> at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741)
> at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587)
> at
> org.apache.cayenne.dba.mysql.MySQLPkGenerator.getLongPrimaryKey(MySQLPkGenerator.java:305)
> at
> org.apache.cayenne.dba.mysql.MySQLPkGenerator.longPkFromDatabase(MySQLPkGenerator.java:81)
> 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)
> ... 7 more
>
> But.. date is written into db!!
> This is the db-entity and obj-entity for the table
>
> <db-entity name="TotalLatencyStat">
> <db-attribute name="DataType" type="INTEGER"
> isPrimaryKey="true" isMandatory="true"/>
> <db-attribute name="LatencyMax" type="INTEGER"
> isMandatory="true"/>
> <db-attribute name="LatencyMin" type="INTEGER"
> isMandatory="true"/>
> <db-attribute name="LatencySum" type="INTEGER"
> isMandatory="true"/>
> <db-attribute name="MacAddress" type="VARBINARY"
> isPrimaryKey="true" isMandatory="true" length="128"/>
> <db-attribute name="MsgNumber" type="INTEGER"
> isMandatory="true"/>
> <db-attribute name="NetworkID" type="INTEGER"
> isPrimaryKey="true" isMandatory="true"/>
> <db-attribute name="ServiceType" type="INTEGER"
> isPrimaryKey="true" isMandatory="true"/>
> <db-attribute name="Timestamp" type="BIGINT"
> isPrimaryKey="true" isMandatory="true"/>
> </db-entity>
>
> <obj-entity name="TotalLatencyStat"
> className="com.abodata.plat1.kpiManager.TotalLatencyStat"
> lock-type="optimistic" dbEntityName="TotalLatencyStat">
> <obj-attribute name="dataType" type="int"
> db-attribute-path="DataType"/>
> <obj-attribute name="latencyMax" type="int"
> db-attribute-path="LatencyMax"/>
> <obj-attribute name="latencyMin" type="int"
> db-attribute-path="LatencyMin"/>
> <obj-attribute name="latencySum" type="int"
> db-attribute-path="LatencySum"/>
> <obj-attribute name="macAddress" type="byte[]"
> db-attribute-path="MacAddress"/>
> <obj-attribute name="msgNumber" type="int"
> db-attribute-path="MsgNumber"/>
> <obj-attribute name="networkID" type="int"
> db-attribute-path="NetworkID"/>
> <obj-attribute name="serviceType" type="int"
> db-attribute-path="ServiceType"/>
> <obj-attribute name="timestamp" type="long"
> db-attribute-path="Timestamp"/>
> </obj-entity>
>
> I don't understand the exception above!
> I also tried to put a breakpoint in the source code of cayenne, in particular
> in BatchAction.runAsIndividualQueries.
> generatesKeys is false. I also put a breakpoint inside the then-block of
> if (generatesKeys) {
> processGeneratedKeys(statement, delegate);
> }
> and it is never fired!
>
> I add that I use Cayenne 3.0
>
> Thanks
>
> Francesco Romano
>
>
