[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-1040) Error in Hibernate3.1: Not able to obtain connection

Error in Hibernate3.1: Not able to obtain connection ---------------------------------------------------- Key: HHH-1040 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1040 Project: Hibernate Core Issue Type: Bug Affects Versions: 3.1 rc 1 Environment: 3.1, postgres Reporter: Harsha Pherwani HI I am geting the following errror when executing a select hql in 3.1 version (see below). However I don't get this error when I use the 3.1beta3 version (hibernate-3.1beta3.tar.gz). The scenario is I am undating a table and then reading from the table. I have used transaction while updating the table and have committed properly. We need to use the 3.1 version because we are using the 'WITH' clause in query for left outer joins which is not supported in the versions below 3.1. org.hibernate.HibernateException: at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:117) at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105) at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561) at org.hibernate.loader.Loader.doQuery(Loader.java:661) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:223) at org.hibernate.loader.Loader.doList(Loader.java:2147) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2026) at org.hibernate.loader.Loader.list(Loader.java:2021) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1455) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:298) at org.hibernate.impl.CriteriaImpl$Subcriteria.list(CriteriaImpl.java:143) at com.icrossing.icfeedsR3.model.scheduler.SchedulerModel.getExportConnectionForClient(SchedulerModel.java:116) at com.icrossing.icfeedsR3.operation.ClientServicesOperation.loadClientServices(ClientServicesOperation.java:93) at com.icrossing.icfeedsR3.operation.ClientServicesOperation.perform(ClientServicesOperation.java:60) at com.icrossing.framework.web.operation.OpCodeProcessor.processOperation(Unknown Source) at com.icrossing.framework.web.servlet.ControllerServlet.processRequest(Unknown Source) at com.icrossing.framework.web.servlet.ControllerServlet.doPost(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.icrossing.icfeedsR3.filters.SessionFilter.doFilter(SessionFilter.java:48) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)