Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.1

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using: mysql

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

After upgrading to 3.1 I get some strange errors

org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:318)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:109)
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:224)
at org.hibernate.loader.Loader.loadCollection(Loader.java:1919)
at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:71)
at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:520)
at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)
at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1627)
at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:344)
at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:86)
at org.hibernate.collection.PersistentSet.iterator(PersistentSet.java:138)
at com.tietoenator.dk.lub.business.maintenance.ProgramBusiness.findProgramStartDate(ProgramBusiness.java:1678)
at com.tietoenator.dk.lub.business.maintenance.ProgramBusiness.getActiveProgramBean(ProgramBusiness.java:995)
at com.tietoenator.dk.lub.business.maintenance.ProgramBusiness.getActiveProgram(ProgramBusiness.java:1025)
at com.tietoenator.dk.lub.business.maintenance.ProgramBusiness.getFormerProgramOverviewList(ProgramBusiness.java:1521)
at com.tietoenator.dk.lub.session.maintenance.ProgramSession.getFormerProgramOverviewList(ProgramSession.java:181)
at com.tietoenator.dk.lub.delegate.maintenance.ProgramDelegate.getFormerProgramOverviewList(ProgramDelegate.java:78)
at com.tietoenator.dk.lub.presentation.web.registration.ProgramOverviewAction.doShow(ProgramOverviewAction.java:239)
at com.tietoenator.dk.lub.presentation.web.basic.BaseAction.execute(BaseAction.java:206)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:696)
at com.tietoenator.dk.lub.presentation.web.controller.ControllerServlet.service(ControllerServlet.java:388)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:127)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted, cause: Timeout waiting for idle object
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:148)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)
at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:69)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:315)
... 57 more
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:801)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:140)
... 60 more
17 jan 2006 10:51:32,491 ERROR com.tietoenator.dk.lub.presentation.web.controller.ControllerServlet - Could not write response time to table REQUEST_LOG in the databse
org.hibernate.exception.GenericJDBCException: Cannot open user connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.JDBCContext.userConnection(JDBCContext.java:120)
at org.hibernate.impl.SessionImpl.connection(SessionImpl.java:373)
at com.tietoenator.dk.lub.presentation.web.controller.ControllerServlet.logRequest(ControllerServlet.java:146)
at com.tietoenator.dk.lub.presentation.web.controller.ControllerServlet.stopTimerAndLog(ControllerServlet.java:308)
at com.tietoenator.dk.lub.presentation.web.controller.ControllerServlet.service(ControllerServlet.java:396)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:127)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted, cause: Timeout waiting for idle object
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:148)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)
at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:69)
at org.hibernate.jdbc.JDBCContext.userConnection(JDBCContext.java:117)
... 34 more
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:801)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:140)
... 37 more


ControllerServlet.java:146 = con = session.connection();

