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:
java.sql.SQLException: ORA-02289: sequence does not exist
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:1597)
at oracle.jdbc.oci8.OCIDBAccess.parseExecuteDescribe(OCIDBAccess.java:798)
at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1674)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:1870)
at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:538)
at com.workingdogs.village.QueryDataSet.(Unknown Source)
at
org.apache.torque.oid.SequenceIdGenerator.getIdAsVillageValue(SequenceIdGene
rator.java:195)
rethrown as org.apache.torque.TorqueException: ORA-02289: sequence does not
exist
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:713)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:615)
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTur
bineUserPeer.java:242)
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTur
bineUserPeer.java:215)
at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser(
TurbineUserManagement.java:309)
at
org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUserMana
gement.java:134)
...
rethrown as org.apache.jetspeed.services.security.UserException: Failed to
create account 'a': ORA-02289: sequence does not exist
at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser(
TurbineUserManagement.java:316)
at
org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUserMana
gement.java:134)
at
org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.java:
238)
I shortened it a bit...
Now I checked the logs, and found the following in jetspeed.log:
[05 Mrz 2003 15:16:32 DEBUG] - SELECT TURBINE_USER.USER_ID,
TURBINE_USER.LOGIN_NAME, TURBINE_USER.PASSWORD_VALUE,
TURBINE_USER.FIRST_NAME, TURBINE_USER.LAST_NAME, TURBINE_USER.EMAIL,
TURBINE_USER.CONFIRM_VALUE, TURBINE_USER.MODIFIED, TURBINE_USER.CREATED,
TURBINE_USER.LAST_LOGIN, TURBINE_USER.DISABLED, TURBINE_USER.OBJECTDATA,
TURBINE_USER.PASSWORD_CHANGED FROM TURBINE_USER WHERE
TURBINE_USER.LOGIN_NAME='a'
[05 Mrz 2003 15:16:32 DEBUG] - Elapsed time=15 ms
[05 Mrz 2003 15:16:32 DEBUG] - select TURBINE_USER.nextval from dual
[05 Mrz 2003 15:16:32 ERROR] - CreateNewUserAndConfirm
java.sql.SQLException: ORA-02289: sequence does not exist
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:1597)
at oracle.jdbc.oci8.OCIDBAccess.parseExecuteDescribe(OCIDBAccess.java:798)
at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1674)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:1870)
...
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]
