Please have a look on mapping. I can't find any wrong configuration. It must be an bug inside castor.
Thank in advance for any hints, solutions or wathever. Iam at lost (oncemore again).
I can't see that you specify any key-generator, please take a look at http://www.castor.org/key-generator.html and see if that helps.
Stein
Greets
Andre Teubner
Appendix:
[1] BradenScale mapping <class name="com.morixs.mcare.bo.holder.care.braden.BradenScale" identity="id"> <map-to xml="BradenScale" table="BRADEN_SCALE"/> <field name="id" type="java.lang.Integer"> <sql name="ID"/> <bind-xml name="id" node="attribute"/> </field> <field name="createdFrom" type="com.morixs.mcare.bo.holder.misc.CareGiver"> <sql name="CREATED_FROM"/> <bind-xml name="createdFrom" node="element"/> </field> <field name="createdOn" type="date"> <sql name="CREATED_ON"/> <bind-xml name="createdOn" node="element"/> </field> <field name="invalidatedFrom" type="com.morixs.mcare.bo.holder.misc.CareGiver"> <sql name="INVALIDATED_FROM"/> <bind-xml name="invalidatedFrom" node="element"/> </field> <field name="invalidatedOn" type="date"> <sql name="INVALIDATED_ON"/> <bind-xml name="invalidatedOn" node="element"/> </field> <field name="invalidScale" type="boolean" get-method="isInvalidScale" set-method="setInvalidScale"> <sql name="IS_INVALID"/> <bind-xml name="invalidScale" node="element"/> </field> <field name="patientId" type="java.lang.Integer"> <sql name="PATIENT_ID"/> <bind-xml name="patientId" node="element"/> </field> <field name="questionsList" type="com.morixs.mcare.bo.holder.misc.scalelist.AnsweredQuestionList"> <sql name="QUESTION_LIST"/> <bind-xml name="questionsList" node="element"/> </field> </class>
[2] CareGiver mapping
<class name="com.morixs.mcare.bo.holder.misc.CareGiver" extends="com.morixs.mcare.util.usermanagement.User" identity="id"> <description>Eine Pflegekraft</description> <map-to table="CARE_GIVER" xml="CareGiver"/> <field name="id" type="java.lang.Integer"> <sql name="ID"/> <bind-xml name="id" node="attribute" transient="true"/> </field> <field name="externalKey" type="java.lang.Integer"> <sql name="EXTERNAL_KEY"/> <bind-xml name="externalKey" node="element" transient="true"/> </field> <field name="memberInWards" type="com.morixs.mcare.bo.holder.misc.Ward" collection="collection"> <sql many-table="CAREGIVERS_TO_WARDS" many-key="CAREGIVER_ID"/> <bind-xml name="memberInWards" node="element" transient="true"/> </field> </class>
[3] stacktrace
2005-04-27 10:12:25,998 [RMI TCP Connection(88)-127.0.0.1] FATAL A1 - CanÂt commit transaction || SessionCastorContext.commitTransaction() L: 268 org.exolab.castor.jdo.TransactionAbortedException: Nested error: java.lang.ClassCastException: java.lang.Integer: java.lang.Integer at org.exolab.castor.persist.TransactionContext.prepare(TransactionContext.java:1654) at org.exolab.castor.jdo.engine.DatabaseImpl.commit(DatabaseImpl.java:545) at com.morixs.mcare.ct.SessionCastorContext.commitTransaction(SessionCastorContext.java:264) at com.morixs.mcare.uc.care.braden.BradenScaleUC.invalidateBradenScale(BradenScaleUC.java:306) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source) at sun.rmi.transport.Transport$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at sun.rmi.transport.Transport.serviceCall(Unknown Source) at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.ClassCastException: java.lang.Integer at org.exolab.castor.jdo.engine.SQLTypes$13.convert(SQLTypes.java:733) at org.exolab.castor.jdo.engine.SQLEngine.toJava(SQLEngine.java:471) at org.exolab.castor.jdo.engine.SQLEngine.store(SQLEngine.java:922) at org.exolab.castor.persist.ClassMolder.store(ClassMolder.java:1620) at org.exolab.castor.persist.LockEngine.store(LockEngine.java:755) at org.exolab.castor.persist.TransactionContext.prepare(TransactionContext.java:1599) ... 14 more java.lang.ClassCastException: java.lang.Integer at org.exolab.castor.jdo.engine.SQLTypes$13.convert(SQLTypes.java:733) at org.exolab.castor.jdo.engine.SQLEngine.toJava(SQLEngine.java:471) at org.exolab.castor.jdo.engine.SQLEngine.store(SQLEngine.java:922) at org.exolab.castor.persist.ClassMolder.store(ClassMolder.java:1620) at org.exolab.castor.persist.LockEngine.store(LockEngine.java:755) at org.exolab.castor.persist.TransactionContext.prepare(TransactionContext.java:1599) at org.exolab.castor.jdo.engine.DatabaseImpl.commit(DatabaseImpl.java:545) at com.morixs.mcare.ct.SessionCastorContext.commitTransaction(SessionCastorContext.java:264) at com.morixs.mcare.uc.care.braden.BradenScaleUC.invalidateBradenScale(BradenScaleUC.java:306) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source) at sun.rmi.transport.Transport$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at sun.rmi.transport.Transport.serviceCall(Unknown Source) at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source) at java.lang.Thread.run(Unknown Source)
[4] update code
/* * (non-Javadoc) * * @see com.morixs.mcare.ds.IBradenScaleDS#updateBradenScale(com.morixs.mcare.bo.holder.care.braden.BradenScale, * com.morixs.mcare.ct.ISessionContext) */ public BradenScale updateBradenScale(BradenScale pScale, ISessionContext pCtx) throws DataStorageException { try { ISessionCastorContext ctx = (ISessionCastorContext) pCtx; Database db = ctx.getDatabase();
BradenScale bradenScale = (BradenScale) db.load(BradenScale.class, pScale.getId()); bradenScale.setInvalidScale(pScale.isInvalidScale()); bradenScale.setInvalidatedOn(pScale.getInvalidatedOn());
if(pScale.getInvalidatedFrom()!=null){ CareGiver careGiver = (CareGiver) db.load(CareGiver.class,pScale.getInvalidatedFrom().getId()); bradenScale.setInvalidatedFrom(careGiver);
}else{ bradenScale.setInvalidatedFrom(null); }
return pScale; } catch (Exception ex) { pCtx.errorOccurred(); Log.getInstance().fatal(ex.getMessage(), ex); throw new DataStorageException("Fehler beim Update der Bradenskala"); } }