ProgramBusiness.java:1678 = for (Iterator programItemIterator = programItems.iterator(); programItemIterator.hasNext();) {

with version 3.0.5 it works fine.....

did you read this:

http://www.hibernate.org/250.html#A26

well, now I have...

After updating my code to close the connection manually i don't get the org.hibernate.exception.GenericJDBCException: Cannot open connection

But I still get an exception on the last line of this code segment :

competenceQuery = session.createQuery(SQLQueries.SQL_COMPETENCES_READY_FOR_APPROVAL_FOR_SUB_ORG_UNITS);
competenceQuery.setParameter("userId", user.getId().toString());
competenceQuery.setParameter("completedAtOrgUnit", callContext.getAuthorization().getOrganisationUnit().getId());
Iterator competenceApprovalIterator = competenceQuery.list().iterator();

The query is :

select
programStatusBean.id,
competenceBean.shortName,
programItemBean.id,
specialtyBean.name,
programItemProgramStatusBean.relationType.relType,
competenceBean.isObsolete
from
com.tietoenator.dk.lub.integration.registration.ProgramStatusBean programStatusBean,
com.tietoenator.dk.lub.integration.maintenance.program.ProgramItemProgramStatusBean programItemProgramStatusBean,
com.tietoenator.dk.lub.integration.maintenance.competence.CompetenceBean competenceBean,
com.tietoenator.dk.lub.integration.maintenance.program.ProgramItemBean programItemBean,
com.tietoenator.dk.lub.integration.maintenance.program.ProgramBean programBean,
com.tietoenator.dk.lub.integration.maintenance.specialty.GoalDescriptionBean goalDescriptionBean,
com.tietoenator.dk.lub.integration.maintenance.specialty.SpecialtyBean specialtyBean
where
programStatusBean.id = programItemProgramStatusBean.programStatus.id and
competenceBean.id = programStatusBean.competence.id and
programItemBean.id = programItemProgramStatusBean.programItem.id and
programItemBean.program.id = programBean.id and
specialtyBean.id = goalDescriptionBean.specialty.id and
goalDescriptionBean.id = programBean.goalDescription.id and
programStatusBean.completedAt is not null and
programStatusBean.approvedAt is null and
programStatusBean.completedAtPrgItem.id = programItemBean.id and
programItemBean.organisationUnit
in
(
select orgUnitOrgUnitBean.organisationUnitChild.id
from
com.tietoenator.dk.lub.integration.basic.organisationunit.OrgUnitOrgUnitBean orgUnitOrgUnitBean
where
orgUnitOrgUnitBean.organisationUnitParent.id = :completedAtOrgUnit
)
and
programBean.isDeleted = 0 and
programBean.user.id = :userId;

And the exception I get is :

org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2153)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:300)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:146)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1093)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at com.tietoenator.dk.lub.business.registration.ApprovalBusiness.getApprovalItems(ApprovalBusiness.java:68)
at com.tietoenator.dk.lub.session.registration.ApprovalSession.getApprovalItems(ApprovalSession.java:24)
at com.tietoenator.dk.lub.delegate.registration.ApprovalDelegate.getApprovalItems(ApprovalDelegate.java:18)
at com.tietoenator.dk.lub.presentation.web.registration.approval.ApprovalAction.doShow(ApprovalAction.java:85)
at com.tietoenator.dk.lub.presentation.web.basic.BaseAction.execute(BaseAction.java:206)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:696)
at com.tietoenator.dk.lub.presentation.web.controller.ControllerServlet.service(ControllerServlet.java:388)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:127)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: Statement parameter 2 not set.
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1267)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:957)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1657)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:205)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2150)
... 48 more

With 3.1 the generated sql is :

select
programsta0_.ID as col_0_0_,
competence2_.SHORTNAME as col_1_0_,
programite3_.ID as col_2_0_,
specialtyb6_.NAME as col_3_0_,
relationty7_.RELATION_TYPE as col_4_0_,
competence2_.IS_OBSOLETE as col_5_0_
from
PROGRAM_STATUS programsta0_,
PROGRAM_ITEM_PROGRAM_STATUS programite1_,
RELATION_TYPE relationty7_,
COMPETENCE competence2_,
PROGRAM_ITEM programite3_,
PROGRAM programbea4_,
GOAL_DESCRIPTION goaldescri5_,
SPECIALTY specialtyb6_
where
programite1_.RELATION_TYPE_ID=relationty7_.ID and
programsta0_.ID=programite1_.PROGRAM_STATUS_ID and
competence2_.ID=programsta0_.COMPETENCE_ID and
programite3_.ID=programite1_.PROGRAM_ITEM_ID and
programite3_.PROGRAM_ID=programbea4_.ID and
specialtyb6_.ID=goaldescri5_.SPECIALTY_ID and
goaldescri5_.ID=programbea4_.GOAL_DESCRIPTION_ID and
(programsta0_.COMPLETED_AT is not null) and
(programsta0_.APPROVED_AT is null) and
programsta0_.COMPLETED_AT_PROGRAM_ITEM_ID=programite3_.ID and
programite3_.ORGANISATION_UNIT_ID=null and
programite1_.RELATION_TYPE_ID<>3 and
programbea4_.IS_DELETED=0 and
programbea4_.USER_ID=null

this is the bad part...

programite3_.ORGANISATION_UNIT_ID=null
programbea4_.USER_ID=null

instead of :

competenceQuery.setParameter("userId", user.getId().toString());
competenceQuery.setParameter("completedAtOrgUnit", callContext.getAuthorization().getOrganisationUnit().getId());

do this

competenceQuery.setString("userId", user.getId().toString());
competenceQuery.setString("completedAtOrgUnit", callContext.getAuthorization().getOrganisationUnit().getId().toString());

or

competenceQuery.setLong("userId", user.getId());
competenceQuery.setLong("completedAtOrgUnit", callContext.getAuthorization().getOrganisationUnit().getId());