Re: Probleme re-executing adaptor operations
Re: Probleme re-executing adaptor operations
- Subject: Re: Probleme re-executing adaptor operations
- From: Chuck Hill <email@hidden>
- Date: Wed, 10 Feb 2010 18:50:05 -0800
On Feb 10, 2010, at 7:21 AM, Jean-Francois Veillette wrote:
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?
Chuck
09:58:53,551 DEBUG (ERXEOAccessUtilities.java:1217) -
"ReclRepresentantLegal"@13255337 expression took 3 ms: INSERT INTO
recl_representant_legal(prenom, firme, pk, nom, adresse) VALUES
(NULL, NULL, ?, NULL, NULL) withBindings: 1:4239[pk]
09:58:53,553 DEBUG (ERXEOAccessUtilities.java:1217) -
"ReclRepresentantLegal"@13255337 expression took 1 ms: INSERT INTO
recl_representant_legal(prenom, firme, pk, nom, adresse) VALUES
(NULL, NULL, ?, NULL, NULL) withBindings: 1:4238[pk]
09:58:53,556 DEBUG (ERXEOAccessUtilities.java:1217) -
"ReclRepresentantLegal"@13255337 expression took 2 ms: INSERT INTO
recl_representant_legal(prenom, firme, pk, nom, adresse) VALUES
(NULL, NULL, ?, NULL, NULL) withBindings: 1:4240[pk]
09:58:53,565 DEBUG (ERXEOAccessUtilities.java:1217) -
"ReclDossierReclamationLoi73_2009"@13255337 expression took 5 ms:
INSERT INTO recl_reclamation(code_statut, resume,
date_transaction_courtage, montant_reserve_frais, no_dossier,
fk_nature_cause, fk_etat_ouverture, date_reouverture,
date_fermeture, fk_type_transaction, est_couvert, taux_risque,
montant_domage_reel, date_prochain_suivi, fk_etat_courant,
montant_reclame, fk_representant_legal_farciq, taux_responsabilite,
date_ouverture, date_avis_reassureur, fk_nature_faute,
est_farciq_poursuivis, montant_reserve_indemnite, region_membre,
fk_parametre, fk_representant_legal_expert, code_reglementation,
montant_reserve_frais_juridique, date_faute, pk,
fk_etat_dossier_farciq_ouverture) VALUES (?, NULL, NULL, ?,
NULL, ?, ?, NULL, NULL, ?, ?, NULL, NULL, ?, ?, NULL, ?, NULL, ?,
NULL, ?, ?, ?, NULL, ?, ?, ?, ?, NULL, ?, ?) withBindings:
1:0[codeStatut], 2:5000.0000[montantReserveFraisReglement],
3:2[fk_nature_cause], 4:3[fk_etat_ouverture],
5:1[fk_type_transaction], 6:NULL[estCouvert],
7:NULL[dateProchainSuivi], 8:3[fk_etat_courant],
9:4239[fk_representant_legal_farciq], 10:NULL[dateOuverture],
11:6[fk_nature_faute], 12:NULL[estFarciqPoursuivis],
13:7500.0000[montantReserveIndemnite], 14:5[fk_parametre],
15:4238[fk_representant_legal_expert], 16:7309[codeReglementation],
17:0.0000[montantReserveFraisJuridique], 18:815[pk],
19:1[fk_etat_dossier_farciq_ouverture]
09:58:53,568 DEBUG (ERXEOAccessUtilities.java:1217) -
"ReclEcritureG2"@13255337 expression took 2 ms: INSERT INTO
recl_ecriture_g2(fk_reclamation, date, code_g2, date_effective, pk,
montant_debit, montant_credit) VALUES (?, ?, ?, ?, ?, ?, ?)
withBindings: 1:815[fk_reclamation], 2:NULL[date], 3:20510[codeG2],
4:NULL[dateEffective], 5:11340[pk], 6:0[montantDebit],
7:7500.0000[montantCredit]
09:58:53,571 DEBUG (ERXEOAccessUtilities.java:1217) -
"ReclEcritureG2"@13255337 expression took 2 ms: INSERT INTO
recl_ecriture_g2(fk_reclamation, date, code_g2, date_effective, pk,
montant_debit, montant_credit) VALUES (?, ?, ?, ?, ?, ?, ?)
withBindings: 1:815[fk_reclamation], 2:NULL[date], 3:59110[codeG2],
4:NULL[dateEffective], 5:11341[pk], 6:5000.0000[montantDebit],
7:0[montantCredit]
09:58:53,573 DEBUG (ERXEOAccessUtilities.java:1217) -
"ReclEcritureG2"@13255337 expression took 2 ms: INSERT INTO
recl_ecriture_g2(fk_reclamation, date, code_g2, date_effective, pk,
montant_debit, montant_credit) VALUES (?, ?, ?, ?, ?, ?, ?)
withBindings: 1:815[fk_reclamation], 2:NULL[date], 3:10360[codeG2],
4:NULL[dateEffective], 5:11339[pk], 6:2500.0000[montantDebit],
7:0[montantCredit]
09:58:53,576 DEBUG (ERXEOAccessUtilities.java:1217) -
"ReclEcritureG2"@13255337 expression took 2 ms: INSERT INTO
recl_ecriture_g2(fk_reclamation, date, code_g2, date_effective, pk,
montant_debit, montant_credit) VALUES (?, ?, ?, ?, ?, ?, ?)
withBindings: 1:815[fk_reclamation], 2:NULL[date], 3:40450[codeG2],
4:NULL[dateEffective], 5:11342[pk], 6:0[montantDebit],
7:2500.0000[montantCredit]
09:58:53,579 DEBUG (ERXEOAccessUtilities.java:1217) -
"ReclEcritureG2"@13255337 expression took 3 ms: INSERT INTO
recl_ecriture_g2(fk_reclamation, date, code_g2, date_effective, pk,
montant_debit, montant_credit) VALUES (?, ?, ?, ?, ?, ?, ?)
withBindings: 1:815[fk_reclamation], 2:NULL[date], 3:20520[codeG2],
4:NULL[dateEffective], 5:11337[pk], 6:0[montantDebit],
7:5000.0000[montantCredit]
09:58:53,582 DEBUG (ERXEOAccessUtilities.java:1217) -
"ReclEcritureG2"@13255337 expression took 2 ms: INSERT INTO
recl_ecriture_g2(fk_reclamation, date, code_g2, date_effective, pk,
montant_debit, montant_credit) VALUES (?, ?, ?, ?, ?, ?, ?)
withBindings: 1:815[fk_reclamation], 2:NULL[date], 3:59000[codeG2],
4:NULL[dateEffective], 5:11338[pk], 6:7500.0000[montantDebit],
7:0[montantCredit]
09:58:53,587 DEBUG (ERXEOAccessUtilities.java:1217) -
"ReclRepresentantLegal"@13255337 expression took 3 ms: INSERT INTO
recl_representant_legal(prenom, firme, pk, nom, adresse) VALUES
(NULL, NULL, ?, NULL, NULL) withBindings: 1:4239[pk]
09:58:53,590 DEBUG (ERXEOAccessUtilities.java:1217) -
"ReclRepresentantLegal"@13255337 expression took 2 ms: INSERT INTO
recl_representant_legal(prenom, firme, pk, nom, adresse) VALUES
(NULL, NULL, ?, NULL, NULL) withBindings: 1:4238[pk]
09:58:53,592 DEBUG (ERXEOAccessUtilities.java:1217) -
"ReclRepresentantLegal"@13255337 expression took 2 ms: INSERT INTO
recl_representant_legal(prenom, firme, pk, nom, adresse) VALUES
(NULL, NULL, ?, NULL, NULL) withBindings: 1:4240[pk]
09:58:53,607 ERROR (Consultation.java:670) - Probleme de
sauvegarde:null usager: "V, JF"
com.webobjects.eoaccess.EOGeneralAdaptorException:
EvaluateExpression failed:
<com.webobjects.jdbcadaptor.MicrosoftPlugIn$MicrosoftExpression:
"INSERT INTO recl_reclamation(code_statut, resume,
date_transaction_courtage, montant_reserve_frais, no_dossier,
fk_nature_cause, fk_etat_ouverture, date_reouverture,
date_fermeture, fk_type_transaction, est_couvert, taux_risque,
montant_domage_reel, date_prochain_suivi, fk_etat_courant,
montant_reclame, fk_representant_legal_farciq, taux_responsabilite,
date_ouverture, date_avis_reassureur, fk_nature_faute,
est_farciq_poursuivis, montant_reserve_indemnite, region_membre,
fk_parametre, fk_representant_legal_expert, code_reglementation,
montant_reserve_frais_juridique, date_faute, pk,
fk_etat_dossier_farciq_ouverture) VALUES (?, NULL, NULL, ?,
NULL, ?, ?, NULL, NULL, ?, ?, NULL, NULL, ?, ?, NULL, ?, NULL, ?,
NULL, ?, ?, ?, NULL, ?, ?, ?, ?, NULL, ?, ?)" withBindings:
1:0(codeStatut), 2:5000.0000(montantReserveFraisReglement),
3:2(fk_nature_cause), 4:3(fk_etat_ouverture),
5:1(fk_type_transaction), 6:true(estCouvert), 7:2010-03-06
00:00:00(dateProchainSuivi), 8:3(fk_etat_courant),
9:4239(fk_representant_legal_farciq), 10:2010-02-10
00:00:00(dateOuverture), 11:6(fk_nature_faute),
12:false(estFarciqPoursuivis),
13:7500.0000(montantReserveIndemnite), 14:5(fk_parametre),
15:4238(fk_representant_legal_expert),
16:"7309"(codeReglementation),
17:0.0000(montantReserveFraisJuridique), 18:815(pk),
19:1(fk_etat_dossier_farciq_ouverture)>:
Next exception:SQL State:23000 -- error code: 2627 -- msg:
Violation of PRIMARY KEY constraint
'PK__recl_reclamation__216BEC9A'. Cannot insert duplicate key in
object 'recl_reclamation'.
_______________________________________________
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
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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