Re: Generating primary key locally without extra tables

• Previous message: Tore Halset: "Re: Generating primary key locally without extra tables"
• In reply to: Tore Halset: "Re: Generating primary key locally without extra tables"
• Next in thread: Gentry, Michael \(Contractor\): "RE: MySql auto generated PK"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

On 6/21/06, Tore Halset <halse..vv.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

• Next message: Borut Bolčin: "Re: MySql auto generated PK"
• Previous message: Tore Halset: "Re: Generating primary key locally without extra tables"
• In reply to: Tore Halset: "Re: Generating primary key locally without extra tables"
• Next in thread: Gentry, Michael \(Contractor\): "RE: MySql auto generated PK"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Wed Jun 21 2006 - 10:25:36 EDT