Hi
Version is 1.0 rc3
the stack trace is listed below. We have a feeling that the problem is the length of
some primary key field of a OJB table. There is one error message:
SequenceManagerHelper: Cannot lookup max value from table OJB_DLIST for column ID
thanks for your help
cheers
Mike
PersonBusinessFacadeImpl: findById begin
PersonDBFacadeImplOJB: findById begin
PersonDBFacadeImplOJB: findByPrimaryKey begin
p6spy: 1059049639765|150|5|statement|SELECT
A0.MAX_KEY,A0.TABLENAME,A0.GRAB_SIZE,A0.VERSION,A0.FIELDNAME FROM EUA.OJB_HL_SEQ A0
WHERE (A0.TABLENAME LIKE ? ) AND A0.FIELDNAME LIKE ? |SELECT
A0.MAX_KEY,A0.TABLENAME,A0.GRAB_SIZE,A0.VERSION,A0.FIELDNAME FROM
EUA.OJB_HL_SEQ A0 WHERE (A0.TABLENAME LIKE 'SEQ_OJB_DLIST' ) AND A0.FIELDNAME LIKE
'ID'
p6spy: 1059049639935|70|4|statement||SELECT MAX(ID) FROM OJB_DLIST
SequenceManagerHelper: Cannot lookup max value from table OJB_DLIST for column ID, PB
was [EMAIL PROTECTED], using jdbc-descriptor [EMAIL PROTECTED]
jcd-alias=BITEUADB
default-connection=true
dbms=Db2
jdbc-level=1.0
driver=com.p6spy.engine.spy.P6SpyDriver
protocol=jdbc
sub-protocol=db2
db-alias=//vmwin2000:DB987E
user=db2admin
password=*****
eager-release=false
ConnectionPoolDescriptor={whenExhaustedAction=0, maxIdle=-1, maxActive=21,
maxWait=5000, removeAbandoned=false, numTestsPerEvictionRun=10, testWhileIdle=false,
minEvictableIdleTimeMillis=600000, testOnReturn=false, logAbandoned=false,
removeAbandonedTime
out=300, timeBetweenEvictionRunsMillis=-1, testOnBorrow=true}
batchMode=false
useAutoCommit=AUTO_COMMIT_SET_TRUE_AND_TEMPORARY_FALSE
ignoreAutoCommitExceptions=false
[EMAIL PROTECTED]
sequenceManagerClass=class
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl
Properties={autoNaming=true, globalSequenceId=false, globalSequenceStart=10000,
grabSize=5}
]
]
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0204N
"DB2ADMIN.OJB_DLIST" is an undefined name. SQLSTATE=42704
at
COM.ibm.db2.jdbc.net.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:246)
at
COM.ibm.db2.jdbc.net.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:411)
at
COM.ibm.db2.jdbc.net.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:388)
at COM.ibm.db2.jdbc.net.DB2Statement.execute2(DB2Statement.java:1542)
at COM.ibm.db2.jdbc.net.DB2Statement.executeQuery(DB2Statement.java:1301)
at
com.p6spy.engine.logging.P6LogStatement.executeQuery(P6LogStatement.java:200)
at
org.apache.ojb.broker.util.sequence.SequenceManagerHelper.getMaxIdForClass(Unknown
Source)
at org.apache.ojb.broker.util.sequence.SequenceManagerHelper.getMaxId(Unknown
Source)
at
org.apache.ojb.broker.util.sequence.SequenceManagerHelper.getMaxForExtent(Unknown
Source)
at
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getMaxKeyForSequence(Unknown
Source)
at
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getSequence(Unknown
Source)
at
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUniqueLong(Unknown
Source)
at
org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueId(Unknown
Source)
at
org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueValue(Unknown
Source)
at org.apache.ojb.odmg.collections.DListImpl.generateNewId(Unknown Source)
at org.apache.ojb.odmg.collections.DListImpl.<init>(Unknown Source)
at java.lang.Class.newInstance0(Native Method)
at java.lang.Class.newInstance(Class.java:237)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknown Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknown Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknown Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(Unknown
Source)
at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source)
at
ch.admin.bit.eua.fw.db.DBFacadeImplBaseOJB.getObjectByPrimaryKey(DBFacadeImplBaseOJB.java:571)
at
ch.admin.bit.eua.fw.db.DBFacadeImplBaseOJB.getObjectByPrimaryKey(DBFacadeImplBaseOJB.java:538)
at
ch.admin.bit.eua.fw.db.DBFacadeImplBaseOJB.findByPrimaryKey(DBFacadeImplBaseOJB.java:228)
at
ch.admin.bit.eua.fw.db.DBFacadeImplBaseOJB.findById(DBFacadeImplBaseOJB.java:207)
at
ch.admin.bit.eua.app.db.PersonDBFacadeImplOJB.findById(PersonDBFacadeImplOJB.java:47)
at
ch.admin.bit.eua.app.business.PersonBusinessFacadeImpl.findById(PersonBusinessFacadeImpl.java:92)
at
ch.admin.bit.eua.app.presentation.UserActionDetail.perform(UserActionDetail.java:40)
at ch.admin.bit.eua.fw.presentation.ActionBase.execute(ActionBase.java:88)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:480)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1420)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:502)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:551)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:509)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1040)
at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1151)
at java.lang.Thread.run(Thread.java:484)
-----Ursprüngliche Nachricht-----
Von: Armin Waibel [mailto:[EMAIL PROTECTED]
Gesendet: Do 24.07.2003 14:01
An: OJB Users List
Cc:
Betreff: Re: Problem with a ClassNotPersistenceCapableException
Hi again,
can you post the whole stack trace?
OJB version, used sequence manager?
regards,
Armin
----- Original Message -----
From: "Michael Gysi-Gander" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Thursday, July 24, 2003 1:54 PM
Subject: AW: Problem with a ClassNotPersistenceCapableException
> Hi
>
> yes it is declared. Sorry for not posting the whole config. here it
is:
>
> <class-descriptor
> class="ch.mypackage.Person"
> table="PERSON"
> >
> <field-descriptor id="101"
> name="mnId"
> column="PERSON_ID"
> jdbc-type="INTEGER"
> primarykey="true"
> autoincrement="true"
> />
> <field-descriptor id="102"
> name="mFirstName"
> column="FIRST_NAME"
> jdbc-type="VARCHAR"
> />
> <field-descriptor id="103"
> name="mLastName"
> column="LAST_NAME"
> jdbc-type="VARCHAR"
> />
> <field-descriptor id="104"
> name="mEmail"
> column="EMAIL"
> jdbc-type="VARCHAR"
> />
> <field-descriptor id="105"
> name="mPkiIdentity"
> column="PKI_IDENTITY"
> jdbc-type="VARCHAR"
> />
> </class-descriptor>
> <!-- ================================= -->
> <class-descriptor
> class="ch.mypackage.Role"
> table="ROLE"
> >
> <field-descriptor id="201"
> name="mnId"
> column="ROLE_ID"
> jdbc-type="INTEGER"
> primarykey="true"
> autoincrement="true"
> />
> <field-descriptor id="202"
> name="mName"
> column="NAME"
> jdbc-type="VARCHAR"
> />
> <field-descriptor id="203"
> name="mDescription"
> column="DESCRIPTION"
> jdbc-type="VARCHAR"
> />
> </class-descriptor>
> <!-- ================================= -->
> <class-descriptor
> class="ch.mypackage.Dossier"
> table="DOSSIER"
> >
> <field-descriptor id="301"
> name="mnId"
> column="DOSSIER_ID"
> jdbc-type="INTEGER"
> primarykey="true"
> autoincrement="false"
> />
> <field-descriptor id="302"
> name="mName"
> column="NAME"
> jdbc-type="VARCHAR"
> />
> <field-descriptor id="303"
> name="mDescription"
> column="DESCRIPTION"
> jdbc-type="VARCHAR"
> />
> <collection-descriptor
> name="mAddresses"
> element-class-ref="ch.mypackage.Address"
> proxy="true"
> >
> <inverse-foreignkey field-ref="mnDossierId"/>
> </collection-descriptor>
>
> <collection-descriptor
> name="mPersonRoles"
> element-class-ref="ch.mypackage.PersonRole"
> proxy="true"
> >
> <inverse-foreignkey field-ref="mnDossierId"/>
> </collection-descriptor>
>
> <collection-descriptor
> name="mFormSpecs"
> element-class-ref="ch.mypackage.FormSpec"
> proxy="true"
> >
> <inverse-foreignkey field-ref="mnDossierId"/>
> </collection-descriptor>
>
> </class-descriptor>
> <!-- ================================= -->
> <class-descriptor
> class="ch.mypackage.Address"
> table="ADDRESS"
> >
> <field-descriptor id="401"
> name="mnId"
> column="ADDRESS_ID"
> jdbc-type="INTEGER"
> primarykey="true"
> autoincrement="false"
> />
> <field-descriptor id="402"
> name="mName"
> column="NAME"
> jdbc-type="VARCHAR"
> />
> <field-descriptor id="403"
> name="mName2"
> column="NAME_2"
> jdbc-type="VARCHAR"
> />
> <field-descriptor id="404"
> name="mName3"
> column="NAME_3"
> jdbc-type="VARCHAR"
> />
> <field-descriptor id="405"
> name="mZIP"
> column="ZIP"
> jdbc-type="VARCHAR"
> />
> <field-descriptor id="406"
> name="mCity"
> column="CITY"
> jdbc-type="VARCHAR"
> />
> <field-descriptor id="407"
> name="mnDossierId"
> column="DOSSIER_ID"
> jdbc-type="INTEGER"
> />
>
>
> </class-descriptor>
> <!-- ================================= -->
> <class-descriptor
> class="ch.mypackage.Property"
> table="PROPERTY"
> >
> <field-descriptor id="501"
> name="mKey"
> column="PROP_KEY"
> jdbc-type="VARCHAR"
> primarykey="true"
> autoincrement="false"
> />
> <field-descriptor id="502"
> name="mValue"
> column="PROP_VALUE"
> jdbc-type="VARCHAR"
> />
> </class-descriptor>
> <!-- ================================= -->
> <class-descriptor
> class="ch.mypackage.FormNine"
> table="FORM_NINE"
> >
> <field-descriptor id="601"
> name="mnId"
> column="FORM_NINE_ID"
> jdbc-type="INTEGER"
> primarykey="true"
> autoincrement="false"
> />
> <!--
> <field-descriptor id="602"
> name="mnFormSpecId"
> column="FORM_SPEC_ID"
> jdbc-type="INTEGER"
> />
> -->
> <field-descriptor id="603"
> name="mDueDate"
> column="DUE_DATE"
> jdbc-type="DATE"
> />
> <field-descriptor id="604"
> name="mAmountOne"
> column="AMOUNT_ONE"
> jdbc-type="DECIMAL"
> />
> <field-descriptor id="605"
> name="mAmountTwo"
> column="AMOUNT_TWO"
> jdbc-type="DECIMAL"
> />
> <field-descriptor id="606"
> name="mCity"
> column="CITY"
> jdbc-type="VARCHAR"
> />
> <field-descriptor id="607"
> name="mPhone"
> column="PHONE"
> jdbc-type="VARCHAR"
> />
> <field-descriptor id="607"
> name="mEmail"
> column="EMAIL"
> jdbc-type="VARCHAR"
> />
> <field-descriptor id="608"
> name="mStatus"
> column="STATUS"
> jdbc-type="VARCHAR"
> />
> <field-descriptor id="609"
> name="mnFormSpecId"
> column="FORM_SPEC_ID"
> jdbc-type="INTEGER"
> />
> </class-descriptor>
> <!-- ================================= -->
> <class-descriptor
> class="ch.mypackage.PersonRole"
> table="PERSON_ROLE"
> >
> <field-descriptor id="701"
> name="mnId"
> column="PERSON_ID"
> jdbc-type="INTEGER"
> />
> <field-descriptor id="702"
> name="mnRoleId"
> column="ROLE_ID"
> jdbc-type="INTEGER"
> />
> <field-descriptor id="703"
> name="mnDossierId"
> column="DOSSIER_ID"
> jdbc-type="INTEGER"
> />
> </class-descriptor>
> <!-- ================================= -->
> <class-descriptor
> class="ch.mypackage.FormSpec"
> table="FORM_SPEC"
> >
> <field-descriptor id="801"
> name="mnId"
> column="FORM_SPEC_ID"
> jdbc-type="INTEGER"
> primarykey="true"
> autoincrement="false"
> />
> <field-descriptor id="802"
> name="mMinSigCnt"
> column="MIN_SIG_CNT"
> jdbc-type="INTEGER"
> />
> <field-descriptor id="803"
> name="mnDossierId"
> column="DOSSIER_ID"
> jdbc-type="INTEGER"
> />
> </class-descriptor>
>
> -----Ursprüngliche Nachricht-----
> Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
> Gesendet: Do 24.07.2003 13:23
> An: [EMAIL PROTECTED]
> Cc:
> Betreff: AW: Problem with a ClassNotPersistenceCapableException
>
>
>
> Hi,
>
> but where ist ch.mypackage.PersonRole of your collection descriptor
declared
> in your repository?
>
> <collection-descriptor
> name="mPersonRoles"
> element-class-ref="ch.mypackage.PersonRole"
> ^^^^^^^^^^^^^^^^^^^^^^^^
> proxy="true"
> >
>
> Julia.
>
> -----Ursprüngliche Nachricht-----
> Von: Michael Gysi-Gander [mailto:[EMAIL PROTECTED]
> Gesendet: Donnerstag, 24. Juli 2003 13:19
> An: OJB Users List
> Betreff: AW: Problem with a ClassNotPersistenceCapableException
>
>
> Hi
>
> both is declared (see below). Read operation work, but insert and
update
> don't
>
> thanks for any help
> cheers
> Mike
>
> <class-descriptor
> class="ch.mypackage.Person"
> table="PERSON"
> >
> <field-descriptor id="101"
> name="mnId"
> column="PERSON_ID"
> jdbc-type="INTEGER"
> primarykey="true"
> autoincrement="true"
> />
> <field-descriptor id="102"
> name="mFirstName"
> column="FIRST_NAME"
> jdbc-type="VARCHAR"
> />
> <field-descriptor id="103"
> name="mLastName"
> column="LAST_NAME"
> jdbc-type="VARCHAR"
> />
> <field-descriptor id="104"
> name="mEmail"
> column="EMAIL"
> jdbc-type="VARCHAR"
> />
> <field-descriptor id="105"
> name="mPkiIdentity"
> column="PKI_IDENTITY"
> jdbc-type="VARCHAR"
> />
> <collection-descriptor
> name="mPersonRoles"
> element-class-ref="ch.mypackage.PersonRole"
> proxy="true"
> >
> <inverse-foreignkey field-ref="mnPersonId"/>
> </collection-descriptor>
> </class-descriptor>
>
>
> repository.xml:
> <!DOCTYPE descriptor-repository
>
> SYSTEM "repository.dtd" [
>
> <!ENTITY internal SYSTEM "repository_internal.xml">
>
> <!ENTITY jdbc SYSTEM "repository_jdbc.xml">
>
> <!ENTITY user SYSTEM "repository_user.xml">
>
> ]
>
> >
>
> <descriptor-repository version="1.0"
isolation-level="read-uncommitted">
>
> &jdbc; <!-- include jdbc settings here -->
>
> &user; <!-- include user defined mappings here -->
>
> &internal; <!-- include ojb internal mappings here -->
>
> </descriptor-repository>
>
> -----Ursprüngliche Nachricht-----
> Von: Armin Waibel [mailto:[EMAIL PROTECTED]
> Gesendet: Do 24.07.2003 12:18
> An: OJB Users List
> Cc:
> Betreff: Re: Problem with a
ClassNotPersistenceCapableException
>
>
>
> Hi,
>
> seems ch.mypackage.Person is not declared in the repository
> file, or the sub-file (e.g. repository_user.xml) is not
included
> in repository.xml file.
>
> regards,
> Armin
>
> ----- Original Message -----
> From: "Michael Gysi-Gander" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, July 24, 2003 12:01 PM
> Subject: Problem with a ClassNotPersistenceCapableException
>
>
> > Hi
> >
> > We have a problem when attempting write to the db - what we
get is
> >
> >
> org.apache.ojb.broker.metadata.ClassNotPersistenceCapableException:
> Could not init Identity for given object class
ch.mypackage.Person:
> Object has been modified by someone else]
> >
> > What is happening here? I get the same error when I attempt
to
> insert
> a new "Person" record
> >
> > thanks for any help
> > cheers
> > Mike
> >
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
>
------------------------------------------------------------------------
--------
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
