Thank you, I'll give this a try, because we used the script. > -----Urspr�ngliche Nachricht----- > Von: Aurelien Pernoud [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 5. M�rz 2003 15:43 > An: 'Jetspeed Users List' > Betreff: RE: Oracle DB + Jetspeed 1.4 b3 > > > I think I had this one too. > > When using 1.4b1, did you use the following script instead of > using the one > generated by ANT : > jetspeed-1.4b1-release-src\src\sql\external\turbine-oracle.sql ? > > Cause if you did, this one created a ID_TABLE in your > database, and it was a > mistake. Instead of using a proper sequence to increase ids, > it used the > id_table > > If you want to keep your datas, David Sean Taylor point me to > a solution : > > DROP the ID_TABLE > > 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'll have to do the same I think for Profile, if you stored > them in DB > too. > > For more details : > http://www.mail-archive.com/[EMAIL PROTECTED]/m sg06936.html
Danny a �crit : > Hello folks, (please try to help me) > > I still have problems with DB after uptading jetspeed from > 1.4 b1 to 1.4 b3. > > After adding the missing column in the TURBINE_USER table, i thought > everything works fin, but now I tried to create a new user, and get > the following: > > There has been an Error! > Reason: > ... > > So here comes the question: > > Are there any other changes, I have to pay attention to? > I noticed that the DB scripts changed, but I'm no DB expert. We want > to keep the information in our DB ( I assume that cleanig DB and > re-populate would fix the problem), is there any way to do so? > > Thanks Danny > > ========================================== > T-Systems Multimedia Solutions GmbH > Danny Gehl > Authorized Java Center (AJC) > Hausanschrift: Riesaer Stra�e 5, 01029 Dresden > Tel.: (0351) 8505 845 > Fax.: (in Arbeit) > E-Mail: mailto:[EMAIL PROTECTED] > http://www.T-Systems-MMS.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
