数据库被死锁org.hibernate.exception.LockAcquisitionException: Cannot open connection

来源:互联网 发布:40岁程序员干不了 编辑:程序博客网 时间:2024/06/06 17:33
项目启动没有问题,项目在登录进行用户名密码验证的时候报的错,数据库被死锁了,无法打开连接,请问什么原因造成的?求大神解答一下org.hibernate.exception.LockAcquisitionException: Cannot open connectionat org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:110)at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1577)at org.hibernate.loader.Loader.doQuery(Loader.java:696)at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)at org.hibernate.loader.Loader.doList(Loader.java:2232)at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)at org.hibernate.loader.Loader.list(Loader.java:2124)at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149)at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:835)at cn.jbit.auction.daoimp.AuctionuserDAOImp.login(AuctionuserDAOImp.java:191)at cn.jbit.auction.web.LoginServlet.doPost(LoginServlet.java:39)at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:957)at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620)at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2476)at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2465)at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)at java.lang.Thread.run(Thread.java:745)Caused by: java.sql.SQLException: The Network Adapter could not establish the connectionat oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)at java.sql.DriverManager.getConnection(DriverManager.java:664)at java.sql.DriverManager.getConnection(DriverManager.java:208)at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)... 39 moreCaused by: oracle.net.ns.NetException: The Network Adapter could not establish the connectionat oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:359)at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:422)at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:672)at oracle.net.ns.NSProtocol.connect(NSProtocol.java:237)at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)... 47 moreCaused by: java.net.ConnectException: Connection refused: connectat java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)at java.net.Socket.connect(Socket.java:589)at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:141)at oracle.net.nt.ConnOption.connect(ConnOption.java:123)at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:337)... 52 more

0 0
原创粉丝点击