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/BrowseProject.jspa?id=10700 If not a change, perhaps a new method could be handy? I've created a new issue for that: http://issues.apache.org/jira/browse/OJB-66 > > drop/recreate them, that was just fine. So I used some sequence > > creation like so: > > > > CREATE SEQUENCE FOOBAR_SEQ START WITH 41 MAXVALUE > > 999999999999999999999999999 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; > > Is it possible in Oracle only to specify the start index without the > other settings? E.g. > CREATE SEQUENCE FOOBAR_SEQ START WITH 41 > > If yes, please add this example in feature request too. Yes, Oracle9i also supports that and I've added that to the request as well: http://issues.apache.org/jira/browse/OJB-66 That'd be great if we could specify a more complex sequence manager parametrisation: <sequence-manager className="org.apache.ojb.broker.util.sequence.SequenceManagerNextValImpl"> <attribute attribute-name="autoNaming" attribute-value="true"/> <attribute attribute-name="globalSequenceStart" attribute-value="1000"/> <attribute attribute-name="minValue" attribute-value="1000"/> <attribute attribute-name="maxValue" attribute-value="9999999999999999"/> <attribute attribute-name="noCycle"/> <attribute attribute-name="cache" attribute-value="20"/> <attribute attribute-name="noOrder"/> </sequence-manager> CACHE 20 is interesting if we want to lower the hits to the database since Oracle can compute 20 values in advance and puts them in its cache. Cheers, -- Guillaume Laforge http://glaforge.free.fr/blog/groovy --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]