Re: WO5.2 Primary key generation with SQL Server

Patrick Middleton <[email protected]> Fri, 27 Feb 2004 09:45:52 +0000

Newsgroups	gmane.comp.web.webobjects.eof
Message-ID	<[email protected]>

On Thursday, February 26, 2004, at 07:18  pm, Lakeman, Brian wrote:

> I can't get primary key generation working with SQL Server.
>
> I'm using the com.webobjects.jdbcadaptor.MicrosoftPlugIn, and I've got 
> the EO_PK_TABLE created in the database.  I'm logging all of the SQL 
> going to the database, and I don't even see an attempt to select out of 
> the EO_PK_TABLE.
>
> What am I missing?
>
> Thanks
>
> -Brian
>
> [email protected]

Because PK generation, via the methods in 
com.webobjects.eoaccess.EOAdaptorChannel such as 
primaryKeysForNewRowsWithEntity(), does not issue SQL via methods which 
conduct logging such as performAdaptorOperation().

Can't get primary key generation working with SQL Server, and you have a 
table EO_PK_TABLE?  Shouldn't you also have a stored procedure 
eo_pk_for_table?

--
Patrick Middleton
OneStep Solutions plc
351 London Road             Phone: +44 (0)1702 426400
Hadleigh                    Fax:   +44 (0)1702 556855
Essex. SS7 2BT              Email: [email protected]
England                            (MIME welcome)