• 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: Probleme re-executing adaptor operations
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Probleme re-executing adaptor operations


  • Subject: Re: Probleme re-executing adaptor operations
  • From: Jean-Francois Veillette <email@hidden>
  • Date: Thu, 18 Feb 2010 11:20:00 -0500

For no obvious reason, eof tries to save operations twice to the bd, all within the same 'saveChanges'.
hand-crafted log reduction for simplicity (full log at the end) ...
"ReclRepresentantLegal"@13255337 expression took 3 ms: INSERT INTO recl_representant_legal(pk) VALUES ( ?) withBindings: 1:4239[pk]
"ReclDossierReclamationLoi73_2009"@13255337 expression took 5 ms: INSERT INTO recl_reclamation( pk) VALUES (?) withBindings: 18:815[pk]
"ReclEcritureG2"@13255337 expression took 2 ms: INSERT INTO recl_ecriture_g2(pk) VALUES (?) withBindings: 5:11338[pk]
"ReclRepresentantLegal"@13255337 expression took 3 ms: INSERT INTO recl_representant_legal(pk) VALUES ( ?) withBindings: 1:4239[pk]
com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression failed: <com.webobjects.jdbcadaptor.MicrosoftPlugIn$MicrosoftExpression: "INSERT INTO recl_reclamation(pk) VALUES (?)" withBindings: 18:815(pk)>:


It does look like it fails after the ReclEcritureG2 and try to rerun the whole list of adaptor operations.

It might do that if it thought it lost connection to the database. Does it open a new transaction?



I'm on WO5.3.x (latest), a recent checkout of Wonder, MS-SQLServer 08.00.2055, fresh copy of sqljdbc.jar.

Strange thing is that it does sometime work, when I run it in the debugger, it sometimes get through. I have not found anything different from a success-run and the usual failed-run other than the time spent in the debugger.
Does anyone have any idea where it could come from ?
Any clue where I could look at ?

Can you look at the database log (not the EOF log from EOF) and see if any errors are being returned?

The probleme actually cambe from a hidden sql command.
Only hidden because my log was showing successuf sql request with the entity and time something wonder does.
When Pascal figured out to log SQL before they where sent to the db, I was able to debug and see which one failed. It was a problem with some new tables.


Is there a way to 'raise' instead of 'swallow-and-retry' when there is a db exception ?
Is it a problem with my plugin ? the mssql jdbc adaptor ?


Thanks Chuck for pointing me in the right direction,

- jfv


_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
  • Follow-Ups:
    • Re: Problem re-executing adaptor operations
      • From: Chuck Hill <email@hidden>
References: 
 >Probleme re-executing adaptor operations (From: Jean-Francois Veillette <email@hidden>)
 >Re: Probleme re-executing adaptor operations (From: Chuck Hill <email@hidden>)

  • Prev by Date: Re: Quoting hell, anybody a solution?
  • Next by Date: Re: Quoting hell, anybody a solution?
  • Previous by thread: Re: Probleme re-executing adaptor operations
  • Next by thread: Re: Problem re-executing adaptor operations
  • Index(es):
    • Date
    • Thread