Hello,
I installed Jetspeed and I am trying to get it working with Oracle.
I followed all the instructions, creating the tables:
TURBINE_PERMISSION, TURBINE_ROLE, TURBINE_GROUP,
TURBINE_ROLE_PERMISSION, TURBINE_USER, TURBINE_USER_GROUP_ROLE,
TURBINE_SCHEDULED_JOB
I also used the script to add some default users:
turbine/turbine admin/jetspeed
However, when I tried to add a new user, I always got an error:
'ORA-00942: table or view does not exist'
After annoying the people on the jetspeed mailing list
(they said: if you followed our instructions, everything
should work. I said: I followed your instruction and it
still doesn't work), I finally discovered what table was
missing: ID_TABLE (the people at jetspeed really should
update their documentation).
I added this table and filled it with a record per table.
Now I don't get the ORA-00942 error anymore, but I get this:
The table TURBINE_USER does not have a proper entry in the ID_TABLE
Hello? I made the table TURBINE_USER empty and the content of
the record for table TURBINE_USER is created by this:
insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
(5, 'TURBINE_USER', 100, 10);
(from the script in CVS)
Not only I would like to know what's wrong, I would also want
to get rid of this ID_TABLE. I want Jetspeed/Turbine to use my
TURBINE_USER_SEQ so I don't depend on the extra table if I want
to users from another app...
FYI: this is the stacktrace of my error:
[Fri Jun 22 10:29:28 CEST 2001] -- INFO -- Forced id retrieval - no
available vector
[Fri Jun 22 10:29:28 CEST 2001] -- DEBUG -- BasePeer.doUpdate:
whereClause=TABLE_NAME='TURBINE_USER'
[Fri Jun 22 10:29:28 CEST 2001] -- ERROR --
Exception:
org.apache.turbine.util.security.DataBackendException:
Failed to create account 'blowagie': The table TURBINE_USER does not
have a proper entry in the ID_TABLE
Stack Trace follows:
org.apache.turbine.util.TurbineException: The table TURBINE_USER
does
not have a proper entry in the ID_TABLE
at
org.apache.turbine.util.db.IDBroker.selectRow(IDBroker.java:702)
at
org.apache.turbine.util.db.IDBroker.storeIDs(IDBroker.java:557)
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)
rethrown as org.apache.turbine.util.security.DataBackendException:
Failed to create account 'blowagie': The table TURBINE_USER does not
have a proper entry in the ID_TABLE
at
org.apache.turbine.services.security.db.DBUserManager.createAccount(DBUserManager.java:404)
at
org.apache.turbine.services.security.BaseSecurityService.addUser(BaseSecurityService.java:392)
at
org.apache.turbine.services.security.TurbineSecurity.addUser(TurbineSecurity.java:430)
at
org.apache.jetspeed.modules.actions.CreateNewUserAndConfirm.doPerform(CreateNewUserAndConfirm.java:176)
at org.apache.turbine.modules.Action.perform(Action.java:87)
at
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
at
org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:143)
at org.apache.turbine.modules.Page.build(Page.java:90)
at
org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123)
at org.apache.turbine.Turbine.doGet(Turbine.java:447)
at org.apache.turbine.Turbine.doPost(Turbine.java:537)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)
at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
at java.lang.Thread.run(Thread.java:484)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
