<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6617.79">
<TITLE>CmsDbSqlException?</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<BR>
<P><FONT SIZE=2 FACE="Arial">Hi, OpenCms Experts,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I have problem figuring out what has caused the following error? It seems that sometimes an 500 error occurs when an article link is clicked but It is hard to duplicate the error because if you click on the same article again, it works out fine. </FONT></P>
<P><FONT SIZE=2 FACE="Arial">It looks like that it is a sql error but not sure how that could happen. Can anyone throw some light on this?</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">Thanks a lot,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Roland</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">org.opencms.db.CmsDbSqlException: Error reading the property value for property "Hidden" of resource "/articles/editions/2004/edition_03-07-2004/featured_0". </FONT></P>
<P> <FONT SIZE=2 FACE="Arial">at org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:103)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:213)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.opencms.db.CmsDbContext.report(CmsDbContext.java:197)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.opencms.db.CmsSecurityManager.readPropertyObject(CmsSecurityManager.java:3726)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.opencms.file.CmsObject.readPropertyObject(CmsObject.java:2505)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at com.test.ui.Service.getProperty(Unknown Source)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at com.test.ui.MyService.filterHiddens(Unknown Source)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at com.test.ui.MyService.getRelatedContent(Unknown Source)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.com_parade.templates.parade_005farticle_jsp._jspService(org.apache.jsp.WEB_002dINF.jsp.online.system.modules.com_test.templates.test_005farticle_jsp:312)</FONT></P>
<P> <FONT SIZE=2 FACE="Arial">at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:574)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:193)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:171)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:416)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:419)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:175)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.opencms.loader.CmsJspLoader.dispatchJsp(CmsJspLoader.java:450)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.opencms.loader.CmsJspLoader.load(CmsJspLoader.java:395)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.opencms.loader.CmsXmlContentLoader.load(CmsXmlContentLoader.java:209)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.opencms.loader.CmsResourceManager.loadResource(CmsResourceManager.java:711)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1337)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:139)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at com.parade.core.dao.HibernateFilter.doFilter(Unknown Source)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:678)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at java.lang.Thread.run(Thread.java:595)</FONT>
<BR><FONT SIZE=2 FACE="Arial">Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: oracle.jdbc.driver.T4CPreparedStatement@ce8a40. </FONT></P>
<P> <FONT SIZE=2 FACE="Arial">at org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1436)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.opencms.db.CmsDriverManager.readResource(CmsDriverManager.java:5535)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.opencms.db.CmsDriverManager.readPropertyObject(CmsDriverManager.java:5351)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.opencms.db.CmsSecurityManager.readPropertyObject(CmsSecurityManager.java:3724)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">... 47 more</FONT>
<BR><FONT SIZE=2 FACE="Arial">Caused by: java.sql.SQLException: org.apache.commons.dbcp.PoolablePreparedStatement is closed.</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.commons.dbcp.DelegatingStatement.checkOpen(DelegatingStatement.java:136)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:131)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:131)</FONT>
<BR> <FONT SIZE=2 FACE="Arial">at org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1422)</FONT>
</P>
</BODY>
</HTML>