Hi,

I am afraid this won't work with Castor, as identity columns have to carry a 
meaningful value.

Regards
Werner

wg> -----Original Message-----
wg> From: Vijayanand Sukumar [mailto:[EMAIL PROTECTED]
wg> Sent: Thursday, August 04, 2005 4:42 AM
wg> To: [email protected]
wg> Subject: [castor-user] Problem in using db.load when 
wg> mutilple Columns
wg> are used as Primary Key
wg> 
wg> 
wg> All,
wg> 
wg> I have a oracle view that I mapped to a Jdo. The view has 
wg> two columns that
wg> combine to form the identity for the JDO. 
wg> 
wg> <class name="com.foo.Object" identity="id1 id2" >
wg> ...
wg>             <field name="id1" type="long">
wg>                     <sql name="ID1" type="bigint"/>
wg>             </field>
wg>             <field name="id2" type="string">
wg>                     <sql name="ID2" type="bigint"/>
wg>             </field>
wg> </class>
wg> 
wg> Where id2 may or may not be null in the view.
wg> 
wg> This object is queried by using 
wg> 
wg> db.load(com.foo.Object.class,new Complex(new Long(1),new
wg> String("2"),Database.ReadOnly);
wg> 
wg> This works fine. The problem arises when there is no id2.
wg> 
wg> I tried using 
wg> 
wg> db.load(com.foo.Object.class,new Complex(new Long(1),new
wg> String(""),Database.ReadOnly);
wg> 
wg> Which did not work and tried using 
wg> 
wg> db.load(com.foo.Object.class,new Complex(new
wg> Long(1),null,Database.ReadOnly);
wg> 
wg> Which also did not work. 
wg> 
wg> Can someone please help me on how to specify the nullable 
wg> field in db.load ?
wg> 
wg> 
wg> Thanks
wg> 
wg> Vijay
wg> 
wg> 
wg> 
wg> 
wg> -------------------------------------------------
wg> If you wish to unsubscribe from this list, please 
wg> send an empty message to the following address:
wg> 
wg> [EMAIL PROTECTED]
wg> -------------------------------------------------
wg> 
wg> 

-------------------------------------------------
If you wish to unsubscribe from this list, please
send an empty message to the following address:

[EMAIL PROTECTED]
-------------------------------------------------

Reply via email to