<!-- Er is een fout opgetreden! org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; --- The error occurred in be/persgroep/prj/pe/core/dao/ibatis/maps/sqlMapNavigationItem.xml. --- The error occurred while executing query. --- Check the SELECT NAV.ID, NAV.PARENT_ID, NAV.PUBLICATION_ID, NAV.NAVIGATION_KEY, NAV.TEASER_ANCHOR_TYPE_ID, LOC.REMARKS, NAV.POSITION, NAV.TYPE_ID, LOC.LOCALE, LOC.DESCRIPTION, NAVIGATION_LEVEL, NAV.VISIBLE, NAV.CONFIG, NAV.OPERATOR, NAV.MAX_TEASER FROM ( SELECT SUB_NAV.ID, SUB_NAV.PARENT_ID, SUB_NAV.PUBLICATION_ID, SUB_NAV.NAVIGATION_KEY, SUB_NAV.TEASER_ANCHOR_TYPE_ID, LEVEL AS NAVIGATION_LEVEL, SUB_NAV.POSITION, SUB_NAV.TYPE_ID, SUB_NAV.VISIBLE, SUB_NAV.CONFIG, SUB_NAV.OPERATOR, SUB_NAV.MAX_TEASER FROM PE_NAVIGATION_ITEMS SUB_NAV START WITH SUB_NAV.ID = ? CONNECT BY PRIOR SUB_NAV.ID = SUB_NAV.PARENT_ID ) NAV, PE_NAVIGATION_ITEMS_LOCALIZED LOC WHERE NAV.ID = LOC.NAVIGATION_ITEM_ID AND LOC.LOCALE = 'nl_BE' ORDER BY NAVIGATION_LEVEL ASC . --- Check the SQL Statement (preparation failed). --- Cause: java.sql.SQLException: Unable to get a physical connection from the database...there are no connections available.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in be/persgroep/prj/pe/core/dao/ibatis/maps/sqlMapNavigationItem.xml. --- The error occurred while executing query. --- Check the SELECT NAV.ID, NAV.PARENT_ID, NAV.PUBLICATION_ID, NAV.NAVIGATION_KEY, NAV.TEASER_ANCHOR_TYPE_ID, LOC.REMARKS, NAV.POSITION, NAV.TYPE_ID, LOC.LOCALE, LOC.DESCRIPTION, NAVIGATION_LEVEL, NAV.VISIBLE, NAV.CONFIG, NAV.OPERATOR, NAV.MAX_TEASER FROM ( SELECT SUB_NAV.ID, SUB_NAV.PARENT_ID, SUB_NAV.PUBLICATION_ID, SUB_NAV.NAVIGATION_KEY, SUB_NAV.TEASER_ANCHOR_TYPE_ID, LEVEL AS NAVIGATION_LEVEL, SUB_NAV.POSITION, SUB_NAV.TYPE_ID, SUB_NAV.VISIBLE, SUB_NAV.CONFIG, SUB_NAV.OPERATOR, SUB_NAV.MAX_TEASER FROM PE_NAVIGATION_ITEMS SUB_NAV START WITH SUB_NAV.ID = ? CONNECT BY PRIOR SUB_NAV.ID = SUB_NAV.PARENT_ID ) NAV, PE_NAVIGATION_ITEMS_LOCALIZED LOC WHERE NAV.ID = LOC.NAVIGATION_ITEM_ID AND LOC.LOCALE = 'nl_BE' ORDER BY NAVIGATION_LEVEL ASC . --- Check the SQL Statement (preparation failed). --- Cause: java.sql.SQLException: Unable to get a physical connection from the database...there are no connections available. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212) at org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:249) at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:296) at be.persgroep.prj.pe.core.dao.ibatis.NavigationItemDao.selectNavigationItemTree(NavigationItemDao.java:114) at be.persgroep.prj.pe.core.manager.NavigationItemManager.loadNavigationItemTree(NavigationItemManager.java:144) at sun.reflect.GeneratedMethodAccessor418.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77) at be.persgroep.prj.pe.support.cache.advice.AbstractCacheAdvice.cache(AbstractCacheAdvice.java:36) at sun.reflect.GeneratedMethodAccessor86.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy24.loadNavigationItemTree(Unknown Source) at be.persgroep.prj.pe.core.service.NavigationItemService.loadNavigationItemTree(NavigationItemService.java:98) at sun.reflect.GeneratedMethodAccessor337.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy33.loadNavigationItemTree(Unknown Source) at be.persgroep.prj.pes.base.web.site.navigation.spring.interceptor.NavigationItemTreeInterceptor.preHandle(NavigationItemTreeInterceptor.java:55) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:884) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:822) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501) at javax.servlet.http.HttpServlet.service(HttpServlet.java:743) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:719) at com.evermind.server.http.ServletRequestDispatcher.unprivileged_include(ServletRequestDispatcher.java:171) at com.evermind.server.http.ServletRequestDispatcher.access$000(ServletRequestDispatcher.java:42) at com.evermind.server.http.ServletRequestDispatcher$1.oc4jRun(ServletRequestDispatcher.java:108) at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283) at com.evermind.server.http.ServletRequestDispatcher.include(ServletRequestDispatcher.java:113) at com.evermind.server.http.EvermindPageContext.include(EvermindPageContext.java:383) at org.apache.tiles.jsp.context.JspTilesRequestContext.include(JspTilesRequestContext.java:80) at org.apache.tiles.jsp.context.JspTilesRequestContext.dispatch(JspTilesRequestContext.java:73) at org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:678) at org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:634) at org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:307) at org.apache.tiles.renderer.impl.UntypedAttributeRenderer.write(UntypedAttributeRenderer.java:59) at org.apache.tiles.renderer.impl.AbstractBaseAttributeRenderer.render(AbstractBaseAttributeRenderer.java:107) at org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:324) at org.apache.tiles.jsp.taglib.InsertAttributeTag.render(InsertAttributeTag.java:153) at org.apache.tiles.jsp.taglib.InsertAttributeTag.render(InsertAttributeTag.java:120) at org.apache.tiles.jsp.taglib.RenderTagSupport.doEndTag(RenderTagSupport.java:200) at _web_2d_inf._jsp._default._layout._bottom._jspService(_bottom.java:206) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:416) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:719) at com.evermind.server.http.ServletRequestDispatcher.unprivileged_include(ServletRequestDispatcher.java:171) at com.evermind.server.http.ServletRequestDispatcher.access$000(ServletRequestDispatcher.java:42) at com.evermind.server.http.ServletRequestDispatcher$1.oc4jRun(ServletRequestDispatcher.java:108) at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283) at com.evermind.server.http.ServletRequestDispatcher.include(ServletRequestDispatcher.java:113) at org.apache.tiles.servlet.context.ServletTilesRequestContext.include(ServletTilesRequestContext.java:217) at org.apache.tiles.servlet.context.ServletTilesRequestContext.dispatch(ServletTilesRequestContext.java:177) at org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:678) at org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:634) at org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:307) at be.persgroep.prj.pes.base.web.site.support.spring.view.PeTilesJstlView.renderMergedOutputModel(PeTilesJstlView.java:136) at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:257) at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1179) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:920) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:822) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501) at javax.servlet.http.HttpServlet.service(HttpServlet.java:743) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:719) at com.evermind.server.http.ServletRequestDispatcher.unprivileged_include(ServletRequestDispatcher.java:171) at com.evermind.server.http.ServletRequestDispatcher.access$000(ServletRequestDispatcher.java:42) at com.evermind.server.http.ServletRequestDispatcher$1.oc4jRun(ServletRequestDispatcher.java:108) at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283) at com.evermind.server.http.ServletRequestDispatcher.include(ServletRequestDispatcher.java:113) at com.evermind.server.http.EvermindPageContext.include(EvermindPageContext.java:383) at org.apache.tiles.jsp.context.JspTilesRequestContext.include(JspTilesRequestContext.java:80) at org.apache.tiles.jsp.context.JspTilesRequestContext.dispatch(JspTilesRequestContext.java:73) at org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:678) at org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:634) at org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:307) at org.apache.tiles.renderer.impl.UntypedAttributeRenderer.write(UntypedAttributeRenderer.java:59) at org.apache.tiles.renderer.impl.AbstractBaseAttributeRenderer.render(AbstractBaseAttributeRenderer.java:107) at org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:324) at org.apache.tiles.jsp.taglib.InsertAttributeTag.render(InsertAttributeTag.java:153) at org.apache.tiles.jsp.taglib.InsertAttributeTag.render(InsertAttributeTag.java:120) at org.apache.tiles.jsp.taglib.RenderTagSupport.doEndTag(RenderTagSupport.java:200) at _web_2d_inf._jsp._default._navigationbased._layout._navigationBased._jspService(_navigationBased.java:749) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:416) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:629) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376) at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:298) at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:42) at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:204) at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283) at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:209) at org.apache.tiles.servlet.context.ServletTilesRequestContext.forward(ServletTilesRequestContext.java:198) at org.apache.tiles.servlet.context.ServletTilesRequestContext.dispatch(ServletTilesRequestContext.java:179) at org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:678) at org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:634) at org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:307) at be.persgroep.prj.pes.base.web.site.support.spring.view.PeTilesJstlView.renderMergedOutputModel(PeTilesJstlView.java:136) at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:257) at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1179) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:920) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:822) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501) at javax.servlet.http.HttpServlet.service(HttpServlet.java:743) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64) at be.persgroep.prj.pes.base.web.site.support.FingerPrintFilter.doFilterInternal(FingerPrintFilter.java:46) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15) at be.persgroep.prj.pes.base.web.site.xss.CrossScriptingFilter.doFilter(CrossScriptingFilter.java:33) at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:17) at be.persgroep.prj.pes.base.web.site.support.spring.NavigationItemFilter.doFilterInternal(NavigationItemFilter.java:62) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:17) at be.persgroep.prj.pes.base.web.site.support.spring.ComponentFilter.doFilterInternal(ComponentFilter.java:70) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:17) at be.persgroep.prj.pes.base.web.site.i18n.LocaleWrapperFilter.doFilterInternal(LocaleWrapperFilter.java:28) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:17) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:169) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:17) at be.persgroep.prj.pes.base.web.site.security.acegi.PEAcegiContextIntegrationFilter.doFilterInternal(PEAcegiContextIntegrationFilter.java:61) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:17) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376) at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:298) at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:42) at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:204) at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283) at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:209) at org.tuckey.web.filters.urlrewrite.NormalRewrittenUrl.doRewrite(NormalRewrittenUrl.java:213) at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:171) at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381) at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:17) at be.persgroep.prj.pes.base.web.site.security.DisableUrlSessionFilter.doFilterInternal(DisableUrlSessionFilter.java:81) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376) at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:299) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:595) Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in be/persgroep/prj/pe/core/dao/ibatis/maps/sqlMapNavigationItem.xml. --- The error occurred while executing query. --- Check the SELECT NAV.ID, NAV.PARENT_ID, NAV.PUBLICATION_ID, NAV.NAVIGATION_KEY, NAV.TEASER_ANCHOR_TYPE_ID, LOC.REMARKS, NAV.POSITION, NAV.TYPE_ID, LOC.LOCALE, LOC.DESCRIPTION, NAVIGATION_LEVEL, NAV.VISIBLE, NAV.CONFIG, NAV.OPERATOR, NAV.MAX_TEASER FROM ( SELECT SUB_NAV.ID, SUB_NAV.PARENT_ID, SUB_NAV.PUBLICATION_ID, SUB_NAV.NAVIGATION_KEY, SUB_NAV.TEASER_ANCHOR_TYPE_ID, LEVEL AS NAVIGATION_LEVEL, SUB_NAV.POSITION, SUB_NAV.TYPE_ID, SUB_NAV.VISIBLE, SUB_NAV.CONFIG, SUB_NAV.OPERATOR, SUB_NAV.MAX_TEASER FROM PE_NAVIGATION_ITEMS SUB_NAV START WITH SUB_NAV.ID = ? CONNECT BY PRIOR SUB_NAV.ID = SUB_NAV.PARENT_ID ) NAV, PE_NAVIGATION_ITEMS_LOCALIZED LOC WHERE NAV.ID = LOC.NAVIGATION_ITEM_ID AND LOC.LOCALE = 'nl_BE' ORDER BY NAVIGATION_LEVEL ASC . --- Check the SQL Statement (preparation failed). --- Cause: java.sql.SQLException: Unable to get a physical connection from the database...there are no connections available. at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185) at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118) at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:298) at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209) ... 188 more Caused by: java.sql.SQLException: Unable to get a physical connection from the database...there are no connections available. at oracle.oc4j.sql.DataSourceConnectionPoolDataSource.getPooledConnection(DataSourceConnectionPoolDataSource.java:64) at oracle.oc4j.sql.xa.EmulatedXADataSource.getXAConnection(EmulatedXADataSource.java:55) at oracle.oc4j.sql.spi.ManagedConnectionFactoryImpl.createXAConnection(ManagedConnectionFactoryImpl.java:239) at oracle.oc4j.sql.spi.ManagedConnectionFactoryImpl.createManagedConnection(ManagedConnectionFactoryImpl.java:198) at com.evermind.server.connector.ApplicationConnectionManager.createManagedConnection(ApplicationConnectionManager.java:1333) at oracle.j2ee.connector.ConnectionPoolImpl.createManagedConnectionFromFactory(ConnectionPoolImpl.java:324) at oracle.j2ee.connector.ConnectionPoolImpl.access$800(ConnectionPoolImpl.java:95) at oracle.j2ee.connector.ConnectionPoolImpl$NonePoolingScheme.getManagedConnection(ConnectionPoolImpl.java:1209) at oracle.j2ee.connector.ConnectionPoolImpl.getManagedConnection(ConnectionPoolImpl.java:782) at com.evermind.server.connector.ApplicationConnectionManager.getConnectionFromPool(ApplicationConnectionManager.java:1532) at com.evermind.server.connector.ApplicationConnectionManager.acquireConnectionContext(ApplicationConnectionManager.java:1477) at com.evermind.server.connector.ApplicationConnectionManager.allocateConnection(ApplicationConnectionManager.java:1423) at oracle.j2ee.connector.OracleConnectionManager.unprivileged_allocateConnection(OracleConnectionManager.java:244) at oracle.j2ee.connector.OracleConnectionManager.allocateConnection(OracleConnectionManager.java:198) at oracle.oc4j.sql.ManagedDataSource.getConnection(ManagedDataSource.java:197) at oracle.oc4j.sql.ManagedDataSource.getConnection(ManagedDataSource.java:142) at oracle.oc4j.sql.ManagedDataSource.getConnection(ManagedDataSource.java:127) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113) at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:210) at $Proxy9.prepareStatement(Unknown Source) at com.ibatis.sqlmap.engine.execution.SqlExecutor.prepareStatement(SqlExecutor.java:494) at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:176) at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205) at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173) ... 194 more