RE: [OJB-developers] OJB_SEQ with Oracle

[Carlos P. <Ca...@ad...>]

I had the same problem with Oracle when using the ODMG API.  I removed my
usage of the API and it works with the Broker.  My suspicion is that you
have to modify the db-setup.sql to create the right OJB tables.

Carlos

-----Original Message-----
From: David Forslund [mailto:dw...@la...]
Sent: Wednesday, June 05, 2002 4:27 PM
To: obj...@li...
Subject: [OJB-developers] OJB_SEQ with Oracle


Are people using the OJB_SEQ table with sequences in Oracle?

When I try to create a sequence in Oracle, I get a failure:

It is calling getNextId in SequenceManagerDefaultImpl and fails with a
  SQLexception: ORA-00001: unique contraint (COAS_SERER.SYS_C005581)
violated.
The table is created using the standard sql for SequenceEntry and the 
default xml repository mapping
to OJB_SEQ.

It is doing an insert of all the variables into the table but must be 
rejecting them
because the key has already been filled and it things I'm trying to create 
another key
with the same value.

I think this was working with an earlier version of OJB.  This problem is 
with OJB-0.8.400

Thanks,

Dave


_______________________________________________________________

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-developers mailing list
Obj...@li...
https://lists.sourceforge.net/lists/listinfo/objectbridge-developers