You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by jo...@hawkinsweb.co.uk on 2005/06/15 14:50:18 UTC

J1.6 Add User (Oracle 9i)

I have J1.6 running on Orion against an Oracle 9i Database.

When I try to add a user I get the following :-

Caused by: java.sql.SQLException: ORA-02289: sequence does not exist
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
        at
        oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:831)
        at
        oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2496)
        at
        oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2840)
        at
        oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:



The following sequqnces exist in the database :-

COFFEES_SEQ
EMAIL_INBOX_SEQ
JETSPEED_GROUP_PROFILE_SEQ
JETSPEED_ROLE_PROFILE_SEQ
JETSPEED_USER_PROFILE_SEQ
PORTLET_CATEGORY_SEQ
PORTLET_MEDIATYPE_SEQ
PORTLET_PARAMETER_SEQ
PORTLET_SEQ
SECURITY_ACCESS_SEQ
SECURITY_ALLOW_SEQ
SECURITY_ENTRY_SEQ
TURBINE_GROUP_SEQ
TURBINE_PERMISSION_SEQ
TURBINE_ROLE_PERMISSION_SEQ
TURBINE_ROLE_SEQ
TURBINE_USER_GROUP_ROLE_SEQ
TURBINE_USER_SEQ

I have populated the database using the supplied scripts and I tool the
jetspeed-torque-om-1.6.jar from www.bluesunrise.com distribution for Oracle.

I have looked at http://issues.apache.org/jira/browse/JS1-183 but code
appears to be ok.

Any Ideas,

Jon





---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org

Re: J1.6 Add User (Oracle 9i)

Posted by Jonathan Hawkins <jo...@hawkinsweb.co.uk>.
Is there anyway to find out what sequence is trying to be used.

Thanks

Jon


jonathan.hawkins@hawkinsweb.co.uk wrote:

>I have J1.6 running on Orion against an Oracle 9i Database.
>
>When I try to add a user I get the following :-
>
>Caused by: java.sql.SQLException: ORA-02289: sequence does not exist
>        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
>        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
>        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
>        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
>        at
>        oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:831)
>        at
>        oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2496)
>        at
>        oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2840)
>        at
>        oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:
>
>
>
>The following sequqnces exist in the database :-
>
>COFFEES_SEQ
>EMAIL_INBOX_SEQ
>JETSPEED_GROUP_PROFILE_SEQ
>JETSPEED_ROLE_PROFILE_SEQ
>JETSPEED_USER_PROFILE_SEQ
>PORTLET_CATEGORY_SEQ
>PORTLET_MEDIATYPE_SEQ
>PORTLET_PARAMETER_SEQ
>PORTLET_SEQ
>SECURITY_ACCESS_SEQ
>SECURITY_ALLOW_SEQ
>SECURITY_ENTRY_SEQ
>TURBINE_GROUP_SEQ
>TURBINE_PERMISSION_SEQ
>TURBINE_ROLE_PERMISSION_SEQ
>TURBINE_ROLE_SEQ
>TURBINE_USER_GROUP_ROLE_SEQ
>TURBINE_USER_SEQ
>
>I have populated the database using the supplied scripts and I tool the
>jetspeed-torque-om-1.6.jar from www.bluesunrise.com distribution for Oracle.
>
>I have looked at http://issues.apache.org/jira/browse/JS1-183 but code
>appears to be ok.
>
>Any Ideas,
>
>Jon
>
>
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
>For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>  
>


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org