[opencms-dev] CmsDbSqlException?

[Dong, Roland]

Hi, OpenCms Experts,

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.  

It looks like that it is a sql error but not sure how that could happen.
Can anyone throw some light on this?


Thanks a lot,

Roland

org.opencms.db.CmsDbSqlException: Error reading the property value for
property "Hidden" of resource
"/articles/editions/2004/edition_03-07-2004/featured_0". 
	at
org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:
103)
	at
org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:213)
	at org.opencms.db.CmsDbContext.report(CmsDbContext.java:197)
	at
org.opencms.db.CmsSecurityManager.readPropertyObject(CmsSecurityManager.
java:3726)
	at
org.opencms.file.CmsObject.readPropertyObject(CmsObject.java:2505)
	at com.test.ui.Service.getProperty(Unknown Source)
	at com.test.ui.MyService.filterHiddens(Unknown Source)
	at com.test.ui.MyService.getRelatedContent(Unknown Source)
	at
org.apache.jsp.WEB_002dINF.jsp.online.system.modules.com_parade.template
s.parade_005farticle_jsp._jspService(org.apache.jsp.WEB_002dINF.jsp.onli
ne.system.modules.com_test.templates.test_005farticle_jsp:312)
	at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja
va:322)
	at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
	at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:252)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
	at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatc
her.java:672)
	at
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDisp
atcher.java:574)
	at
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispat
cher.java:499)
	at
org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequest
Dispatcher.java:193)
	at
org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatch
er.java:171)
	at
org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:416)
	at
org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFl
exRequestDispatcher.java:419)
	at
org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatch
er.java:175)
	at
org.opencms.loader.CmsJspLoader.dispatchJsp(CmsJspLoader.java:450)
	at org.opencms.loader.CmsJspLoader.load(CmsJspLoader.java:395)
	at
org.opencms.loader.CmsXmlContentLoader.load(CmsXmlContentLoader.java:209
)
	at
org.opencms.loader.CmsResourceManager.loadResource(CmsResourceManager.ja
va:711)
	at
org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1337)
	at
org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:139)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:252)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
	at com.parade.core.dao.HibernateFilter.doFilter(Unknown Source)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:213)
	at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.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:1
48)
	at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307)
	at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385)
	at
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748)
	at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:
678)
	at
org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)
	at java.lang.Thread.run(Thread.java:595)
Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when
executing the following query:
oracle.jdbc.driver.T4CPreparedStatement at ce8a40. 
	at
org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1436)
	at
org.opencms.db.CmsDriverManager.readResource(CmsDriverManager.java:5535)
	at
org.opencms.db.CmsDriverManager.readPropertyObject(CmsDriverManager.java
:5351)
	at
org.opencms.db.CmsSecurityManager.readPropertyObject(CmsSecurityManager.
java:3724)
	... 47 more
Caused by: java.sql.SQLException:
org.apache.commons.dbcp.PoolablePreparedStatement is closed.
	at
org.apache.commons.dbcp.DelegatingStatement.checkOpen(DelegatingStatemen
t.java:136)
	at
org.apache.commons.dbcp.DelegatingPreparedStatement.setString(Delegating
PreparedStatement.java:131)
	at
org.apache.commons.dbcp.DelegatingPreparedStatement.setString(Delegating
PreparedStatement.java:131)
	at
org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1422)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20060607/0dfb7341/attachment.htm>