[opencms-dev] CmsDbSqlException?

[Jonathan Woods]

Roland -
 
Which DBMS are you using, and have you altered anything in
opencms.properties?
 
Jon

  _____  

From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of Dong, Roland
Sent: 07 June 2006 15:58
To: opencms-dev at opencms.org
Subject: [opencms-dev] CmsDbSqlException?




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.templates.pa
rade_005farticle_jsp._jspService(org.apache.jsp.WEB_002dINF.jsp.online.syste
m.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.java:3
22) 
        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(Application
FilterChain.java:252) 
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173) 
        at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.
java:672) 
        at
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatch
er.java:574) 
        at
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher
.java:499) 
        at
org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDisp
atcher.java:193) 
        at
org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.j
ava:171) 
        at org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:416) 
        at
org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRe
questDispatcher.java:419) 
        at
org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.j
ava: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.java:7
11) 
        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(Application
FilterChain.java:252) 
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173) 
        at com.parade.core.dao.HibernateFilter.doFilter(Unknown Source) 
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202) 
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173) 
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:213) 
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va: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:148) 
        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.jav
a: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:535
1) 
        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(DelegatingStatement.ja
va:136) 
        at
org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPrep
aredStatement.java:131) 
        at
org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPrep
aredStatement.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/f3358592/attachment.htm>