Hi,

I have a comprehension problem!
I use an Oracle DB for my service! So I use the sql files for Oracle
fing in Turbine\src\sql.

If  I see the sql files for mysql, I can see that the AUTO_INCREMENT
fonction is used for
the PK of the table VISITOR (VISITORID): (for example)

...
create table Visitor(
    VISITORID   integer AUTO_INCREMENT PRIMARY KEY,
    LOGINID     varchar (32) NOT NULL,
...

My problem is how to do this with Oracle. In fact, there is no SEQUENCE
created in the sql file
for a db Oracle:

...
CREATE TABLE Visitor  (
    VISITORID   INT          NOT NULL,
    LOGINID     VARCHAR2(32) NOT NULL,
...
...
(here: no sequence created...ex: seq_visitor_id ...)

How can I do That?!

Do I make  every time a test in my *.java before a data storage in my
database?
Do I create my own sequences?

It has a comment in the sql files: -- Commented Sequence Creation /
Added ID_TABLE and JOBENTRY Tables
But I don't understand the think of the mecanism!

Thank for help

Note:I use an old version of  Turbine!




------------------------------------------------------------
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