Bruno Lowagie wrote:
>
> David Sean Taylor wrote:
> >
> > I would be very surprised if Turbine doesn't work correctly with Oracle....
Well, SURPRISE!
I got rid of the 'ORA-00942: table or view does not exist' error
after adding some scripts (see below (1)). Please mention those scripts
in your docs for Oracle users!
Unfortunately, I still get an error:
The table TURBINE_USER does not have a proper entry in the ID_TABLE
(see below (2) for stacktrace).
Hello? I deleted everything form TURBINE_USER to avoid duplicate keys.
I ran the script adding the records of ID_TABLE. If I do SELECT * FROM
ID_TABLE, I can see the record for TURBINE_USER. Do I really have to
read through the Turbine code to know what's wrong???
And again: I DON'T WANT TURBINE TO MESS WITH MY KEYS, I want
Turbine to use my TURBINE_USER_SEQ. Otherwise there WILL BE
conflicts after you run the script: default_roles_permissions.sql
(1)
CREATE TABLE ID_TABLE
(
ID_TABLE_ID INT NOT NULL,
TABLE_NAME VARCHAR2 (255) NOT NULL,
NEXT_ID INT,
QUANTITY INT,
UNIQUE (TABLE_NAME)
);
ALTER TABLE ID_TABLE
ADD CONSTRAINT ID_TABLE_PK
PRIMARY KEY (ID_TABLE_ID);
insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
(1, 'TURBINE_PERMISSION', 100, 10);
insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
(2, 'TURBINE_ROLE', 100, 10);
insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
(3, 'TURBINE_GROUP', 100, 10);
insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
(4, 'TURBINE_ROLE_PERMISSION', 100, 10);
insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
(5, 'TURBINE_USER', 100, 10);
insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
(6, 'TURBINE_USER_GROUP_ROLE', 100, 10);
insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
(7, 'TURBINE_SCHEDULED_JOB', 100, 10);
(2)
[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]
