I'm not sure which of the scripts to run. I'm still getting the same error. I checked out the latest turbine from cvs and used those scripts. Do I run just turbine-oracle.sql and Oracle_id.sql, and default_roles_permissions.sql or do I also have to run the Oracle_roles_permissions.sql ?
-----Original Message-----
From: ingo schuster [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 17, 2000 10:01 AM
To: JetSpeed
Subject: RE: Oracle support
At 21:08 2000-12-15, David Sean Taylor wrote:
>Try replacing your INSERT statement with this:
>
>insert into Visitor (VISITORID, LOGINID, PASSWORD_VALUE, FIRST_NAME,
>LAST_NAME, MODIFIED, CREATED, CONFIRM_VALUE ) values (1, 'turbine',
>'turbine', 'turbine', 'turbine', sysdate, sysdate, 'CONFIRMED' );
>
>You have to make sure the VISITOR id is unique. I believe the old script
>has a bug and doesn't specify a VISITORID value
>
>Instead of using a hard-coded value for the VISITORID, its better to use a
>sequence for uniqueness
>
>The latest build fixes this. But beware that the schema is different i.e.
>the VISITOR table is now called TURBINE_USER.....
>
The sql files are copied from turbine cvs. if there are any bugs in there,
please report also to the turbine list.
ingo.
>-----Original Message-----
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED]]On Behalf Of KARANDIKAR Aditi / FTR&D
>Sent: Friday, December 15, 2000 11:53 AM
>To: 'JetSpeed'
>Subject: Oracle support
>
>Hi,
>I've been trying to get Jetspeed 1.2b1 and also the latest Jetspeed
>version from CVS to run with an Oracle database with absolutely no
>success. I don't know if the oracle scripts are buggy or not but everytime
>I get stck with the error saying "cannot insert null values into ("SYSTEM"
>"VISITOR" "VISITORID").
>Right now my job depends on getting Jetspeed to work with oracle and I
>would greatly appreciate your help.
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://marc.theaimsgroup.com/?l=jetspeed>
Problems?: [EMAIL PROTECTED]
