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)