• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: _exceptionWithDatabaseContextInformationAdded when trying to update SQL Server
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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.


  • Follow-Ups:
    • Re: _exceptionWithDatabaseContextInformationAdded when trying to update SQL Server
      • From: Bill Reynolds <email@hidden>
References: 
 >Re: _exceptionWithDatabaseContextInformationAdded when trying to update SQL Server (From: Bill Reynolds <email@hidden>)

  • Prev by Date: Re: _exceptionWithDatabaseContextInformationAdded when trying to update SQL Server
  • Next by Date: Re: _exceptionWithDatabaseContextInformationAdded when trying to update SQL Server
  • Previous by thread: Re: _exceptionWithDatabaseContextInformationAdded when trying to update SQL Server
  • Next by thread: Re: _exceptionWithDatabaseContextInformationAdded when trying to update SQL Server
  • Index(es):
    • Date
    • Thread