It doesn'T work that way, although I'm not able to change the values in the sequences (but the already exist, unchanged, as they were created). Do I have to switch the behaviour?
It seems, that there is some other error, because the Exception is thrown after these statements: select JETSPEED_USER_PROFILE.nextval from dual or select TURBINE_USER.nextval from dual these statements don't even work on my sql console, although the sequences exist. If I try something like: select TURBINE_USER_SEQ.nextval from dual I get a result at the console, is this normal? How is the convention? I tried this, because the sequence is named TURBINE_USER_SEQ... Any suggestions? I'm facing a deathline. Danny > -----Urspr�ngliche Nachricht----- > Von: Danny [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 5. M�rz 2003 15:47 > An: 'Jetspeed Users List' > Betreff: AW: Oracle DB + Jetspeed 1.4 b3 > > > 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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
