hibernate - Tomcat connection pool fails, but nothing in log -


my java application running on tomcat 6 has problem caused following exception. uses hibernate , tomcat connection pooling. read problem connection pool, not database itself. right?

to debug problem, configured jdbc connection this:

<resource             name="jdbc/mssqlrepositorycfl"             auth="container"             type="javax.sql.datasource"             maxactive="50"             maxidle="5"             maxwait="10000"             username="updatecfl"             password=""             validationquery="select 1"             defaulttransactionisolation="read_committed"             testonborrow="true"     removeabandoned="true"     removeabandonedtimeout="60"     logabandoned="true"             driverclassname="net.sourceforge.jtds.jdbc.driver"             url="jdbc:jtds:sqlserver://some.server.cz:1433/repositorycfl"     /> 

but tomcat log remains empty, while following errors keep happening , bringing application down. idea may doing wrong?

    javax.servlet.error.exception: org.springframework.transaction.cannotcreatetransactionexception: not open hibernate session transaction; nested exception net.sf.hibernate.exception.genericjdbcexception: cannot open connection -------------------------- parameters -------------------------- caused by: org.springframework.transaction.cannotcreatetransactionexception: not open hibernate session transaction; nested exception net.sf.hibernate.exception.genericjdbcexception: cannot open connection @ org.springframework.orm.hibernate.hibernatetransactionmanager.dobegin(hibernatetransactionmanager.java:473) caused by: net.sf.hibernate.exception.genericjdbcexception: cannot open connection @ net.sf.hibernate.exception.sqlstateconverter.handlednonspecificexception(sqlstateconverter.java:80) caused by: org.apache.tomcat.dbcp.dbcp.sqlnestedexception: cannot connection, pool error timeout waiting idle object @ org.apache.tomcat.dbcp.dbcp.poolingdatasource.getconnection(poolingdatasource.java:114) caused by: java.util.nosuchelementexception: timeout waiting idle object @ org.apache.tomcat.dbcp.pool.impl.genericobjectpool.borrowobject(genericobjectpool.java:1134)  2013-07-11 10:24:10,461 error [http-443-97] [sf.hibernate.util.jdbcexceptionreporter] logexceptions cannot connection, pool error timeout waiting idle object -- url: /homepage.action | username: anonymous 2013-07-11 10:24:10,461 error [http-443-97] [atlassian.confluence.servlet.confluenceservletdispatcher] senderror not execute action -- url: /homepage.action | username: anonymous org.springframework.transaction.cannotcreatetransactionexception: not open hibernate session transaction; nested exception net.sf.hibernate.exception.genericjdbcexception: cannot open connection caused by: net.sf.hibernate.exception.genericjdbcexception: cannot open connection @ net.sf.hibernate.exception.sqlstateconverter.handlednonspecificexception(sqlstateconverter.java:80) @ net.sf.hibernate.exception.sqlstateconverter.convert(sqlstateconverter.java:69) @ net.sf.hibernate.exception.jdbcexceptionhelper.convert(jdbcexceptionhelper.java:29) @ net.sf.hibernate.impl.batcherimpl.convert(batcherimpl.java:328) @ net.sf.hibernate.impl.batcherimpl.openconnection(batcherimpl.java:295) @ net.sf.hibernate.impl.sessionimpl.connect(sessionimpl.java:3371) @ net.sf.hibernate.impl.sessionimpl.connection(sessionimpl.java:3331) @ org.springframework.orm.hibernate.hibernatetransactionmanager.dobegin(hibernatetransactionmanager.java:422) @ org.springframework.transaction.support.abstractplatformtransactionmanager.gettransaction(abstractplatformtransactionmanager.java:350) @ com.atlassian.xwork.interceptors.transactionalinvocation.getnewtransaction(transactionalinvocation.java:141) @ com.atlassian.xwork.interceptors.transactionalinvocation.invokeintransaction(transactionalinvocation.java:40) @ com.atlassian.xwork.interceptors.xworktransactioninterceptor.intercept(xworktransactioninterceptor.java:56) @ com.opensymphony.xwork.defaultactioninvocation.invoke(defaultactioninvocation.java:165) @ com.atlassian.confluence.xwork.setupincompleteinterceptor.intercept(setupincompleteinterceptor.java:40) @ com.opensymphony.xwork.defaultactioninvocation.invoke(defaultactioninvocation.java:165) @ com.opensymphony.xwork.interceptor.aroundinterceptor.intercept(aroundinterceptor.java:35) @ com.opensymphony.xwork.defaultactioninvocation.invoke(defaultactioninvocation.java:165) @ com.opensymphony.xwork.defaultactionproxy.execute(defaultactionproxy.java:115) @ com.atlassian.confluence.servlet.confluenceservletdispatcher.serviceaction(confluenceservletdispatcher.java:53) @ com.opensymphony.webwork.dispatcher.servletdispatcher.service(servletdispatcher.java:199) @ javax.servlet.http.httpservlet.service(httpservlet.java:717) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:290) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.plugin.servlet.filter.iteratingfilterchain.dofilter(iteratingfilterchain.java:46) @ com.atlassian.plugin.servlet.filter.delegatingpluginfilter$1.dofilter(delegatingpluginfilter.java:66) @ com.atlassian.applinks.core.rest.context.contextfilter.dofilter(contextfilter.java:25) @ com.atlassian.plugin.servlet.filter.delegatingpluginfilter.dofilter(delegatingpluginfilter.java:74) @ com.atlassian.plugin.servlet.filter.iteratingfilterchain.dofilter(iteratingfilterchain.java:42) @ com.atlassian.plugin.servlet.filter.servletfiltermodulecontainerfilter.dofilter(servletfiltermodulecontainerfilter.java:77) @ com.atlassian.plugin.servlet.filter.servletfiltermodulecontainerfilter.dofilter(servletfiltermodulecontainerfilter.java:63) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.confluence.security.websudo.messagesdecoratorfilter.dofilter(messagesdecoratorfilter.java:49) @ com.atlassian.core.filters.abstracthttpfilter.dofilter(abstracthttpfilter.java:31) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.opensymphony.module.sitemesh.filter.pagefilter.parsepage(pagefilter.java:118) @ com.atlassian.confluence.util.profiling.profilingpagefilter.parsepage(profilingpagefilter.java:84) @ com.opensymphony.module.sitemesh.filter.pagefilter.dofilter(pagefilter.java:54) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.plugin.servlet.filter.iteratingfilterchain.dofilter(iteratingfilterchain.java:46) @ com.atlassian.plugin.servlet.filter.servletfiltermodulecontainerfilter.dofilter(servletfiltermodulecontainerfilter.java:77) @ com.atlassian.plugin.servlet.filter.servletfiltermodulecontainerfilter.dofilter(servletfiltermodulecontainerfilter.java:63) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.confluence.jmx.jmxfilter.dofilter(jmxfilter.java:106) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.core.filters.servletcontextthreadlocalfilter.dofilter(servletcontextthreadlocalfilter.java:19) @ com.atlassian.core.filters.abstracthttpfilter.dofilter(abstracthttpfilter.java:31) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.confluence.util.loggingcontextfilter.dofilter(loggingcontextfilter.java:40) @ com.atlassian.core.filters.abstracthttpfilter.dofilter(abstracthttpfilter.java:31) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.confluence.web.filter.threadlocalcachefilter.dofilter(threadlocalcachefilter.java:22) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.confluence.util.userthreadlocalfilter.dofilter(userthreadlocalfilter.java:44) @ com.atlassian.core.filters.abstracthttpfilter.dofilter(abstracthttpfilter.java:31) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.seraph.filter.securityfilter.dofilter(securityfilter.java:211) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.security.auth.trustedapps.filter.trustedapplicationsfilter.dofilter(trustedapplicationsfilter.java:98) @ com.atlassian.confluence.util.abstractbootstraphotswappingfilter.dofilter(abstractbootstraphotswappingfilter.java:30) @ com.atlassian.core.filters.abstracthttpfilter.dofilter(abstracthttpfilter.java:31) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.seraph.filter.baseloginfilter.dofilter(baseloginfilter.java:150) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.plugin.servlet.filter.iteratingfilterchain.dofilter(iteratingfilterchain.java:46) @ com.atlassian.plugin.servlet.filter.delegatingpluginfilter$1.dofilter(delegatingpluginfilter.java:66) @ com.atlassian.oauth.serviceprovider.internal.servlet.oauthfilter.dofilter(oauthfilter.java:71) @ com.atlassian.plugin.servlet.filter.delegatingpluginfilter.dofilter(delegatingpluginfilter.java:74) @ com.atlassian.plugin.servlet.filter.iteratingfilterchain.dofilter(iteratingfilterchain.java:42) @ com.atlassian.plugin.servlet.filter.servletfiltermodulecontainerfilter.dofilter(servletfiltermodulecontainerfilter.java:77) @ com.atlassian.plugin.servlet.filter.servletfiltermodulecontainerfilter.dofilter(servletfiltermodulecontainerfilter.java:63) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.confluence.util.clusterheaderfilter.dofilter(clusterheaderfilter.java:34) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.johnson.filters.abstractjohnsonfilter.dofilter(abstractjohnsonfilter.java:72) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ org.springframework.orm.hibernate.support.opensessioninviewfilter.dofilterinternal(opensessioninviewfilter.java:170) @ com.atlassian.spring.filter.flushingspringsessioninviewfilter.dofilterinternal(flushingspringsessioninviewfilter.java:29) @ org.springframework.web.filter.onceperrequestfilter.dofilter(onceperrequestfilter.java:75) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.confluence.util.confluenceerrorfilter.dofilter(confluenceerrorfilter.java:22) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.util.profiling.filters.profilingfilter.dofilter(profilingfilter.java:99) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.confluence.core.datetime.requesttimethreadlocalfilter.dofilter(requesttimethreadlocalfilter.java:35) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.gzipfilter.gzipfilter.dofilterinternal(gzipfilter.java:80) @ com.atlassian.gzipfilter.gzipfilter.dofilter(gzipfilter.java:51) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.core.filters.cache.abstractcachingfilter.dofilter(abstractcachingfilter.java:33) @ com.atlassian.core.filters.abstracthttpfilter.dofilter(abstracthttpfilter.java:31) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.plugin.servlet.filter.iteratingfilterchain.dofilter(iteratingfilterchain.java:46) @ com.atlassian.plugin.servlet.filter.delegatingpluginfilter$1.dofilter(delegatingpluginfilter.java:66) @ com.atlassian.confluence.extra.webdav.servlet.filter.reverseproxyfilter.dofilter(reverseproxyfilter.java:427) @ com.atlassian.confluence.extra.webdav.servlet.filter.abstracthttpfilter.dofilter(abstracthttpfilter.java:34) @ com.atlassian.plugin.servlet.filter.delegatingpluginfilter.dofilter(delegatingpluginfilter.java:74) @ com.atlassian.plugin.servlet.filter.iteratingfilterchain.dofilter(iteratingfilterchain.java:42) @ com.atlassian.plugin.servlet.filter.servletfiltermodulecontainerfilter.dofilter(servletfiltermodulecontainerfilter.java:77) @ com.atlassian.plugin.servlet.filter.servletfiltermodulecontainerfilter.dofilter(servletfiltermodulecontainerfilter.java:63) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.confluence.web.filter.validateparam.requestparamvalidationfilter.dofilter(requestparamvalidationfilter.java:58) @ com.atlassian.core.filters.abstracthttpfilter.dofilter(abstracthttpfilter.java:31) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.confluence.plugin.servlet.filter.actioncontextcleanup.dofilter(actioncontextcleanup.java:71) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.confluence.web.filter.languageextractionfilter.dofilter(languageextractionfilter.java:52) @ com.atlassian.core.filters.abstracthttpfilter.dofilter(abstracthttpfilter.java:31) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.confluence.util.requestcachethreadlocalfilter.dofilter(requestcachethreadlocalfilter.java:25) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.core.filters.encoding.abstractencodingfilter.dofilter(abstractencodingfilter.java:41) @ com.atlassian.core.filters.abstracthttpfilter.dofilter(abstracthttpfilter.java:31) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.core.filters.headersanitisingfilter.dofilter(headersanitisingfilter.java:44) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ com.atlassian.confluence.servlet.fourohfourerrorloggingfilter.dofilter(fourohfourerrorloggingfilter.java:65) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) @ org.apache.catalina.core.standardwrappervalve.invoke(standardwrappervalve.java:233) @ org.apache.catalina.core.standardcontextvalve.invoke(standardcontextvalve.java:191) @ org.apache.catalina.authenticator.authenticatorbase.invoke(authenticatorbase.java:563) @ org.apache.catalina.authenticator.authenticatorbase.invoke(authenticatorbase.java:563) @ org.apache.catalina.core.standardhostvalve.invoke(standardhostvalve.java:127) @ org.apache.catalina.valves.errorreportvalve.invoke(errorreportvalve.java:102) @ org.apache.catalina.core.standardenginevalve.invoke(standardenginevalve.java:109) @ org.apache.catalina.connector.coyoteadapter.service(coyoteadapter.java:298) @ org.apache.coyote.http11.http11processor.process(http11processor.java:857) @ org.apache.coyote.http11.http11protocol$http11connectionhandler.process(http11protocol.java:588) @ org.apache.tomcat.util.net.jioendpoint$worker.run(jioendpoint.java:489) @ java.lang.thread.run(thread.java:619) caused by: org.apache.tomcat.dbcp.dbcp.sqlnestedexception: cannot connection, pool error timeout waiting idle object @ org.apache.tomcat.dbcp.dbcp.poolingdatasource.getconnection(poolingdatasource.java:114) @ org.apache.tomcat.dbcp.dbcp.basicdatasource.getconnection(basicdatasource.java:1044) @ net.sf.hibernate.connection.datasourceconnectionprovider.getconnection(datasourceconnectionprovider.java:59) @ net.sf.hibernate.impl.batcherimpl.openconnection(batcherimpl.java:292) ... 153 more caused by: java.util.nosuchelementexception: timeout waiting idle object @ org.apache.tomcat.dbcp.pool.impl.genericobjectpool.borrowobject(genericobjectpool.java:1134) @ org.apache.tomcat.dbcp.dbcp.abandonedobjectpool.borrowobject(abandonedobjectpool.java:79) @ org.apache.tomcat.dbcp.dbcp.poolingdatasource.getconnection(poolingdatasource.java:106) ... 156 more 2013-07-11 10:24:10,461 info [http-443-97] [atlassian.confluence.status.systemerrorinformationlogger] writetolog request unique id : 6bac0bf5-6c87-44d2-8060-9c1b7f005023 

from see be:

  1. the database server down
  2. database server there network problem causing application not being able contact database server (cable disconnected, firewall, etc.)

Comments

Popular posts from this blog

html5 - What is breaking my page when printing? -

c# - must be a non-abstract type with a public parameterless constructor in redis -

ajax - PHP/JSON Login script (Twitter style) not setting sessions -