At 21:08 2000-12-18, KARANDIKAR Aditi / FTR&D wrote:
>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 ?
No, not Oracle_roles_permissions, that's old - don't know why it's still in
their CVS...
It's quite likely that you get the same error - I just copied the script
from turbine. Please report your error to the turbine list.
ingo.
>-----Original Message-----
>From: ingo schuster
>[<mailto:[EMAIL PROTECTED]>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]>mailto:[EMAIL PROTECTED]
> .com]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/>http://java.apache.org/faq/>
>To subscribe: [EMAIL PROTECTED]
>To unsubscribe: [EMAIL PROTECTED]
>Archives and
>Other:
><<http://marc.theaimsgroup.com/?l=jetspeed>http://marc.theaimsgroup.com/?l=jetspeed>
>
>Problems?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
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]
