Re: [ojb-users] references

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

hi steven,

i'm pleased to hear that your problems are all gone...
you know, it was me who removed the call to nativeSql, because MS-Access
didn't like it :-(

jakob

----- Original Message -----
From: "Ebersole, Steven" <ste...@vi...>
To: "'Jakob Braeuchi'" <jbr...@ho...>;
<obj...@li...>
Sent: Tuesday, May 28, 2002 9:45 PM
Subject: RE: [ojb-users] references

> Solved, was a previously known OJB "feature"
> (http://sourceforge.net/forum/message.php?msg_id=1540574).  Patched the
OJB
> source and re-built and all is fine.
>
>
>
> ********************************************
> Steve Ebersole
> IT Integration Engineer
> Vignette Corporation
> 512.741.4195
>
> Visit http://www.vignette.com
>
> ********************************************
>
>
> -----Original Message-----
> From: Ebersole, Steven [mailto:ste...@vi...]
> Sent: Tuesday, May 28, 2002 12:24 PM
> To: 'Jakob Braeuchi'; 'obj...@li...'
> Subject: RE: [ojb-users] references
>
>
> Sorry, grabbed the .class files by accident
>
> Here is everything with .java instead of .class
>
>
>
> ********************************************
> Steve Ebersole
> IT Integration Engineer
> Vignette Corporation
> 512.741.4195
>
> Visit http://www.vignette.com
>
> ********************************************
>
>
> -----Original Message-----
> From: Jakob Braeuchi [mailto:jbr...@ho...]
> Sent: Tuesday, May 28, 2002 12:13 PM
> To: Ebersole, Steven
> Subject: Re: [ojb-users] references
>
>
> hi steven,
>
> would you mind sending me the source-code of your classes ?
>
> jakob
>
> ----- Original Message -----
> From: "Ebersole, Steven" <ste...@vi...>
> To: "'Jakob Braeuchi'" <jbr...@ho...>
> Sent: Tuesday, May 28, 2002 6:12 PM
> Subject: RE: [ojb-users] references
>
>
> > Thanks for the reply...
> >
> > I use 0.8.375.
> >
> >
> > As far as I can tell, there is really no difference between my mappings
> and
> > those of the tests aside from the fact that mine are simplier because I
> have
> > very few references mapped (this was only intended to be a quick product
> > evaluation).
> >
> > I have included everything you have asked for, and in addition have
added
> > the four class files which are part of the drivers package which make up
> the
> > test cases.  The class TestDataPersistorMapping succeeds (for me) while
> the
> > other two tests fail.  TestDataPersistorMapping is the only one of the
> three
> > test-cases which does not include mapped references which is why the
> others
> > seem to fail.
> >
> > Thanks again...
> >
> >
> > ********************************************
> > Steve Ebersole
> > IT Integration Engineer
> > Vignette Corporation
> > 512.741.4195
> >
> > Visit http://www.vignette.com
> >
> > ********************************************
> >
> >
> > -----Original Message-----
> > From: Jakob Braeuchi [mailto:jbr...@ho...]
> > Sent: Tuesday, May 28, 2002 10:35 AM
> > To: Ebersole, Steven; 'Thomas Mahler';
> > obj...@li...
> > Subject: Re: [ojb-users] references
> >
> >
> > hi steven,
> >
> > what version of ojb do you use ?
> > how does your test differ from the the testcase included in ojb ?
> >
> > please send me a complete test case including repository, java classes
and
> > the sql-scripts to setup the tables so i can have a look at it.
> >
> > jakob
> >
> > ----- Original Message -----
> > From: "Ebersole, Steven" <ste...@vi...>
> > To: "'Thomas Mahler'" <tho...@ho...>;
> > <obj...@li...>
> > Sent: Tuesday, May 28, 2002 3:13 PM
> > Subject: RE: [ojb-users] references
> >
> >
> > > Trying not to sound pushy here, but as I mentioned in my first post I
am
> > > considering moving from Castor over to OJB for the project on which I
am
> > > currently working.  However, I am unable to get even simple reference
> > > relationships working.  Obviously I can't move the project over to
this
> > > library if this is going to be the case.  But it seems others are
> getting
> > > this to work.
> > >
> > > So I guess my question is now, should I even continue evaluating OJB?
I
> > > mean it has been almost a month since my original post, and I am still
> no
> > > closer to solving the issue and not a single person has been willing
(or
> > > knowledgeable enough) to help.  I know this is open source and as
such:
> 1)
> > I
> > > could simply debug the library myself; 2) people contribute and help
> > others
> > > as their time allows.  As for one, I am in the middle of a project
> myself
> > > and unfortunately cannot validate the time to spend troubleshooting a
> > > proposed library which may not even be used.  As for two, I understand
> the
> > > time constraints of others, but to wait one month for for a response
on
> > such
> > > a basic O/R-mapping requirement as relationships?
> > >
> > > Also, as I have previously mentioned, the set-up and the
implementation
> of
> > > this library are extremely promising (especially in the environment in
> > which
> > > I was hoping to use it).  In short I want to use this product.
However,
> I
> > > cannot swap out Castor to OJB at this time because I do not feel
> confident
> > > enough in OJB's capibilities mainly because every test I have tried to
> run
> > > (above and beyond strict table-to-object) fails.
> > >
> > > Please, please can anyone help with the below problem?  Anyone
> encountered
> > > it before?
> > >
> > > Thanks in advance
> > >
> > >
> > >
> > > ********************************************
> > > Steve Ebersole
> > > IT Integration Engineer
> > > Vignette Corporation
> > > 512.741.4195
> > >
> > > Visit http://www.vignette.com
> > >
> > > ********************************************
> > >
> > >
> > > -----Original Message-----
> > > From: Ebersole, Steven [mailto:ste...@vi...]
> > > Sent: Monday, May 20, 2002 7:47 AM
> > > To: 'Thomas Mahler'; obj...@li...
> > > Subject: RE: [ojb-users] references
> > >
> > >
> > > Any ideas?
> > >
> > >
> > > ********************************************
> > > Steve Ebersole
> > > IT Integration Engineer
> > > Vignette Corporation
> > > 512.741.4195
> > >
> > > Visit http://www.vignette.com
> > >
> > > ********************************************
> > >
> > >
> > > -----Original Message-----
> > > From: Ebersole, Steven [mailto:ste...@vi...]
> > > Sent: Wednesday, May 08, 2002 7:09 AM
> > > To: 'Thomas Mahler'; obj...@li...
> > > Subject: RE: [ojb-users] references
> > >
> > >
> > > Below is the exception I get.  I appears that the exception occurs
when
> > > trying to resolve the reference to parent company when that fk column
is
> > > null.  If I remove that reference descriptor, everything works.
> > >
> > > Query from class com.vignette.it.apps.dbapi.domain.CompanyDO where
> > comp_id=
> > > ?
> > > [DEFAULT] WARN: Please define a public constructor for class
> > > com.vignette.it.apps.dbapi.domain.CompanyDO
> > > with the following signature: (java.lang.Integer, java.lang.String,
> > > java.lang.Integer).
> > > It must initialize the classes persistent attributes. This is
> recommended
> > to
> > > increase performance but it's not mandatory!
> > > [ojb.broker.singlevm.PersistenceBrokerImpl] ERROR: expected type:
class
> > > com.vignette.it.apps.dbapi.domain.CompanyDO
> > > [ojb.broker.accesslayer.RsIterator] ERROR: null
> > > java.lang.ArrayIndexOutOfBoundsException
> > >         at
> > >
> >
>
ojb.broker.metadata.ClassDescriptor.getFieldDescriptorByIndex(ClassDescripto
> > > r.java:263)
> > >         at
> > >
> >
>
ojb.broker.metadata.ObjectReferenceDescriptor.getForeignKeyFieldDescriptors(
> > > ObjectReferenceDescriptor.java:242)
> > >         at
> > >
> >
>
ojb.broker.metadata.ObjectReferenceDescriptor.getForeignKeyValues(ObjectRefe
> > > renceDescriptor.java:264)
> > >         at
> > >
> >
>
ojb.broker.singlevm.PersistenceBrokerImpl.getReferencedObject(PersistenceBro
> > > kerImpl.java:700)
> > >         at
> > >
> >
>
ojb.broker.singlevm.PersistenceBrokerImpl.retrieveReferences(PersistenceBrok
> > > erImpl.java:517)
> > >         at
> > >
> >
>
ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIterator.java:263
> > > )
> > >         at ojb.broker.accesslayer.RsIterator.next(RsIterator.java:145)
> > >         at
> > >
> >
>
ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBr
> > > okerImpl.java:900)
> > >         at
> > >
> >
>
ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBr
> > > okerImpl.java:966)
> > >         at
> > >
> >
>
ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBr
> > > okerImpl.java:1054)
> > >         at
> > >
> >
>
ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBr
> > > okerImpl.java:1041)
> > >         at TestOJBInstall.execute(TestOJBInstall.java:66)
> > >         at TestOJBInstall.main(TestOJBInstall.java:53)
> > > java.util.NoSuchElementException
> > >         at ojb.broker.accesslayer.RsIterator.next(RsIterator.java:154)
> > >         at
> > >
> >
>
ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBr
> > > okerImpl.java:900)
> > >         at
> > >
> >
>
ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBr
> > > okerImpl.java:966)
> > >         at
> > >
> >
>
ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBr
> > > okerImpl.java:1054)
> > >         at
> > >
> >
>
ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBr
> > > okerImpl.java:1041)
> > >         at TestOJBInstall.execute(TestOJBInstall.java:66)
> > >         at TestOJBInstall.main(TestOJBIError occurred :
> > > java.util.NoSuchElementException
> > > nstall.java:53)
> > >
> > >
> > >
> > >
> > >
> > > ********************************************
> > > Steve Ebersole
> > > IT Integration Engineer
> > > Vignette Corporation
> > > 512.741.4195
> > >
> > > Visit http://www.vignette.com
> > >
> > > ********************************************
> > >
> > >
> > > -----Original Message-----
> > > From: Thomas Mahler [mailto:tho...@ho...]
> > > Sent: Friday, May 03, 2002 12:11 AM
> > > To: Ebersole, Steven
> > > Subject: Re: [ojb-users] references
> > >
> > >
> > > Hi Steven,
> > >
> > > Ebersole, Steven wrote:
> > >
> > > > I am looking at switching from Castor over to OJB as it looks really
> > > > promising in terms of its functionality (I especially love the use
of
> > > > virtual proxies here).  I did have two questions come up from my
> initial
> > > > trials of OJB.
> > > >
> > > > 1) Is it necessary to have both the foreign key and the foreign
> > reference
> > > > mapped and present on the object?
> > >
> > >
> > > depends on the navigibility between your persistent classes.
> > > If you want to navigate from the 1-side to the n-side only, you just
> > > need a foreign key (and a ForeignKeyDescriptor).
> > >
> > > If you want navigation from the n-side to the 1-side too, you'll also
> > > need a reference attribute (and a ReferenceDecsriptor too).
> > >
> > > In the examples, the relation between
> > > > Article and ProductGroup is the example From which I was working.
> > There,
> > > > Article has two attributes dealing with its relation to a
> ProductGroup,
> > >
> > >
> > > Yes, because we have navigation from ProductGroup to all its Articles
> > > and from an Article to its associated ProductGroup.
> > >
> > >
> > > > productGroupId (which is the DB fk field) and productGroup (which is
> an
> > > > instance of the ProductGroup object to which productGroupId
referes).
> > Is
> > > it
> > > > necessary to do this, or is there a way to have the Product object
> only
> > > know
> > > > about its related ProductGroup?
> > >
> > >
> > > No, because ProductGroup and Article have a 1:n relation the table
> > > representaing Article entities *must* have a foreign key to identify
the
> > > associated ProductGroup.
> > >
> > >
> > > >
> > > > 2) I mapped a relationship, uing my classes, similiar to the above
> > > > relationship (it is a company -> parent company relationship).
> However,
> > I
> > > > get exceptions if a particular company did not have a parent company
> > (its
> > > > PRTN_COMP_ID column on the DB is NULL).  Is there something
additional
> I
> > > > have to set up in the mapping to define that side of the
relationship
> as
> > > > optional?  Below is the mapping I have for this:
> > > >
> > > >
> > > >     <ClassDescriptor id="2">
> > > >
> > > <class.name>com.vignette.it.apps.dbapi.domain.CompanyDO</class.name>
> > > >         <table.name>COMPANY</table.name>
> > > >         <FieldDescriptor id="1">
> > > >             <field.name>id</field.name>
> > > >             <column.name>COMP_ID</column.name>
> > > >             <jdbc_type>INTEGER</jdbc_type>
> > > >             <PrimaryKey>true</PrimaryKey>
> > > >         </FieldDescriptor>
> > > >          ...
> > > >         <FieldDescriptor id="5">
> > > >             <field.name>parentCompanyId</field.name>
> > > >             <column.name>PRNT_COMP_ID</column.name>
> > > >             <jdbc_type>INTEGER</jdbc_type>
> > > >         </FieldDescriptor>
> > > >         <ReferenceDescriptor id="1">
> > > >             <rdfield.name>parentCompany</rdfield.name>
> > > >
> > > >
> > >
> >
>
<referenced.class>com.vignette.it.apps.dbapi.domain.CompanyDO</referenced.cl
> > > > ass>
> > > >             <fk_descriptor_ids>5</fk_descriptor_ids>
> > > >         </ReferenceDescriptor>
> > > >    </ClassDescriptor>
> > > >
> > >
> > >
> > > Your mapping seems OK. This must be an OJB bug! Can you provide me
with
> > > a full stacktrace ?
> > >
> > > thanks,
> > >
> > > Thomas
> > >
> > >
> > > >
> > > > Thanks
> > > >
> > > >
> > > >
> > > >
> > > > ********************************************
> > > > Steve Ebersole
> > > > IT Integration Engineer
> > > > Vignette Corporation
> > > > 512.741.4195
> > > >
> > > > Visit http://www.vignette.com
> > > >
> > > > ********************************************
> > > >
> > > > _______________________________________________________________
> > > >
> > > > Have big pipes? SourceForge.net is looking for download mirrors. We
> > supply
> > > > the hardware. You get the recognition. Email Us:
> > ban...@so...
> > > > _______________________________________________
> > > > Objectbridge-users mailing list
> > > > Obj...@li...
> > > > https://lists.sourceforge.net/lists/listinfo/objectbridge-users
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > _______________________________________________________________
> > >
> > > Have big pipes? SourceForge.net is looking for download mirrors. We
> supply
> > > the hardware. You get the recognition. Email Us:
> ban...@so...
> > > _______________________________________________
> > > Objectbridge-users mailing list
> > > Obj...@li...
> > > https://lists.sourceforge.net/lists/listinfo/objectbridge-users
> > >
> > > _______________________________________________________________
> > > Hundreds of nodes, one monster rendering program.
> > > Now that's a super model! Visit http://clustering.foundries.sf.net/
> > >
> > > _______________________________________________
> > > Objectbridge-users mailing list
> > > Obj...@li...
> > > https://lists.sourceforge.net/lists/listinfo/objectbridge-users
> > >
> > > _______________________________________________________________
> > >
> > > Don't miss the 2002 Sprint PCS Application Developer's Conference
> > > August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm
> > >
> > > _______________________________________________
> > > Objectbridge-users mailing list
> > > Obj...@li...
> > > https://lists.sourceforge.net/lists/listinfo/objectbridge-users
> > >
> >
> >
>
>