Jboss+Oracle Unable to obtain lock in 60 seconds

Question

1.启了两个线程，select查询语句访问数据库报无法获取锁，求解决方案。

2.java.lang.reflect.UndeclaredThrowableException

    at com.sun.proxy.$Proxy2483.selectRrcMparmList(Unknown Source)
    at com.murong.ecp.app.rrc.service.RskGradeRatingService.gradeRating(RskGradeRatingService.java:78)
    at com.murong.ecp.app.rrc.action.RskGradeThread.run(RskGradeThread.java:51)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)

Nested Exception:

215016:215016-查询出错, ErrorCode:[0], SQLState:[null]

       com.yuangou.ecp.bp.database.YGJDBCProvider.execQueryBindLimit(YGJDBCProvider.java:132)
       com.yuangou.ecp.bp.database.YGDatabaseUtil.execQueryBindLimit(YGDatabaseUtil.java:110)
       com.yuangou.ecp.biz.transengine.sqlsession.YGSqlSession.selectList(YGSqlSession.java:281)
       com.yuangou.ecp.biz.transengine.sqlsession.YGSqlSession.selectList(YGSqlSession.java:194)
       com.yuangou.ecp.biz.transengine.sqlsession.MapperProxy.invoke(MapperProxy.java:69)
       com.sun.proxy.$Proxy2483.selectRrcMparmList(Unknown Source)
       com.murong.ecp.app.rrc.service.RskGradeRatingService.gradeRating(RskGradeRatingService.java:78)
       com.murong.ecp.app.rrc.action.RskGradeThread.run(RskGradeThread.java:51)
       java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
       java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
       java.lang.Thread.run(Thread.java:745)

Nested Exception:

java.sql.SQLException: Unable to obtain lock in 60 seconds: org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@8176821

       org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.tryLock(BaseWrapperManagedConnection.java:267)
       org.jboss.resource.adapter.jdbc.WrappedConnection.lock(WrappedConnection.java:79)
       org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:237)
       com.yuangou.ecp.bp.database.YGJDBCProvider.execQueryBindLimit(YGJDBCProvider.java:82)
       com.yuangou.ecp.bp.database.YGDatabaseUtil.execQueryBindLimit(YGDatabaseUtil.java:110)
       com.yuangou.ecp.biz.transengine.sqlsession.YGSqlSession.selectList(YGSqlSession.java:281)
       com.yuangou.ecp.biz.transengine.sqlsession.YGSqlSession.selectList(YGSqlSession.java:194)
       com.yuangou.ecp.biz.transengine.sqlsession.MapperProxy.invoke(MapperProxy.java:69)
       com.sun.proxy.$Proxy2483.selectRrcMparmList(Unknown Source)
       com.murong.ecp.app.rrc.service.RskGradeRatingService.gradeRating(RskGradeRatingService.java:78)
       com.murong.ecp.app.rrc.action.RskGradeThread.run(RskGradeThread.java:51)
       java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
       java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
       java.lang.Thread.run(Thread.java:745)

Answer 1

这个问题看起来像是在并发场景下出现的数据库锁竞争问题。建议您对数据库的表或索引进行优化以避免锁竞争。另外，您也可以尝试使用数据库连接池或缓存来减少对数据库的访问，从而减少锁竞争的可能性。此外，也需要检查代码实现，确保在并发场景中正确并且高效地使用数据库连接。至于 UndeclaredThrowableException，这个异常通常是由于在使用 Java 反射时出现的异常。建议您检查代码并确保反射调用时安全的。