It's been a while for me too, but all i think you need to do is create
an oracle sequence with the table name suffixed by "_SEQ"
Like...
<TABLE_NAME>_SEQ
I think the checkbox in the modeler under PK generation is for when you
have a custom pk mechanism. You should probably leave this unchecked
and give it try first with just the sequence.
e.
On Aug 2, 2004, at 6:21 PM, Mike Kienenberger wrote:
> Scott Ellsworth <scot..lodar.com> wrote:
>> My last letter appears to be in error, if Cayenne already has Oracle
>> support. This would be half the battle for me.
>>
>> Could you float a documentation ref my way on how to use an Oracle
>> sequence to drive pk generation?
>>
>> (We use this for exactly the reason you mention - some people use
>> Access, others use C#, and basing it all of oracle sequences means
>> that
>> every method works.)
>
> For Oracle, from what I remember, it's just a matter of checking a box
> in
> the modeler, and making sure you've set the correct sequence size.
> Cayenne
> uses 20 by default. WebObjects used 1 by default, so I had to change
> it to
> 1 while we were using both frameworks.
>
> -Mike
>
This archive was generated by hypermail 2.0.0 : Mon Aug 02 2004 - 18:34:13 EDT