<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>CmsDbSqlException?</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=547491015-07062006><FONT face=Arial
color=#0000ff size=2>Roland -</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=547491015-07062006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=547491015-07062006><FONT face=Arial
color=#0000ff size=2>Which DBMS are you using, and have you altered anything in
opencms.properties?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=547491015-07062006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=547491015-07062006><FONT face=Arial
color=#0000ff size=2>Jon</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> opencms-dev-bounces@opencms.org
[mailto:opencms-dev-bounces@opencms.org] <B>On Behalf Of </B>Dong,
Roland<BR><B>Sent:</B> 07 June 2006 15:58<BR><B>To:</B>
opencms-dev@opencms.org<BR><B>Subject:</B> [opencms-dev]
CmsDbSqlException?<BR></FONT><BR></DIV>
<DIV></DIV><!-- Converted from text/rtf format --><BR>
<P><FONT face=Arial size=2>Hi, OpenCms Experts,</FONT> </P>
<P><FONT face=Arial size=2>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 face=Arial size=2>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 face=Arial size=2>Thanks a lot,</FONT> </P>
<P><FONT face=Arial size=2>Roland</FONT> </P>
<P><FONT face=Arial size=2>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 face=Arial size=2>at
org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:103)</FONT>
<BR> <FONT face=Arial size=2>at
org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:213)</FONT>
<BR> <FONT face=Arial size=2>at
org.opencms.db.CmsDbContext.report(CmsDbContext.java:197)</FONT>
<BR> <FONT face=Arial size=2>at
org.opencms.db.CmsSecurityManager.readPropertyObject(CmsSecurityManager.java:3726)</FONT>
<BR> <FONT face=Arial size=2>at
org.opencms.file.CmsObject.readPropertyObject(CmsObject.java:2505)</FONT>
<BR> <FONT face=Arial size=2>at
com.test.ui.Service.getProperty(Unknown Source)</FONT>
<BR> <FONT face=Arial size=2>at
com.test.ui.MyService.filterHiddens(Unknown Source)</FONT>
<BR> <FONT face=Arial size=2>at
com.test.ui.MyService.getRelatedContent(Unknown Source)</FONT>
<BR> <FONT face=Arial size=2>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 face=Arial size=2>at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)</FONT>
<BR> <FONT face=Arial size=2>at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)</FONT>
<BR> <FONT face=Arial size=2>at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:574)</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499)</FONT>
<BR> <FONT face=Arial size=2>at
org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:193)</FONT>
<BR> <FONT face=Arial size=2>at
org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:171)</FONT>
<BR> <FONT face=Arial size=2>at
org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:416)</FONT>
<BR> <FONT face=Arial size=2>at
org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:419)</FONT>
<BR> <FONT face=Arial size=2>at
org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:175)</FONT>
<BR> <FONT face=Arial size=2>at
org.opencms.loader.CmsJspLoader.dispatchJsp(CmsJspLoader.java:450)</FONT>
<BR> <FONT face=Arial size=2>at
org.opencms.loader.CmsJspLoader.load(CmsJspLoader.java:395)</FONT>
<BR> <FONT face=Arial size=2>at
org.opencms.loader.CmsXmlContentLoader.load(CmsXmlContentLoader.java:209)</FONT>
<BR> <FONT face=Arial size=2>at
org.opencms.loader.CmsResourceManager.loadResource(CmsResourceManager.java:711)</FONT>
<BR> <FONT face=Arial size=2>at
org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1337)</FONT>
<BR> <FONT face=Arial size=2>at
org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:139)</FONT>
<BR> <FONT face=Arial size=2>at
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)</FONT>
<BR> <FONT face=Arial size=2>at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)</FONT>
<BR> <FONT face=Arial size=2>at
com.parade.core.dao.HibernateFilter.doFilter(Unknown Source)</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307)</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385)</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748)</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:678)</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871)</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)</FONT>
<BR> <FONT face=Arial size=2>at
java.lang.Thread.run(Thread.java:595)</FONT> <BR><FONT face=Arial size=2>Caused
by: org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the
following query: oracle.jdbc.driver.T4CPreparedStatement@ce8a40. </FONT></P>
<P> <FONT face=Arial size=2>at
org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1436)</FONT>
<BR> <FONT face=Arial size=2>at
org.opencms.db.CmsDriverManager.readResource(CmsDriverManager.java:5535)</FONT>
<BR> <FONT face=Arial size=2>at
org.opencms.db.CmsDriverManager.readPropertyObject(CmsDriverManager.java:5351)</FONT>
<BR> <FONT face=Arial size=2>at
org.opencms.db.CmsSecurityManager.readPropertyObject(CmsSecurityManager.java:3724)</FONT>
<BR> <FONT face=Arial size=2>... 47
more</FONT> <BR><FONT face=Arial size=2>Caused by: java.sql.SQLException:
org.apache.commons.dbcp.PoolablePreparedStatement is closed.</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.commons.dbcp.DelegatingStatement.checkOpen(DelegatingStatement.java:136)</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:131)</FONT>
<BR> <FONT face=Arial size=2>at
org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:131)</FONT>
<BR> <FONT face=Arial size=2>at
org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1422)</FONT>
</P></BODY></HTML>