Re: Oracle9i and sequences

2005-08-10 Thread Guillaume Laforge
Hi Armin, Sorry for the slow answer! On 05/08/05, Armin Waibel <[EMAIL PROTECTED]> wrote: > I think this will be possible, but this requires changes in method > Platform#createSequenceQuery(String sequenceName), please make a feature > request in jira > http://issues.apache.org/jira/secure/Browse

Re: Oracle9i and sequences

2005-08-05 Thread Armin Waibel
Hi, > Now that I've found what the problem was, I'd like to make a little > suggestion improvement on the PlatformOracleImpl class: Could it be > possible that the method: > > public String createSequenceQuery(String sequenceName) > > takes into account the index start sequence hints we pass in

Re: Oracle9i and sequences

2005-08-03 Thread Guillaume Laforge
First of all, thanks to both Thomas :-) On 03/08/05, Thomas Franke <[EMAIL PROTECTED]> wrote: > Thomas Dudziak wrote: > > > * Leave the pk generation to the database. In that case, use the > > native sequence manager. > With Oracle it would be a problem I think. If I right the native sequence > m

Re: Oracle9i and sequences

2005-08-03 Thread Thomas Franke
Thomas Dudziak wrote: > * Leave the pk generation to the database. In that case, use the > native sequence manager. With Oracle it would be a problem I think. If I right the native sequence manager don't work with Oracle. Therefore we use SequenceManagerNextValImpl and leave the pk generation to O

Re: Oracle9i and sequences

2005-08-03 Thread Thomas Franke
Guillaume Laforge wrote: We use Oracle with Oracle sequences and it works out fine. We use OJB 1.0.1 and Oracle9i. Have a look at our set-up: > className="org.apache.ojb.broker.util.sequence.SequenceManagerNextValImpl"> > attribute-name="globalSequenceStart" attribute-value="1000"/>

Re: Oracle9i and sequences

2005-08-03 Thread Thomas Dudziak
> I'd like to know what's the best way (and how) to use sequences for > the primary keys of my persistent classes. > > I'm facing some problems I can't seem to solve: I can't manage to > store my objects, and I get an exception like: > > KeyConstraintViolatedException: SQL failure while insert ob

Oracle9i and sequences

2005-08-03 Thread Guillaume Laforge
Hi, I'd like to know what's the best way (and how) to use sequences for the primary keys of my persistent classes. I'm facing some problems I can't seem to solve: I can't manage to store my objects, and I get an exception like: KeyConstraintViolatedException: SQL failure while insert object data