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 13:57:34 -0700
Art, Chuck, and Liz - you're terrific!
I'll have to become more versed in the use of the 'diamonds' and 'locks',
and the EOModeler in general. When using someone else's data source it
seems you can't make too many assumptions.
Setting the 'lock' only on valid fields seems to be the culprit. Thanks for
all your help!
-Bill
on 9/9/04 12:36, Dirk Bajohr at email@hidden wrote:
> Hi Bill,
>
> as Chuck already said you should turn off the locking for all date/time
> attributes in your table. If you're new to WO and EOModeler it's the
> small lock symbol in EOModeler. If the lock is visible the column will
> be used for locking. Turn that lock off for all values like
> lastOutlookSyncDateTime, lastModified etc.
>
> If it works now try to find out the right value type for your date/time
> attributes. You should add the column "Value Type" in EOModeler (when
> viewing an entity, click on the triangle next to the upper "Add
> column..." and select "Value Type"). For MySQL, you put add a "T" for
> Timestamp values into that field.
>
> Hope that helps,
> Dirk
>
> Am 09.09.2004 um 20:35 schrieb Bill Reynolds:
>
>> 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._exceptionWithDatabaseContext
>> Infor
>> 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.
_______________________________________________
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.