Thanks Peter! It helped me. Take care,
-----Original Message----- From: Peter Kasson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 11:51 AM To: [EMAIL PROTECTED] Subject: Re: [castor-dev] Castor Key generator Kumar, Check for Exolab site for "keygen" ... there is one for Oracle, I believe it is called "SEQUENCE". They have them for major db's with auto-increment columns. This will solve your problem ! Peter >From: "Kumar Dharm" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: [EMAIL PROTECTED] >Subject: [castor-dev] Castor Key generator >Date: Tue, 3 Dec 2002 21:15:17 -0800 > >Hi All, > > Following is my mapping.xml file. I would like to use Oracle sequence for >inserting value into En_ID field. > ><key-generator name="SEQUENCE" alias="seqgen"> > <param name="sequence" value="{0}_SEQ"/> ></key-generator> > <class name="com.PCPgo.prm.web.encounter.EncounterJdo" identity="id"> > <description>Encounter</description> > <map-to table="ENCOUNTER" xml="group" /> > <field name="id" type="long" key-generator="seqgen"> > <sql name="EN_ID" type="integer" /> > <xml node="element" /> > </field> > <field name="name" type="string" > > <sql name="EN_NAME" type="varchar" dirty="ignore"/> > <xml node="element"/> > </field> > </class> > >Now, While creating EncounterJdo object, I am setting value as follows. > > EncounterJdo encounterJdo= new EncounterJdo(); > encounterJdo.setName("Allan"); > if (db == null) > throw new InternalException("DB is null"); > db.begin(); > db.create(encounterJdo); > db.commit(); > db.close(); > > but it inserts EN_ID =0 and NAME = "Allan" and now if I run again it >throws >following error. It means it doesn't generate sequence > > org.exolab.castor.jdo.DuplicateIdentityException: Duplicate identity >found >for > object of type com.PCPgo.prm.web.encounter.EncounterJdo with identity 0: > an objec t with the same identity already exists in persistent storage > > Hope for solution. > > Best regards, > Kumar > >----------------------------------------------------------- >If you wish to unsubscribe from this mailing, send mail to >[EMAIL PROTECTED] with a subject of: > unsubscribe castor-dev _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
