cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Øyvind Harboe" <oyvind.har...@zylin.com>
Subject Re: Generating primary key locally without extra tables
Date Wed, 21 Jun 2006 14:25:11 GMT
On 6/21/06, Tore Halset <halset@pvv.ntnu.no> wrote:
> On Jun 21, 2006, at 15:16, Øyvind Harboe wrote:
>
> > If I can have an MSAccess & Oracle & MS SQL adapter that supports
> > server generated keys, then that will also solve my problems.
>
> So, after your MSAccess-work, it does support generated keys. MS SQL
> Server adapter works with generated keys if you use jtds. I have not
> used the oracle adapter, but it does not look like it supports
> generated keys.
>
> Looks like (googling) the Oracle jdbc driver does not support
> generated keys either. Perhaps you can create a separate PkGenerator
> that uses the max()+1 hack just for oracle?

That does sound like a solution yes. Though I haven't yet googled up
any examples on how to do this. The PkGenerator I found was concerned
with creating/dropping the primary key tables...

-- 
Øyvind Harboe
http://www.zylin.com

Mime
View raw message