cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Norwood" <dav...@virtuant.com>
Subject Optimistic lock failure
Date Thu, 07 Dec 2006 14:45:15 GMT
Hi,

 

I the following transaction I insert a new record into a table, then
directly run rules on the data inserted and call an update to set specific
columns after running the rules. See the following error; isn't it OK for
the same user to update the table after inserting a row? Why am I getting
this error??

 

TIA,

 

-david

---------------- error output -----------------------

2006-12-06 09:50:52,406 DEBUG [org.jboss.mx.loading.RepositoryClassLoader]
setRepository,
repository=org.jboss.mx.loading.HeirarchicalLoaderRepository3@1c1f2,
cl=org.jboss.mx.loading.UnifiedClassLoader3@6ec21a{ url=null ,addedOrder=0}

2006-12-06 09:50:52,421 INFO  [org.objectstyle.cayenne.access.QueryLogger]
--- will run 1 query.

2006-12-06 09:50:52,421 INFO  [org.objectstyle.cayenne.access.QueryLogger]
UPDATE dbo.dochistory SET AVGREADING = ? WHERE ID = ? AND AUDITOR IS NULL
AND AVGREADING IS NULL AND DATA1 = ? AND DATA10 IS NULL AND DATA2 IS NULL
AND DATA3 IS NULL AND DATA4 IS NULL AND DATA5 IS NULL AND DATA6 IS NULL AND
DATA7 IS NULL AND DATA8 IS NULL AND DATA9 IS NULL AND DATETIME = ? AND INFO1
IS NULL AND INFO10 IS NULL AND INFO2 IS NULL AND INFO3 IS NULL AND INFO4 IS
NULL AND INFO5 IS NULL AND INFO6 IS NULL AND INFO7 IS NULL AND INFO8 IS NULL
AND INFO9 IS NULL AND ISDELETED = ? AND ISFAILURE = ? AND ISRECHECK = ? AND
PERSONNAME = ? AND PRESHIPPER IS NULL AND PRODUCTCODE IS NULL AND VERIFIER
IS NULL AND LOCATIONID = ? AND ORG_ID = ? AND PACKAGEID = ? AND USR_ID = ?

2006-12-06 09:50:52,421 INFO  [org.objectstyle.cayenne.access.QueryLogger]
[bind: 2.229999999999999982236431605997495353221893310546875, 4557, NULL,
NULL, 2.229999999999999982236431605997495353221893310546875, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-12-06 09:50:52.078', NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'false',
'false', 'Tom Johnson', NULL, NULL, NULL, 196, 34, 1179, 9]

2006-12-06 09:50:52,468 INFO  [org.objectstyle.cayenne.access.QueryLogger]
*** error.

org.objectstyle.cayenne.access.OptimisticLockException: [v.1.2.1 August 30
2006] Optimistic Lock Failure, SQL: [UPDATE dbo.dochistory SET AVGREADING =
? WHERE ID = ? AND AUDITOR IS NULL AND AVGREADING IS NULL AND DATA1 = ? AND
DATA10 IS NULL AND DATA2 IS NULL AND DATA3 IS NULL AND DATA4 IS NULL AND
DATA5 IS NULL AND DATA6 IS NULL AND DATA7 IS NULL AND DATA8 IS NULL AND
DATA9 IS NULL AND DATETIME = ? AND INFO1 IS NULL AND INFO10 IS NULL AND
INFO2 IS NULL AND INFO3 IS NULL AND INFO4 IS NULL AND INFO5 IS NULL AND
INFO6 IS NULL AND INFO7 IS NULL AND INFO8 IS NULL AND INFO9 IS NULL AND
ISDELETED = ? AND ISFAILURE = ? AND ISRECHECK = ? AND PERSONNAME = ? AND
PRESHIPPER IS NULL AND PRODUCTCODE IS NULL AND VERIFIER IS NULL AND
LOCATIONID = ? AND ORG_ID = ? AND PACKAGEID = ? AND USR_ID = ?], WHERE
clause bindings: [USR_ID=9, DATA6=NULL, ISRECHECK='false',
ISDELETED='false', INFO1=NULL, LOCATIONID=196, DATA5=NULL, AVGREADING=NULL,
AUDITOR=NULL, INFO8=NULL, DATA2=NULL, INFO2=NULL, DATETIME='2006-12-06
09:50:52.078', VERIFIER=NULL, DATA9=NULL, INFO4=NULL, PACKAGEID=1179,
ID=4557, INFO9=NULL, INFO3=NULL, DATA8=NULL, INFO6=NULL, DATA7=NULL,
INFO7=NULL, PERSONNAME='Tom Johnson', PRESHIPPER=NULL, DATA4=NULL,
DATA10=NULL, ORG_ID=34, DATA3=NULL, INFO10=NULL, INFO5=NULL,
PRODUCTCODE=NULL,
DATA1=2.229999999999999982236431605997495353221893310546875,
ISFAILURE='false']

       at
org.objectstyle.cayenne.access.jdbc.BatchAction.runAsIndividualQueries(Batch
Action.java:235)

       at
org.objectstyle.cayenne.access.jdbc.BatchAction.performAction(BatchAction.ja
va:117) 

 


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message