[JS1-265] java.sql.SQLException: ORA-02289: sequence does not exist

• Type: Bug
• Status: Resolved
• Resolution: Incomplete
• Affects Version/s: 1.4b3
• Component/s: Turbine
• Environment: Operating System: Other; Platform: Other
• Bugzilla Id: 18671
• Assignee: Unassigned
• Reporter: Chris Conner
• Created: 04/Apr/03 05:50
• Updated: 16/Feb/11 21:04
• Resolved: 24/Mar/04 14:35

Description

I have been getting the following error when using the binary version of
jetspeed 1.4b3 with Oracle 8.1.7

java.sql.SQLException: ORA-02289: sequence does not exist

I received this error when trying to add users and roles.
This happens because the actual name of the sequence, created
by turbine-oracle.sql, is TURBINE_USER_SEQ and not
TURBINE_USER, which is the name of the table.

I worked around this problem by downloading the source and modifiy the
build.properties and dbpsml.properties (under src/build/torque) to use Oracle.
And then rebuilt everything.