objectbridge-developers

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

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