javax.jdo.JDODataStoreException: [SQL=UPDATE USERX SET ZIPX='94619', STATEX='CA', REVOKEDX=0, COUNTRYX='US', EMAILX='sue@jacobs.com', VALIDATEDX=1, SCREENNAMEX='Sue', LOGINNAMEX='sue', LASTACCESSEDX={ts '2002-05-31 06:06:59.718'}, STATUSX=1,FIRSTNAMEX='Sue', ADDRESS1X='49 Broadway Terrace', EXPIRATION DATEX={ts '2002-05-29 16:57:07.0'}, EXPIRESX=NULL, ACCESSCOUNTERX=3, LASTNAMEX='Jacobs', ADDRESS2X='', CREATEDX={ts '2002-05-29 16:57:07.0'}, JDOLOCKX=4, LOGINNAMEUCX='SUE', CREDITCARDNUMBERX='4222222222222', CITYX='Oakland', PASSWORDX='sue', CVV2CODEX='445' WHERE (JDOIDX = 30 AND JDOLOCKX = 3)] General error: Deadlock found when trying to get lock; Try restarting transaction


Solutions on the web

Solution icon of oraclecommunity
via Oracle Community by 3004, 1 year ago
[SQL=UPDATE USERX SET ZIPX='94619', STATEX='CA', REVOKEDX=0, COUNTRYX='US', EMAILX='sue@jacobs.com', VALIDATEDX=1, SCREENNAMEX='Sue', LOGINNAMEX='sue', LASTACCESSEDX={ts '2002-05-31 06:06:59.718'}, STATUSX=1,FIRSTNAMEX='Sue', ADDRESS1X='49 Broadway

Stack trace

javax.jdo.JDODataStoreException: [SQL=UPDATE USERX SET
ZIPX='94619', STATEX='CA', REVOKEDX=0, COUNTRYX='US',
EMAILX='sue@jacobs.com', VALIDATEDX=1, SCREENNAMEX='Sue',
LOGINNAMEX='sue', LASTACCESSEDX={ts '2002-05-31 06:06:59.718'},
STATUSX=1,FIRSTNAMEX='Sue', ADDRESS1X='49 Broadway Terrace', EXPIRATION
DATEX={ts '2002-05-29 16:57:07.0'}, EXPIRESX=NULL, ACCESSCOUNTERX=3,
LASTNAMEX='Jacobs', ADDRESS2X='', CREATEDX={ts '2002-05-29 16:57:07.0'},
JDOLOCKX=4, LOGINNAMEUCX='SUE',
CREDITCARDNUMBERX='4222222222222', CITYX='Oakland', PASSWORDX='sue',
CVV2CODEX='445' WHERE (JDOIDX = 30 AND JDOLOCKX = 3)] General error:
Deadlock found when trying to get lock; Try restarting transaction
	at com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.update(JDBCStoreManager.java:352)
	at com.solarmetric.kodo.runtime.StateManagerImpl.storeFields(StateManagerImpl.java:1808)
	at com.solarmetric.kodo.runtime.PDirtyState.flush(PDirtyState.java:37)
	at com.solarmetric.kodo.runtime.StateManagerImpl.flush(StateManagerImpl.java:480)
	at com.solarmetric.kodo.runtime.PersistenceManagerImpl.flush(PersistenceManagerImpl.java:539)
	at com.solarmetric.kodo.runtime.PersistenceManagerImpl.commit(PersistenceManagerImpl.java:393)
	at net.nearlythere.business.BaseBusiness.end(BaseBusiness.java:247)
	at net.nearlythere.business.BaseBusiness.finalize(BaseBusiness.java:259)
	at net.nearlythere.frontend.servlets.ChatAPI.memberEndSession(ChatAPI.java:345)
	at net.nearlythere.frontend.servlets.ChatAPI.doPost(ChatAPI.java:125)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.