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

[Steve Ebersole (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1040?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Ebersole closed HHH-1040.
-------------------------------


Closing stale resolved issues

> 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)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira