Hi Danny, I think you are using the binary version of jetspeed 1.4-b3? Some classes there are compiled for usage of the idbroker, while other classes are trying to use Oracle sequences... The cleanest way for this was for me to build the jetspeed-1.4b3.jar from the sources and make sure that oracle was used in the torque/build.properties.
Yours, Holger Wessels ([EMAIL PROTECTED]) -- Holger We�els T-Systems Systems Integration T-Systems Nova GmbH Berkom Experte F&E Hausadresse: Goslarer Ufer 35, 10589 Berlin Telefon: (030) 34 97 - 22 66 Telefax: (030) 34 97 - 22 67 E-Mail: [EMAIL PROTECTED] Internet: http://www.t-systems.com Intranet: http://berkom.telekom.de -----Urspr�ngliche Nachricht----- Von: Danny [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 5. M�rz 2003 16:04 An: 'Jetspeed Users List' Betreff: AW: Oracle DB + Jetspeed 1.4 b3 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]
smime.p7s
Description: S/MIME cryptographic signature
