RE: WO5.2 Primary key generation with SQL Server

I discovered what my problem was.  Turns out that table had a composite key, and I had forgotten to propagate a key.


-Brian

-----Original Message-----
From: [email protected] [mailto:[email protected]]On
Behalf Of Patrick Middleton
Sent: Friday, February 27, 2004 3:46 AM
To: [email protected]
Subject: Re: WO5.2 Primary key generation with SQL Server



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)

_______________________________________________
EOF mailing list
[email protected]
http://www.omnigroup.com/mailman/listinfo/eof