Re: _exceptionWithDatabaseContextInformationAdded when trying to update SQL Server
Re: _exceptionWithDatabaseContextInformationAdded when trying to update SQL Server
- Subject: Re: _exceptionWithDatabaseContextInformationAdded when trying to update SQL Server
- From: Bill Reynolds <email@hidden>
- Date: Thu, 09 Sep 2004 11:35:54 -0700
Okay - I captured the Update statement from the log and started going
through it.
Passing over it (pasted below) it looks like a pretty simple/standard
"Update Where" clause. I'm not a SQL junky (that's why I was in love with
Eobjects to handle this stuff), but it all looks pretty straight forward.
I know it's painful to look at - but in the statement below is there
anything painfully obvious that would cause the
"_exceptionWithDatabaseContextInformationAdded"?
Many thanks to anyone caring to read on...
[2004-09-09 11:16:33 PDT] <WorkerThread9> evaluateExpression:
<com.webobjects.jdbcadaptor.MicrosoftPlugIn$MicrosoftExpression: "UPDATE
dbo.tblContacts SET FirstName = ? WHERE (AccountNumber = ? AND Prefix is
NULL AND FirstName = ? AND MiddleInitial is NULL AND LastName = ? AND
ContactName = ? AND Title is NULL AND Department is NULL AND Address1 is
NULL AND Address2 is NULL AND City is NULL AND State is NULL AND PostalCode
is NULL AND Country is NULL AND PersonalNotes is NULL AND LastModified = ?
AND LetterSalutation is NULL AND Assistant is NULL AND PrimaryPhoneNumber is
NULL AND PrimaryFaxNumber is NULL AND PrimaryPhoneNumberFormatted is NULL
AND PrimaryFaxNumberFormatted is NULL AND PrimaryEmailAddress = ? AND
SyncAlways = ? AND LastOutlookSyncDateTime = ?)" withBindings:
1:"Neptune"(firstname), 2:3(accountnumber), 3:"Steve"(firstname),
4:"Carman"(lastname), 5:"Steve Carman"(contactname), 6:2004-09-02
14:20:48(lastmodified), 7:"email@hidden"(primaryemailaddress),
8:0(syncalways), 9:2004-09-02 14:2[2004-09-09 11:16:33 PDT] <WorkerThread9>
=== Begin Internal Transaction
0:48(lastoutlooksyncdatetime)>
[2004-09-09 11:16:33 PDT] <WorkerThread9>
com.webobjects.eoaccess.EOGeneralAdaptorException:
updateValuesInRowDescribedByQualifier --
com.webobjects.jdbcadaptor.JDBCChannel method failed to update row in
database
at
com.webobjects.eoaccess.EODatabaseContext._exceptionWithDatabaseContextInfor
mationAdded(EODatabaseContext.java:4657)
on 9/9/04 09:44, Elizabeth Lynch at email@hidden wrote:
> Bill
>
> On 9 Sep 2004, at 17:21, Bill Reynolds wrote:
>
>> I am working in a controlled environment, so I can rule out changes
>> made to
>> data.
>>
>> I created an eo model of a single table, just because I wanted to
>> incrementally test the whole premise of "SQL Server - EOModeler". And
>> to be
>> super cautious I only tried updating one record, one field.
>>
>> I've never tried turning SQL logging on, can you point me to the right
>> location? (is it in xcode?)
>>
>
> Set a launch parameter for your project of -EOAdaptorDebugEnabled YES
>
> Liz
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.