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: Dirk Bajohr <email@hidden>
- Date: Thu, 9 Sep 2004 21:36:02 +0200
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.
--
Dirk Bajohr
iSOLUTION - Individuelle Software fuer moderne Kommunikation
Hauptstr. 50
53757 Sankt Augustin
T +49 2241 921567-0
F +49 2241 921567-89
http://www.isolution.de
_______________________________________________
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.