forwarded this to daren the fellow that wrote it. Could someone sum up exactly what we
need (this issue and others) he's willing to do the work, but needs a spec ;)
-----Original Message-----
From: Thomas Mahler [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 03, 2003 9:27 AM
To: OJB Users List
Subject: Re: Collection help, please...
We could improve the existing "repository verifier" to check such things
too!
just my 2c
Thomas
Matthew Baird wrote:
> the question then is can we improve the error reporting and give the user enough
>info to have the problem become evident?
>
> -----Original Message-----
> From: Brian McCallister [mailto:[EMAIL PROTECTED]]
> Sent: Mon 2/3/2003 4:57 AM
> To: OJB Users List
> Cc:
> Subject: Re: Collection help, please...
>
>
>
> Thank you!
>
> I figured it was something silly like that which I wasn't seeing because
> I had looked at it for too long. (C&P "reuse" strikes again ;-)
>
> -Brian
>
> On Sun, 2003-02-02 at 23:22, Ron Gallagher wrote:
> > Brian --
> >
> > Your class descriptor for org.skife.registry.domain.User includes two fields
>that are marked as primary keys, userId and handle. In that situation, you need to
>specify two inverse-foreignkey entries for the giftsRequested collection descriptor,
>one for each field in the primary key.
> >
> > I'm guessing that marking the field "handle" as a primary key is a mistake
>since there's no "handle" field on the gifts table.
> >
> > HTH
> >
> > Ron Gallagher
> > Atlanta, GA
> > [EMAIL PROTECTED]
> >
> > >
> > > From: Brian McCallister <[EMAIL PROTECTED]>
> > > Date: 2003/02/02 Sun PM 07:56:22 EST
> > > To: OJB Users List <[EMAIL PROTECTED]>
> > > Subject: Collection help, please...
> > >
> > > I feel silly for not being able to figure this out, but I have not been
> > > able to. I am sure it is some small configuration problem I have missed,
> > > but looking over the docs, and my code, I cannot find it. Of note - OJB
> > > .9.8, PostgreSQL 7.3, the standard pgsql jdbc3.0 driver.
> > >
> > > When I attempt to instantiate a class (source follows) which has a
> > > collection of other persistent objects in it, I get a nasty series of
> > > JDBC exceptions.
> > >
> > > I only have two classes for this setup, a User class and a Gift class -
> > > the User contains a Vector of Gifts.
> > >
> > > If there is a User in the database:
> > >
> > > registry=> select * from users ;
> > > userid | handle | password | firstname | lastname
> > > --------+--------+----------+-----------+-------------
> > > 1 | wheee | tester | Brian | McCallister
> > > (1 row)
> > >
> > > and a gift for that user:
> > >
> > > registry=> select * from gifts ;
> > > giftid | name | foruserid
> > > --------+--------------+-----------
> > > 1 | Wireless Hub | 1
> > > (1 row)
> > >
> > > before the tests run and I attempt to load said user I get the
> > > exception. If i delete the gift frm the database I have no problem, if I
> > > add a gift in the test and then load the user again, no problem, but if
> > > the gift exists before I start running the test, boom it dies.
> > >
> > > The test is simply loading the user via a query for the handle via the
> > > PB API.
> > >
> > > Any help would be much appreciated
> > >
> > > <class-descriptor
> > > class="org.skife.registry.domain.User"
> > > table="USERS"
> > > >
> > > <field-descriptor id="1"
> > > name="userId"
> > > column="userid"
> > > jdbc-type="INTEGER"
> > > primarykey="true"
> > > autoincrement="true"
> > > indexed="true"
> > > />
> > > <field-descriptor id="2"
> > > name="firstName"
> > > column="firstname"
> > > jdbc-type="VARCHAR"
> > > nullable="true"
> > > />
> > > <field-descriptor
> > > id="3"
> > > name="lastName"
> > > column="lastname"
> > > jdbc-type="VARCHAR"
> > > nullable="true"
> > > />
> > > <field-descriptor id="4"
> > > name="password"
> > > column="PASSWORD"
> > > jdbc-type="VARCHAR"
> > > />
> > > <field-descriptor id="5"
> > > name="handle"
> > > column="HANDLE"
> > > jdbc-type="VARCHAR"
> > > primarykey="true"
> > > indexed="true"
> > > />
> > > <collection-descriptor
> > > name="giftsRequested"
> > > element-class-ref="org.skife.registry.domain.Gift"
> > > auto-update="true"
> > > auto-delete="true"
> > > >
> > > <inverse-foreignkey field-id-ref="3"/>
> > > </collection-descriptor>
> > > </class-descriptor>
> > >
> > > <class-descriptor
> > > class="org.skife.registry.domain.Gift"
> > > table="GIFTS">
> > > <field-descriptor id="1"
> > > name="id"
> > > column="giftid"
> > > jdbc-type="INTEGER"
> > > primarykey="true"
> > > autoincrement="true"
> > > indexed="true"
> > > />
> > > <field-descriptor
> > > id="2"
> > > name="name"
> > > column="name"
> > > jdbc-type="VARCHAR"
> > > nullable="true"
> > > />
> > > <field-descriptor
> > > id="3"
> > > name="userId"
> > > column="foruserid"
> > > jdbc-type="INTEGER"
> > > />
> > > <reference-descriptor
> > > name="user"
> > > class-ref="org.skife.registry.domain.User"
> > > auto-update="false"
> > > auto-delete="false"
> > > >
> > > <foreignkey field-id-ref="3"/>
> > > </reference-descriptor>
> > >
> > > </class-descriptor>
> > >
> > <snip>
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> --
> Brian McCallister < [EMAIL PROTECTED] >
> Systems Administrator and Software Engineer
> Fort Hill Company -- www.forthillcompany.com
>
>
> ---------------------------------------------------------------------
> 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]