RE: [OJB-developers] OJB_SEQ with Oracle

[David F. <dw...@la...>]

Any clue as to the appropriate modifications?   I'm using the broker interface
and am using the standard sql for OJB_SEQ as defined by OJB-0.8.400

I'm not sure what to change.

thanks,

Dave
At 09:59 AM 6/6/2002 -0400, Carlos Perez wrote:
>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
>
>_______________________________________________________________
>
>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