Re: Sequence managers and insert triggers

2005-04-18 Thread Martin Kalén
Mike Jackson wrote: I'm running on an Oracle database (8i) with insert triggers to create artifical keys for my table records. The howtos seemed to indicate that SequenceManagerNativeImpl might be the proper sequence manager to use but the keys are coming out goofy, so clearly I'm not understandin

RE: Sequence managers and insert triggers

2005-04-16 Thread Ron Gallagher
eturns it to the caller. I believe you could do the same sort of thing with a value that's assigned via the insert trigger. Ron Gallagher Atlanta, GA -Original Message- From: Mike Jackson [mailto:[EMAIL PROTECTED] Sent: Friday, April 15, 2005 7:10 PM To: 'OJB Users List'

Re: Sequence managers and insert triggers

2005-04-15 Thread Armin Waibel
ke jackson [EMAIL PROTECTED] -Original Message- From: Armin Waibel [mailto:[EMAIL PROTECTED] Sent: Friday, April 15, 2005 3:42 PM To: OJB Users List Subject: Re: Sequence managers and insert triggers Hi Mike, think I don't understand your problem (never used insert trigger), so be patien

RE: Sequence managers and insert triggers

2005-04-15 Thread Mike Jackson
jackson [EMAIL PROTECTED] > -Original Message- > From: Armin Waibel [mailto:[EMAIL PROTECTED] > Sent: Friday, April 15, 2005 3:42 PM > To: OJB Users List > Subject: Re: Sequence managers and insert triggers > > > Hi Mike, > > think I don't understand y

Re: Sequence managers and insert triggers

2005-04-15 Thread Armin Waibel
Hi Mike, think I don't understand your problem (never used insert trigger), so be patience. If you are using a insert trigger I assume the trigger set the PK value on insert of new objects? Or do you using a stored procedure to get the key or to insert the whole object? OJB supports database ge

RE: Sequence managers and insert triggers

2005-04-15 Thread Mike Jackson
Actually I take it back, I was getting a -2, but when I got the attributes on the identity column set properly I'm getting a "java.lang.UnsupportedOperationException: This feature is not supported by this implementation". Perhaps this is the wrong sequence manager to use on oracle? --mikej -=