David Sean Taylor a �crit : > With 1.4b2, Oracle uses sequences. I looked at the 1.4b1 release, and > it appears to me that it was using sequences too, so I don't know why > you have it configured for the ID_TABLE with Oracle.
In 1.4b1, the default turbine-oracle.sql (in src/sql/external) is using ID_TABLE (at the end of the file), and I used this one :(((( My fault, I didn't look enough in what I generated and used what was in external... > If you are using the ID_TABLE, I suggest switching to sequences since > obviously this is much more robust. > To convert your system, its simple, just reseed the Oracle sequence: > > CREATE SEQUENCE TURBINE_USER_SEQ INCREMENT BY 1 START WITH 1000 > NOMAXVALUE NOCYCLE NOCACHE ORDER; > ............................................................^ set > higher than your highest id, which you can find by SELECT > MAX(USER_ID) FORM TURBINE_USER; > > You will then need to alter the table to use the sequence and the new > column added in 1.4b2 Ok I'll have a look at this, thanx ! Aur�lien. -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
