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 Bruno Lowagie <br...@rug.ac.be> on 2001/06/22 12:34:57 UTC
URGENT: please add this fix in CVS
In jakarta-jetspeed/src/sql/external/turbine-oracle.sql
You should add the scheme for an extra table:
-----------------------------------------------------------------------------
-- ID_TABLE
-----------------------------------------------------------------------------
drop table ID_TABLE cascade constraints;
drop sequence ID_TABLE_SEQ;
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);
(see jakarta-turbine/src/sql/oracle-id-table-schema.sql)
in jakarta-jetspeed/src/sql/external/default_roles_permissions.sql,
you should add the following records:
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);
(see jakarta-turbine/src/sql/oracle-turbine-id-table-init.sql)
This changes the error:
ORA-00942: table or view does not exist
into the error:
The table TURBINE_USER does not have a proper entry in the ID_TABLE
This error makes a newbie look less stupid and avoids people saying:
if you follow our instructions, it must work (or you're a moron)
OK, now you can still say I'm a moron because you can say:
hey man, you don't have a record for TURBINE_USER in ID_TABLE.
Well, I looked at the code in IDBroker, method selectRow
and I saw the exact SQL statement is:
SELECT NEXT_ID, QUANTITY FROM ID_TABLE WHERE TABLE_NAME='TURBINE_USER';
when I do this query in SqlPlus, I get:
NEXT_ID QUANTIY
---------- ---------
100 10
But when this same query is performed by Turbine, the resultset
seems to be empty. This is very, very strange...
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: URGENT: please add this fix in CVS
Posted by Bruno Lowagie <br...@rug.ac.be>.
Raphaël Luta wrote:
>
> Thanks for all the work you did in debugging the Oracle support, it's very
> important issue that I have no way of testing !
Thank YOU for listening to my problems.
I wrote a Free Software/Open Source library myself
(http://www.lowagie.com/iText/) and I know how difficult
it is to fix bugs if you can't reproduce the problem.
I hope I will get to know jetspeed better soon.
Now that the Oracle issue is solved, two extra people
can start on a project here, so you can expect some
more feedback.
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
RE: Jetspeed/Slide integrations..
Posted by David Sean Taylor <da...@bluesunrise.com>.
Search the mailing list.
We've discussed it a few times, but I don't think anyone ever did anything.
-------------------------------------
David Sean Taylor
taylor@apache.org
-------------------------------------
http://jakarta.apache.org/jetspeed
-------------------------------------
> -----Original Message-----
> From: Sony Joseph [mailto:sony@eself.com]
> Sent: Friday, June 22, 2001 12:02 PM
> To: jetspeed-user@jakarta.apache.org
> Subject: Jetspeed/Slide integrations..
>
>
> Hi,
>
> Has anyone tried to integrate Slide and jetspeed ?
>
> - Sony
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Jetspeed/Slide integrations..
Posted by Sony Joseph <so...@eself.com>.
Hi,
Has anyone tried to integrate Slide and jetspeed ?
- Sony
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
RE: URGENT: please add this fix in CVS
Posted by David Sean Taylor <da...@bluesunrise.com>.
>
> The script found in turbine is probably the best to use since Jetspeed
> AFAIK doesn't have any special modifications to the Turbine model.
The scripts are generated by Torque.
I'd like to distribute Torque with Jetspeed, so that people can generate
their own scripts.
The alternative is for us to run Torque for each supported database,
generate the scripts, and then put them in the src/sql directory.
I prefer distributing Torque, and documenting the procedures (there is
already some good docs with Turbine).
>
> David, can you confirm that JetspeedSecurity does not modify
> the base user
> model ?
I did not modify the table structure, although I do add some rows.
I don't want to have to write 7 different scripts to populate the security
tables.
With Torque, I can write one XML, database neutral schema, and then have
Torque generate the vendor-specific scripts.
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: URGENT: please add this fix in CVS
Posted by Raphaël Luta <ra...@networks.groupvu.com>.
Bruno Lowagie wrote:
> Bruno Lowagie wrote:
>
>>This changes the error:
>>ORA-00942: table or view does not exist
>>into the error:
>>The table TURBINE_USER does not have a proper entry in the ID_TABLE
>>
>
> After rebooting, restarting, etc...
> I don't get this error anymore...
> I'm puzzled...
>
> Now I'm going to take a look at:
> jakarta-turbine/src/sql/oracle-turbine-security.sql
> Has anybody looked at this script concerning jetspeed?
>
The script found in turbine is probably the best to use since Jetspeed
AFAIK doesn't have any special modifications to the Turbine model.
David, can you confirm that JetspeedSecurity does not modify the base user
model ?
If so, I'll update over the week-end all the DB scripts in Jetspeed to use
the Turbine 2.1 ones.
Thanks for all the work you did in debugging the Oracle support, it's very
important issue that I have no way of testing !
--
Raphael Luta - raphael.luta@networks.groupvu.com
Vivendi Universal Networks - Paris
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: URGENT: please add this fix in CVS
Posted by Bruno Lowagie <br...@rug.ac.be>.
Bruno Lowagie wrote:
>
> This changes the error:
> ORA-00942: table or view does not exist
> into the error:
> The table TURBINE_USER does not have a proper entry in the ID_TABLE
After rebooting, restarting, etc...
I don't get this error anymore...
I'm puzzled...
Now I'm going to take a look at:
jakarta-turbine/src/sql/oracle-turbine-security.sql
Has anybody looked at this script concerning jetspeed?
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org