That worked Armin, thanks! One question though, those mappings were correct, and should work, right? Will it hurt anything to not have them in there?
I created a Junit Test. It works with those mappings removed, but fails when the lines are there. Would you like me to send it to you? -----Original Message----- From: Armin Waibel [mailto:[EMAIL PROTECTED] Sent: Thursday, March 24, 2005 10:25 AM To: OJB Users List Subject: Re: Problem retrieving collection. Lemke, Wesley wrote: > Hehe, that was my originally question when I changed it from objectId > to clientRelationshipId :) > I run a test case with same mapping (1:n with 1:1 back-reference and shared FK) with latest from OJB_1_0_RELEASE branch. The test pass without problems. Maybe the problem is the inheritance, I haven't tried this in my test case. <class-descriptor class="model.AdmObject"> <extent-class class-ref="model.client.ClientRelationship" /> <extent-class class-ref="model.client.GenericGroup" /> </class-descriptor> <class-descriptor class="model.client.GenericGroup"> <extent-class class-ref="model.client.NewClientGroup" /> </class-descriptor> Remove these mapping and run your test again. regards, Armin > Here is the entire stack trace: > > [3/24/05 9:08:43:844 CST] 1985c96 SystemOut O > [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: > SQL:SELECT A0.agr_approver,A0.client_id FROM client A0 [3/24/05 > 9:08:43:874 CST] 1985c96 ConnectionFac I J2CA0122I: Resource > reference jdbc/ao79 could not be located, so default values of the > following are used: [Resource-ref settings] > > res-auth: 1 (APPLICATION) > res-isolation-level: 0 (TRANSACTION_NONE) > res-sharing-scope: true (SHAREABLE) > res-resolution-control: 999 (undefined) > [Other attributes] > > isCMP1_x: false (not CMP1.x) > isJMS: false (not JMS) > > [3/24/05 9:08:44:064 CST] 1985c96 SystemOut O > [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: > SQL:SELECT A0.CLASS_NAME,A0.group_id,A0.NAME,A0.client_id FROM > client_group A0 WHERE ( A0.client_id = ?) AND (A0.CLASS_NAME = ?) > [3/24/05 9:08:44:094 CST] 1985c96 SystemErr R > org.apache.ojb.broker.OJBRuntimeException: Incorrect or not found > field reference name 'clientRelationshipId' in descriptor > [EMAIL PROTECTED] > et > rieve=true,cascade_store=object,cascade_delete=object,is_lazy=false,clas > s_of_Items=class model.client.NewClientGroup] for class-descriptor > 'model.client.ClientRelationship' > at > org.apache.ojb.broker.metadata.ObjectReferenceDescriptor.getForeignKeyFi > eldDescriptors(Unknown Source) > at > org.apache.ojb.broker.metadata.ObjectReferenceDescriptor.getForeignKeyVa > lues(Unknown Source) > at > org.apache.ojb.broker.accesslayer.CollectionPrefetcher.associateBatched( > Unknown Source) > at > org.apache.ojb.broker.accesslayer.BasePrefetcher.prefetchRelationship(Un > known Source) > at > org.apache.ojb.broker.core.QueryReferenceBroker.performRetrievalTasks(Un > known Source) > at > org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unk > nown Source) > at > org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unk > nown Source) > at > org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unk > nown Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Un > known Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQu > ery(Unknown Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQu > ery(Unknown Source) > at > servlets.InheritanceServlet.printGroups(InheritanceServlet.java:123) > at > servlets.InheritanceServlet.doPost(InheritanceServlet.java:75) > at servlets.InheritanceServlet.doGet(InheritanceServlet.java:44) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictSe > rvletInstance.java:110) > at > com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLi > fecycleServlet.java:174) > at > com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycle > Servlet.java:313) > at > com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLif > ecycleServlet.java:116) > at > com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance. > java:283) > at > com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(Vali > dServletReferenceState.java:42) > at > com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(Servle > tInstanceReference.java:40) > at > com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispa > tch(WebAppRequestDispatcher.java:948) > at > com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRe > questDispatcher.java:530) > at > com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppReq > uestDispatcher.java:176) > at > com.ibm.ws.webcontainer.servlet.InvokerServlet.service(InvokerServlet.ja > va:255) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictSe > rvletInstance.java:110) > at > com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLi > fecycleServlet.java:174) > at > com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycle > Servlet.java:313) > at > com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLif > ecycleServlet.java:116) > at > com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance. > java:283) > at > com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(Vali > dServletReferenceState.java:42) > at > com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(Servle > tInstanceReference.java:40) > at > com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispa > tch(WebAppRequestDispatcher.java:948) > at > com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRe > questDispatcher.java:530) > at > com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppReq > uestDispatcher.java:176) > at > com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:7 > 9) > at > com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInv > oker.java:201) > at > com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocati > on(CachedInvocation.java:71) > at > com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(Servle > tRequestProcessor.java:182) > at > com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSELis > tener.java:334) > at > com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection > .java:56) > at > com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java: > 610) > at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:431) > at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593) > [3/24/05 9:08:47:930 CST] 1985c96 WebGroup E SRVE0026E: [Servlet > Error]-[servlets.InheritanceServlet]: > org.apache.ojb.broker.PersistenceBrokerException: > org.apache.ojb.broker.OJBRuntimeException: Incorrect or not found field > reference name 'clientRelationshipId' in descriptor > [EMAIL PROTECTED] > rieve=true,cascade_store=object,cascade_delete=object,is_lazy=false,clas > s_of_Items=class model.client.NewClientGroup] for class-descriptor > 'model.client.ClientRelationship' > at > org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unk > nown Source) > at > org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unk > nown Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Un > known Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQu > ery(Unknown Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQu > ery(Unknown Source) > at > servlets.InheritanceServlet.printGroups(InheritanceServlet.java:123) > at > servlets.InheritanceServlet.doPost(InheritanceServlet.java:75) > at servlets.InheritanceServlet.doGet(InheritanceServlet.java:44) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictSe > rvletInstance.java:110) > at > com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLi > fecycleServlet.java:174) > at > com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycle > Servlet.java:313) > at > com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLif > ecycleServlet.java:116) > at > com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance. > java:283) > at > com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(Vali > dServletReferenceState.java:42) > at > com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(Servle > tInstanceReference.java:40) > at > com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispa > tch(WebAppRequestDispatcher.java:948) > at > com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRe > questDispatcher.java:530) > at > com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppReq > uestDispatcher.java:176) > at > com.ibm.ws.webcontainer.servlet.InvokerServlet.service(InvokerServlet.ja > va:255) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictSe > rvletInstance.java:110) > at > com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLi > fecycleServlet.java:174) > at > com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycle > Servlet.java:313) > at > com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLif > ecycleServlet.java:116) > at > com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance. > java:283) > at > com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(Vali > dServletReferenceState.java:42) > at > com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(Servle > tInstanceReference.java:40) > at > com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispa > tch(WebAppRequestDispatcher.java:948) > at > com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRe > questDispatcher.java:530) > at > com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppReq > uestDispatcher.java:176) > at > com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:7 > 9) > at > com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInv > oker.java:201) > at > com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocati > on(CachedInvocation.java:71) > at > com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(Servle > tRequestProcessor.java:182) > at > com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSELis > tener.java:334) > at > com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection > .java:56) > at > com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java: > 610) > at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:431) > at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593) > Caused by: org.apache.ojb.broker.OJBRuntimeException: Incorrect or not > found field reference name 'clientRelationshipId' in descriptor > [EMAIL PROTECTED] > rieve=true,cascade_store=object,cascade_delete=object,is_lazy=false,clas > s_of_Items=class model.client.NewClientGroup] for class-descriptor > 'model.client.ClientRelationship' > at > org.apache.ojb.broker.metadata.ObjectReferenceDescriptor.getForeignKeyFi > eldDescriptors(Unknown Source) > at > org.apache.ojb.broker.metadata.ObjectReferenceDescriptor.getForeignKeyVa > lues(Unknown Source) > at > org.apache.ojb.broker.accesslayer.CollectionPrefetcher.associateBatched( > Unknown Source) > at > org.apache.ojb.broker.accesslayer.BasePrefetcher.prefetchRelationship(Un > known Source) > at > org.apache.ojb.broker.core.QueryReferenceBroker.performRetrievalTasks(Un > known Source) > at > org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unk > nown Source) > ... 41 more > > [3/24/05 9:08:48:520 CST] 1985c96 OSEListenerDi E PLGN0021E: Servlet > Request Processor Exception: Virtual Host/WebGroup Not Found : The web > group /favicon.ico has not been defined > > -----Original Message----- > From: Armin Waibel [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 24, 2005 9:46 AM > To: OJB Users List > Subject: Re: Problem retrieving collection. > > > forget my previous post, the error message isn't clear. Why does OJB > lookup 'clientRelationshipId' in class 'ClientRelationship' instead of > 'NewClientGroup'? > > Could you post the whole stack trace? > > Armin > > Armin Waibel wrote: > >>Lemke, Wesley wrote: >> >> >>>I added the (int) clientRelationshipId to NewClientGroup and removed >>>the access="anonymous" from the field-descriptor. I am still getting > > >>>the same error. >>> >> >>Damned! What a nasty problem ;-) >>The error message seems to be clear >> >>Error 500: Server caught unhandled exception from servlet >>[servlets.InheritanceServlet]: >>org.apache.ojb.broker.OJBRuntimeException: Incorrect or not found >>field reference name 'clientRelationshipId' in descriptor >>[EMAIL PROTECTED] >>et >> > > rieve=true,cascade_store=object,cascade_delete=object,is_lazy=false,cl > as > >>s_of_Items=class model.client.NewClientGroup] for class-descriptor >>'model.client.ClientRelationship' >> >>When OJB lookup the field 'clientRelationshipId' it's not found in >>'model.client.ClientRelationship' class-descriptor. >> >>Do your application really use the new mapping files, do you >>manipulate >>OJB metadata at runtime? >> >>regards, >>Armin >> >> >> >>>-----Original Message----- >>>From: Armin Waibel [mailto:[EMAIL PROTECTED] Sent: Thursday, March >>>24, 2005 9:04 AM >>>To: OJB Users List >>>Subject: Re: Problem retrieving collection. >>> >>> >>>Hi Wes, >>> >>>comments see below >>> >>>Lemke, Wesley wrote: >>> >>> >>>>No problem. I think this is everything needed: >>>> >>>>package model; >>>>// All persistent Object extend this class, the unique object ID // >>>>is >>> >>> >>> >>>>from this class along with some other fields public class AdmObject >>>>implements Serializable{ >>>> >>>> private int objectId = -1; >>>> // A few other fields, removed for simplification >>>>} >>>> >>>>package model.client; >>>>// Abstract class that NewClientGroup and Subgroup extend. // Both >>>>NewClientGroup and Subgroup are stored in the // client_group table. >>>>public abstract class GenericGroup extends AdmObject { >>>> >>>> private String name; >>>> // A few other fields, removed for simplification >>>> private String ojbConcreteClass; >>>>} >>>> >>>>package model.client; >>>>// Contains Collection of NewClientGroups. >>>>// Persisted in client. >>>>public class ClientRelationship extends AdmObject { >>>> >>>> private String nameOfApproverOfNoContract; >>>> private List clientGroups = new ArrayList();*** >>>>} >>>> >>>>package model.client; >>>>// One of two classes that extend GenericGroup. >>>>// Contains collection of Subgroups and reference >>>>// to ClientRelationship >>>>// Persisted in client_group. >>>>public class NewClientGroup extends GenericGroup { >>>> >>>> // A few other fields, removed for simplification >>>> private List subgroups = new ArrayList();*** >>>> private ClientRelationship clientRelationship; >>>>} >>>> >>>>***The problem occurs when retrieving the clientGroups collection >>>>from >>> >>> >>> >>>>ClientRelationship. I am having the same problem when retrieving >>>>the >>>>subgroups collection from NewClientGroup, but I'll leave that part > > out > >>> >>> >>>>to simplify the problem. >>>> >>>>Here are the class descriptors: >>>> >>>><class-descriptor >>>> class="model.AdmObject"> >>>> <extent-class class-ref="model.client.ClientRelationship" /> >>>> <extent-class class-ref="model.client.GenericGroup" /> >>>></class-descriptor> >>>> >>>><class-descriptor >>>> class="model.client.GenericGroup"> >>>> <extent-class class-ref="model.client.NewClientGroup" /> >>>></class-descriptor> >>>> >>>><class-descriptor >>>> class="model.client.ClientRelationship" >>>> table="client"> >>>> <field-descriptor >>>> name="objectId" >>>> column="client_id" >>>> jdbc-type="INTEGER" >>>> primarykey="true" >>>> autoincrement="true" >>>> access="readonly" >>>> /> >>>> <field-descriptor >>>> name="nameOfApproverOfNoContract" >>>> column="agr_approver" >>>> jdbc-type="VARCHAR" >>>> /> >>>> <collection-descriptor >>>> name="clientGroups" >>>> element-class-ref="model.client.NewClientGroup" >>>> auto-delete="true" >>>> auto-update="true" >>>> > >>>> <inverse-foreignkey field-ref="clientRelationshipId" /> >>>> </collection-descriptor> </class-descriptor> >>>> >>>><class-descriptor >>>> class="model.client.NewClientGroup" >>>> table="client_group"> >>>> <field-descriptor >>>> name="objectId" >>>> column="group_id" >>>> jdbc-type="INTEGER" >>>> primarykey="true" >>>> autoincrement="true" >>>> access="readonly" >>>> /> >>>> <field-descriptor >>>> name="clientRelationshipId" >>>> column="client_id" >>>> jdbc-type="INTEGER" >>>> access="anonymous" >>>> /> >>> >>> >>> >>>Field "clientRelationshipId" was used by a 1:n relationship, so using > > >>>an >>> >>>anonymous key can be problematic. See >>>http://db.apache.org/ojb/docu/guides/advanced-technique.html#How+do+ >>> >>>Try to make this field a normal field in NewClientGroup. If you using >>>PersistentFieldDirectAccessImplNew as PersistentField implementation >>>in OJB.properties file (default setting), no get/setter needed. >>> >>>The error message is strange I can't find a typo or incorrect >>>mapping. >>> >>>Armin >>> >>> >>> >>> >>>> <field-descriptor >>>> name="name" >>>> column="NAME" >>>> jdbc-type="VARCHAR" >>>> /> >>>> <field-descriptor >>>> name="ojbConcreteClass" >>>> column="CLASS_NAME" >>>> jdbc-type="VARCHAR" >>>> /> >>>> <reference-descriptor name="clientRelationship" >>>>class-ref="model.client.ClientRelationship"> >>>> <foreignkey field-ref="clientRelationshipId"/> >>>> </reference-descriptor> >>>></class-descriptor> >>>> >>>>The objects persist fine. Here is the data in the tables after a >>>>store: >>>> >>>>mysql> select * from client; >>>>+-----------+--------------+--------------------+ >>>>| client_id | agr_approver | last_modified_user | >>>>+-----------+--------------+--------------------+ >>>>| 1 | Zeus | NULL | >>>>+-----------+--------------+--------------------+ >>>>1 row in set (0.00 sec) >>>> >>>>mysql> select group_id, client_id, name, parent_id, class_name from >>>>client_group; >>>>+----------+-----------+---------------------+-----------+---------- >>>>+----------+-----------+---------------------+-----------+-- >>>>+----------+-----------+---------------------+-----------+-- >>>>---------------+ >>>>| group_id | client_id | name | parent_id | > > class_name > >>>>| >>>>+----------+-----------+---------------------+-----------+---------- >>>>+----------+-----------+---------------------+-----------+-- >>>>+----------+-----------+---------------------+-----------+-- >>>>---------------+ >>>>| 1 | 1 | First Client Group | NULL | >>>>model.client.NewClientGroup | >>>>| 2 | 1 | Second Client Group | NULL | >>>>model.client.NewClientGroup | >>>>+----------+-----------+---------------------+-----------+---------- >>>>+----------+-----------+---------------------+-----------+-- >>>>+----------+-----------+---------------------+-----------+-- >>>>---------------+ >>>>2 rows in set (0.00 sec) >>>> >>>>When I try to retrieve an object, this is the error I get: >>>> >>>>Error 500: Server caught unhandled exception from servlet >>>>[servlets.InheritanceServlet]: >>>>org.apache.ojb.broker.OJBRuntimeException: Incorrect or not found >>>>field reference name 'clientRelationshipId' in descriptor >>>> > > [EMAIL PROTECTED] > >>>>et >>>> >>> >>>rieve=true,cascade_store=object,cascade_delete=object,is_lazy=false,c >>>las >>> >>> >>>>s_of_Items=class model.client.NewClientGroup] for class-descriptor >>>>'model.client.ClientRelationship' >>>> >>>>Wallace Joseph Gelhar wrote: >>>> >>>> >>>> >>>> >>>>>OJB currently only joins on the related object primary key (which >>>>>it >>>> >>>> >>>>already knows from the mapping), so what is >needed is the >>>>foreign key field in NewClientGroup that relates to >>>>ClientRelationship. >>>> >>>> >>>> >>>>>Remember that in Reference or Collection Descriptors it is always >>>> >>>> >>>>looking for the foreign key. >>>> >>>> >>>> >>>>>Hope this helps. >>>> >>>> >>>> >>>>If that is the case, then why is OJB looking in >>>>model.client.ClientRelationship for clientRelationshipId? It should > > >>>>be "joining the objects" on ClientRelationship.objectId and >>>>NewClientGroup.clientRelationshipId. >>>> >>>>Thanks for the effort so far, I do appreciate it. >>>> >>>>Here is the entire stack trace if it helps: >>>> >>>>[3/24/05 8:24:49:666 CST] 1048d672 SystemOut O >>>>[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] >>>>DEBUG: >>> >>> >>> >>>>SQL:SELECT A0.agr_approver,A0.client_id FROM client A0 [3/24/05 >>>>8:24:49:696 CST] 1048d672 ConnectionFac I J2CA0122I: Resource >>>>reference jdbc/ao79 could not be located, so default values of the >>>>following are used: [Resource-ref settings] >>>> >>>> res-auth: 1 (APPLICATION) >>>> res-isolation-level: 0 (TRANSACTION_NONE) >>>> res-sharing-scope: true (SHAREABLE) >>>> res-resolution-control: 999 (undefined) >>>>[Other attributes] >>>> >>>>isCMP1_x: false (not CMP1.x) >>>>isJMS: false (not JMS) >>>> >>>>[3/24/05 8:24:49:916 CST] 1048d672 SystemOut O >>>>[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] >>>>DEBUG: >>> >>> >>> >>>>SQL:SELECT A0.CLASS_NAME,A0.group_id,A0.NAME,A0.client_id FROM >>>>client_group A0 WHERE ( A0.client_id = ?) AND (A0.CLASS_NAME = ?) >>>>[3/24/05 8:24:49:966 CST] 1048d672 SystemErr R >>>>org.apache.ojb.broker.OJBRuntimeException: Incorrect or not found >>>>field reference name 'clientRelationshipId' in descriptor >>>> > > [EMAIL PROTECTED] > >>>>et >>>> >>> >>>rieve=true,cascade_store=object,cascade_delete=object,is_lazy=false,c >>>las >>> >>> >>>>s_of_Items=class model.client.NewClientGroup] for class-descriptor >>>>'model.client.ClientRelationship' >>>> at >>>> >>> >>>org.apache.ojb.broker.metadata.ObjectReferenceDescriptor.getForeignKe >>>yFi >>> >>> >>>>eldDescriptors(Unknown Source) >>>> at >>>> >>> >>>org.apache.ojb.broker.metadata.ObjectReferenceDescriptor.getForeignKe >>>yVa >>> >>> >>>>lues(Unknown Source) >>>> at >>>> >>> >>>org.apache.ojb.broker.accesslayer.CollectionPrefetcher.associateBatch >>>ed( >>> >>> >>>>Unknown Source) >>>> at >>>> >>> >>>org.apache.ojb.broker.accesslayer.BasePrefetcher.prefetchRelationship >>>(Un >>> >>> >>>>known Source) >>>> at >>>> >>> >>>org.apache.ojb.broker.core.QueryReferenceBroker.performRetrievalTasks >>>(Un >>> >>> >>>>known Source) >>>> at >>>> >>> >>>org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery( >>>Unk >>> >>> >>>>nown Source) >>>> at >>>> >>> >>>org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery( >>>Unk >>> >>> >>>>nown Source) >>>> at >>>> >>> >>>org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery( >>>Unk >>> >>> >>>>nown Source) >>>> at >>>> >>> >>>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery >>>(Un >>> >>> >>>>known Source) >>>> at >>>> >>> >>>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionB >>>yQu >>> >>> >>>>ery(Unknown Source) >>>> at >>>> >>> >>>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionB >>>yQu >>> >>> >>>>ery(Unknown Source) >>>> at >>>>servlets.InheritanceServlet.printGroups(InheritanceServlet.java:123) >>>> at >>>>servlets.InheritanceServlet.doPost(InheritanceServlet.java:75) >>>> at servlets.InheritanceServlet.doGet(InheritanceServlet.java:44) >>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) >>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(Stric >>>tSe >>> >>> >>>>rvletInstance.java:110) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(Stric >>>tLi >>> >>> >>>>fecycleServlet.java:174) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecy >>>cle >>> >>> >>>>Servlet.java:313) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(Strict >>>Lif >>> >>> >>>>ecycleServlet.java:116) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstan >>>ce. >>> >>> >>>>java:283) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(V >>>ali >>> >>> >>>>dServletReferenceState.java:42) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(Ser >>>vle >>> >>> >>>>tInstanceReference.java:40) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDi >>>spa >>> >>> >>>>tch(WebAppRequestDispatcher.java:948) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAp >>>pRe >>> >>> >>>>questDispatcher.java:530) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebApp >>>Req >>> >>> >>>>uestDispatcher.java:176) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.InvokerServlet.service(InvokerServlet >>>.ja >>> >>> >>>>va:255) >>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(Stric >>>tSe >>> >>> >>>>rvletInstance.java:110) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(Stric >>>tLi >>> >>> >>>>fecycleServlet.java:174) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecy >>>cle >>> >>> >>>>Servlet.java:313) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(Strict >>>Lif >>> >>> >>>>ecycleServlet.java:116) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstan >>>ce. >>> >>> >>>>java:283) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(V >>>ali >>> >>> >>>>dServletReferenceState.java:42) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(Ser >>>vle >>> >>> >>>>tInstanceReference.java:40) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDi >>>spa >>> >>> >>>>tch(WebAppRequestDispatcher.java:948) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAp >>>pRe >>> >>> >>>>questDispatcher.java:530) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebApp >>>Req >>> >>> >>>>uestDispatcher.java:176) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.jav >>>a:7 >>> >>> >>>>9) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebApp >>>Inv >>> >>> >>>>oker.java:201) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvoc >>>ati >>> >>> >>>>on(CachedInvocation.java:71) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(Ser >>>vle >>> >>> >>>>tRequestProcessor.java:182) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSE >>>Lis >>> >>> >>>>tener.java:334) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnect >>>ion >>> >>> >>>>.java:56) >>>> at >>>> >>> >>>com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.ja >>>va: >>> >>> >>>>610) >>>> at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:431) >>>> at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593) >>>>[3/24/05 8:24:53:702 CST] 1048d672 WebGroup E SRVE0026E: > > [Servlet > >>>>Error]-[servlets.InheritanceServlet]: >>>>org.apache.ojb.broker.PersistenceBrokerException: >>>>org.apache.ojb.broker.OJBRuntimeException: Incorrect or not found >>> >>> >>>field >>> >>> >>>>reference name 'clientRelationshipId' in descriptor >>>> >>> >>>[EMAIL PROTECTED] >>>ret >>> >>>rieve=true,cascade_store=object,cascade_delete=object,is_lazy=false,c >>>las >>> >>> >>>>s_of_Items=class model.client.NewClientGroup] for class-descriptor >>>>'model.client.ClientRelationship' >>>> at >>>> >>> >>>org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery( >>>Unk >>> >>> >>>>nown Source) >>>> at >>>> >>> >>>org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery( >>>Unk >>> >>> >>>>nown Source) >>>> at >>>> >>> >>>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery >>>(Un >>> >>> >>>>known Source) >>>> at >>>> >>> >>>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionB >>>yQu >>> >>> >>>>ery(Unknown Source) >>>> at >>>> >>> >>>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionB >>>yQu >>> >>> >>>>ery(Unknown Source) >>>> at >>>>servlets.InheritanceServlet.printGroups(InheritanceServlet.java:123) >>>> at >>>>servlets.InheritanceServlet.doPost(InheritanceServlet.java:75) >>>> at servlets.InheritanceServlet.doGet(InheritanceServlet.java:44) >>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) >>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(Stric >>>tSe >>> >>> >>>>rvletInstance.java:110) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(Stric >>>tLi >>> >>> >>>>fecycleServlet.java:174) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecy >>>cle >>> >>> >>>>Servlet.java:313) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(Strict >>>Lif >>> >>> >>>>ecycleServlet.java:116) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstan >>>ce. >>> >>> >>>>java:283) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(V >>>ali >>> >>> >>>>dServletReferenceState.java:42) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(Ser >>>vle >>> >>> >>>>tInstanceReference.java:40) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDi >>>spa >>> >>> >>>>tch(WebAppRequestDispatcher.java:948) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAp >>>pRe >>> >>> >>>>questDispatcher.java:530) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebApp >>>Req >>> >>> >>>>uestDispatcher.java:176) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.InvokerServlet.service(InvokerServlet >>>.ja >>> >>> >>>>va:255) >>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(Stric >>>tSe >>> >>> >>>>rvletInstance.java:110) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(Stric >>>tLi >>> >>> >>>>fecycleServlet.java:174) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecy >>>cle >>> >>> >>>>Servlet.java:313) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(Strict >>>Lif >>> >>> >>>>ecycleServlet.java:116) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstan >>>ce. >>> >>> >>>>java:283) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(V >>>ali >>> >>> >>>>dServletReferenceState.java:42) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(Ser >>>vle >>> >>> >>>>tInstanceReference.java:40) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDi >>>spa >>> >>> >>>>tch(WebAppRequestDispatcher.java:948) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAp >>>pRe >>> >>> >>>>questDispatcher.java:530) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebApp >>>Req >>> >>> >>>>uestDispatcher.java:176) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.jav >>>a:7 >>> >>> >>>>9) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebApp >>>Inv >>> >>> >>>>oker.java:201) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvoc >>>ati >>> >>> >>>>on(CachedInvocation.java:71) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(Ser >>>vle >>> >>> >>>>tRequestProcessor.java:182) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSE >>>Lis >>> >>> >>>>tener.java:334) >>>> at >>>> >>> >>>com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnect >>>ion >>> >>> >>>>.java:56) >>>> at >>>> >>> >>>com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.ja >>>va: >>> >>> >>>>610) >>>> at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:431) >>>> at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593) >>>>Caused by: org.apache.ojb.broker.OJBRuntimeException: Incorrect or >>>>not found field reference name 'clientRelationshipId' in descriptor >>>> >>> >>>[EMAIL PROTECTED] >>>ret >>> >>>rieve=true,cascade_store=object,cascade_delete=object,is_lazy=false,c >>>las >>> >>> >>>>s_of_Items=class model.client.NewClientGroup] for class-descriptor >>>>'model.client.ClientRelationship' >>>> at >>>> >>> >>>org.apache.ojb.broker.metadata.ObjectReferenceDescriptor.getForeignKe >>>yFi >>> >>> >>>>eldDescriptors(Unknown Source) >>>> at >>>> >>> >>>org.apache.ojb.broker.metadata.ObjectReferenceDescriptor.getForeignKe >>>yVa >>> >>> >>>>lues(Unknown Source) >>>> at >>>> >>> >>>org.apache.ojb.broker.accesslayer.CollectionPrefetcher.associateBatch >>>ed( >>> >>> >>>>Unknown Source) >>>> at >>>> >>> >>>org.apache.ojb.broker.accesslayer.BasePrefetcher.prefetchRelationship >>>(Un >>> >>> >>>>known Source) >>>> at >>>> >>> >>>org.apache.ojb.broker.core.QueryReferenceBroker.performRetrievalTasks >>>(Un >>> >>> >>>>known Source) >>>> at >>>> >>> >>>org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery( >>>Unk >>> >>> >>>>nown Source) >>>> ... 41 more >>>> >>>>[3/24/05 8:24:54:313 CST] 1048d672 OSEListenerDi E PLGN0021E: >>>>Servlet >>>>Request Processor Exception: Virtual Host/WebGroup Not Found : The > > web > >>> >>> >>>>group /favicon.ico has not been defined >>>> >>>>-----Original Message----- >>>>From: Armin Waibel [mailto:[EMAIL PROTECTED] >>>>Sent: Thursday, March 24, 2005 8:12 AM >>>>To: OJB Users List >>>>Subject: Re: Problem retrieving collection. >>>> >>>> >>>>Hi Wes, >>>> >>>> >>>>>Is my assumption wrong? In this case: >>>>> >>>>><reference-descriptor name="clientRelationship" >>>>>class-ref="model.client.ClientRelationship"> >>>>> <foreignkey field-ref="objectId"/> </reference-descriptor> >>>>> >>>>>Isn't objectId supposed to be the primary key field of >>>>>model.client.ClientRelationship? >>>> >>>>sorry I'm a little confused after all the posts to this thread. >>>>Could you please post the class hierarchy (with all (important) >>>>fields of >>> >>> >>>the >>> >>> >>>>classes, no get/setter) and the actual mapping of the classes again. >>>> >>>>regards, >>>>Armin >>>> >>>>-------------------------------------------------------------------- >>>>- >>>>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] >>> >>> >>> >> >>--------------------------------------------------------------------- >>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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
