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.....
-----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 supportHi,
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.
