> Hi Guys,
> 
> A couple of colleagues of mine are installing the Turbine database on Oracle
> and are experiencing a number of problems with the scripts. They have tried
> to follow the info on the Turbine site but I think the info is out of date.
> 
> Are there any known problems concerning the Oracle scripts and if so does
> anyone have any fixes??
> 
> /colin

Can you list these problems ? Any specifics ?

I know of one problem that I've run into when I ran the turbine-security.sql.that
gets generated through the build-project turbine-security-sql call.

I generates this insert statement

INSERT INTO TURBINE_USER 
    (LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME) 
    VALUES
    ('turbine', 'turbine', 'turbine', 'turbine');

This doesn't run because Oracle doesnt autoincrement the id and doesn't 
accept this insert without the USER_ID field. So I added it and that runs fine.

INSERT INTO TURBINE_USER 
    (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME) 
    VALUES
    (1, 'turbine', 'turbine', 'turbine', 'turbine');

I did it as a quick hack and never really looked into it any further, so I might 
have missed something.

Hope this helps,
Age




------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?:           [EMAIL PROTECTED]

Reply via email to