Bruno Lowagie wrote:
>
> I think I found the cause of my problem.
But I was wrong...
As I allready mentioned I made the database tables as user blowagie
and then granted several rights to user jetspeed:
http://www.lowagie.com/bruno/turbine-oracle.sql
http://www.lowagie.com/bruno/default_roles_permissions.sql
http://www.lowagie.com/bruno/privileges-jetspeed.sql
When I used sqlplus as user jetspeed, I could insert a new row:
insert into TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE,
FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE, CREATED )
values (turbine_user_seq.nextval, 't', 'test', 'test', 'test',
'[EMAIL PROTECTED]', 'CONFIRMED', SYSDATE );
However the application allways threw an exception (see below).
Remark: I had to add Log.error(e) on line 201 in class
CreateNewUserAndConfirm to see this error.
Afterwards, I dropped all my database-tables and ran the scripts
turbine-oracle.sql and default_roles_permissions.sql again, this
time as user jetspeed. Because I thought maybe the synonyms caused
some trouble. But this didn't solve a thing, I still get this error:
[Thu Jun 21 13:17:45 CEST 2001] -- INFO -- Forced id retrieval - no
available vector
[Thu Jun 21 13:17:45 CEST 2001] -- ERROR --
Exception:
org.apache.turbine.util.security.DataBackendException:
Failed to create account 'blowagie': ORA-00942: table or view does not
exist
Stack Trace follows:
java.sql.SQLException: ORA-00942: table or view does not exist
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:643)
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.Schema.schema(Schema.java:140)
at com.workingdogs.village.Schema.schema(Schema.java:107)
at com.workingdogs.village.DataSet.<init>(DataSet.java:167)
at
com.workingdogs.village.TableDataSet.<init>(TableDataSet.java:130)
at
org.apache.turbine.om.peer.BasePeer.doUpdate(BasePeer.java:1666)
at
org.apache.turbine.util.db.IDBroker.storeIDs(IDBroker.java:554)
at
org.apache.turbine.util.db.IDBroker.getNextIds(IDBroker.java:371)
at
org.apache.turbine.util.db.IDBroker.getIdAsBigDecimal(IDBroker.java:285)
at
org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:746)
at
org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:657)
at
org.apache.turbine.services.security.db.DBUserManager.createAccount(DBUserManager.java:399)
About what table or view is Turbine complaining?
I can add new records using sqlplus, why not from the application???
How is this turbine version implemented?
Lots of questions, I hope there is an answer.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
