Re: WO 5.1. Primary keys generation : how to use the Oracle sequences like in WO 4.5. ?

Hello Matthieu,

as far as I know just create a sequence in Oracle named YOURTABLE_SEQ
and WO will use it as long as YOURTABLE
has a single primary key of type number (i) and you keep to the naming
convention. We do just this and everybody
(Oracle, WO and we)  is glad ;-)

HTH
Susanne

>
> Hi,
>
> We are migrating our applications from WO4.5 to 5.1.3.
> (What a pleasure !!!)
>
> Problem :
> In 4.5, primary keys were created by the Oracle sequences.
> In 5.1, WO uses EO_PK_TABLE.
> Question :
>
> How to enforce WO5.1 to use the sequences ? We read some issues (TN2027)
> about JDBC Plugin, but we don’t know what to do, which code to
> implement.

--
Susanne Schneider
Programming Unit / Knowledge-Acquisition
Software Developer

iAS interActive Systems
Gesellschaft fuer interaktive Medien mbH
Dieffenbachstr. 33 c
10967 Berlin
Germany

fon    +49(0)30 69004-143
fax    +49(0)30 69004-101
mail   [email protected]
URL    http://www.interActive-Systems.de