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

Oracle Community | 3004 | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Deadlock Exception

    Oracle Community | 1 decade ago | 3004
    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

    Root Cause Analysis

    1. 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()
    2. com.solarmetric.kodo
      PersistenceManagerImpl.commit
      1. com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.update(JDBCStoreManager.java:352)
      2. com.solarmetric.kodo.runtime.StateManagerImpl.storeFields(StateManagerImpl.java:1808)
      3. com.solarmetric.kodo.runtime.PDirtyState.flush(PDirtyState.java:37)
      4. com.solarmetric.kodo.runtime.StateManagerImpl.flush(StateManagerImpl.java:480)
      5. com.solarmetric.kodo.runtime.PersistenceManagerImpl.flush(PersistenceManagerImpl.java:539)
      6. com.solarmetric.kodo.runtime.PersistenceManagerImpl.commit(PersistenceManagerImpl.java:393)
      6 frames
    3. net.nearlythere.business
      BaseBusiness.finalize
      1. net.nearlythere.business.BaseBusiness.end(BaseBusiness.java:247)
      2. net.nearlythere.business.BaseBusiness.finalize(BaseBusiness.java:259)
      2 frames
    4. net.nearlythere.frontend
      ChatAPI.doPost
      1. net.nearlythere.frontend.servlets.ChatAPI.memberEndSession(ChatAPI.java:345)
      2. net.nearlythere.frontend.servlets.ChatAPI.doPost(ChatAPI.java:125)
      2 frames
    5. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
      1 frame