[opencms-dev] Issue with OpenCms 10.5.3
niveditasheoran
niveditasheoran at cdac.in
Fri Aug 22 08:50:41 CEST 2025
Hello,
We have an application developed using OpenCms 10.5.3, PostgreSQL 7.4, and Java
8. Recently, we attempted to run this application in a new environment with the
following setup:
Tomcat 9 (deployed the application in the webapps folder)
PostgreSQL 17 (restored the old database)
Java 17
Initially, the application failed to connect (screenshot attached) due to an
outdated JDBC driver (postgresql-9.0-801.jdbc3.jar). After replacing it with the
latest driver (postgresql-42.7.7.jar), the application started just header and
footer came and we observed that the middle section of the website is not
rendering as expected because OpenCms tries to connect to the PostgreSQL
database from a JSP tag, but the attempt fails with SocketTimeoutException
(connect timed out).
I have also attached the OpenCms log file for reference. Could you please advise
if this issue could be related to compatibility (OpenCms 10.5.3 with Java
17/PostgreSQL 17/tomcat 9), or if there might be another root cause?
Thank you.
Best regards,
Nivedita
------------------------------------------------------------------------------------------------------------
[ C-DAC is on Social-Media too. Kindly follow us at:
Facebook: https://www.facebook.com/CDACINDIA & Twitter: @cdacindia ]
This e-mail is for the sole use of the intended recipient(s) and may
contain confidential and privileged information. If you are not the
intended recipient, please contact the sender by reply e-mail and destroy
all copies and the original message. Any unauthorized review, use,
disclosure, dissemination, forwarding, printing or copying of this email
is strictly prohibited and appropriate legal action will be taken.
------------------------------------------------------------------------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opencms.org/pipermail/opencms-dev/attachments/20250822/e38117f9/attachment.htm>
-------------- next part --------------
22 Aug 2025 11:36:18,274 ERROR [opencms.jsp.CmsJspTagContainer:1664] Container-page element "/.content/function/function-00039.xml" could not be rendered with formatter "/system/modules/org.opencms.ade.config/formatters/function.jsp".
javax.servlet.jsp.JspException: javax.servlet.ServletException: org.postgresql.util.PSQLException: The connection attempt failed.
at org.opencms.jsp.CmsJspTagInclude.includeActionWithCache(CmsJspTagInclude.java:386)
at org.opencms.jsp.CmsJspTagInclude.includeTagAction(CmsJspTagInclude.java:244)
at org.opencms.jsp.CmsJspTagContainer.renderContainerElement(CmsJspTagContainer.java:1650)
at org.opencms.jsp.CmsJspTagContainer.doEndTag(CmsJspTagContainer.java:750)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.org_opencms_apollo.formatters.layoutrow_jsp._jspx_meth_cms_005fcontainer_005f0(layoutrow_jsp.java:1701)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.org_opencms_apollo.formatters.layoutrow_jsp._jspx_meth_c_005fwhen_005f4(layoutrow_jsp.java:1338)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.org_opencms_apollo.formatters.layoutrow_jsp._jspx_meth_c_005fchoose_005f3(layoutrow_jsp.java:1243)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.org_opencms_apollo.formatters.layoutrow_jsp._jspx_meth_c_005fforEach_005f0(layoutrow_jsp.java:1034)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.org_opencms_apollo.formatters.layoutrow_jsp._jspx_meth_c_005fwhen_005f0(layoutrow_jsp.java:277)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.org_opencms_apollo.formatters.layoutrow_jsp._jspx_meth_c_005fchoose_005f0(layoutrow_jsp.java:236)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.org_opencms_apollo.formatters.layoutrow_jsp._jspService(layoutrow_jsp.java:191)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:67)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:376)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:324)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:642)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:518)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:461)
at org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:191)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:165)
at org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:666)
at org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:441)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:169)
at org.opencms.jsp.CmsJspTagInclude.includeActionWithCache(CmsJspTagInclude.java:379)
at org.opencms.jsp.CmsJspTagInclude.includeTagAction(CmsJspTagInclude.java:244)
at org.opencms.jsp.CmsJspTagContainer.renderContainerElement(CmsJspTagContainer.java:1650)
at org.opencms.jsp.CmsJspTagContainer.doEndTag(CmsJspTagContainer.java:750)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.org_opencms_apollo.formatters.layoutrow_jsp._jspx_meth_cms_005fcontainer_005f0(layoutrow_jsp.java:1701)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.org_opencms_apollo.formatters.layoutrow_jsp._jspx_meth_c_005fwhen_005f4(layoutrow_jsp.java:1338)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.org_opencms_apollo.formatters.layoutrow_jsp._jspx_meth_c_005fchoose_005f3(layoutrow_jsp.java:1243)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.org_opencms_apollo.formatters.layoutrow_jsp._jspx_meth_c_005fforEach_005f0(layoutrow_jsp.java:1034)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.org_opencms_apollo.formatters.layoutrow_jsp._jspx_meth_c_005fwhen_005f0(layoutrow_jsp.java:277)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.org_opencms_apollo.formatters.layoutrow_jsp._jspx_meth_c_005fchoose_005f0(layoutrow_jsp.java:236)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.org_opencms_apollo.formatters.layoutrow_jsp._jspService(layoutrow_jsp.java:191)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:67)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:376)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:324)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:642)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:518)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:461)
at org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:191)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:165)
at org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:666)
at org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:441)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:169)
at org.opencms.jsp.CmsJspTagInclude.includeActionWithCache(CmsJspTagInclude.java:379)
at org.opencms.jsp.CmsJspTagInclude.includeTagAction(CmsJspTagInclude.java:244)
at org.opencms.jsp.CmsJspTagContainer.renderContainerElement(CmsJspTagContainer.java:1650)
at org.opencms.jsp.CmsJspTagContainer.doEndTag(CmsJspTagContainer.java:750)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.NVS_WEB.templates.nvs_002dpage_jsp._jspx_meth_cms_005fcontainer_005f0(nvs_002dpage_jsp.java:1080)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.NVS_WEB.templates.nvs_002dpage_jsp.access$22(nvs_002dpage_jsp.java:1044)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.NVS_WEB.templates.nvs_002dpage_jsp$Helper.invoke1(nvs_002dpage_jsp.java:1458)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.NVS_WEB.templates.nvs_002dpage_jsp$Helper.invoke(nvs_002dpage_jsp.java:1505)
at org.apache.jsp.tag.web.apollo.megamenu_tag._jspx_meth_c_005fwhen_005f1(megamenu_tag.java:486)
at org.apache.jsp.tag.web.apollo.megamenu_tag._jspx_meth_c_005fchoose_005f0(megamenu_tag.java:356)
at org.apache.jsp.tag.web.apollo.megamenu_tag.doTag(megamenu_tag.java:155)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.NVS_WEB.templates.nvs_002dpage_jsp._jspService(nvs_002dpage_jsp.java:254)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:67)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:376)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:324)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:642)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:518)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:461)
at org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:191)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:165)
at org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:666)
at org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:441)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:169)
at org.opencms.loader.CmsJspLoader.dispatchJsp(CmsJspLoader.java:988)
at org.opencms.loader.CmsJspLoader.load(CmsJspLoader.java:538)
at org.opencms.loader.CmsXmlContainerPageLoader.load(CmsXmlContainerPageLoader.java:115)
at org.opencms.loader.CmsResourceManager.loadResource(CmsResourceManager.java:1194)
at org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1789)
at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:161)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:529)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.opencms.jsp.jsonpart.CmsJsonPartFilter.doFilter(CmsJsonPartFilter.java:281)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:642)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:416)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:348)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:285)
at org.opencms.main.OpenCmsUrlServletFilter.doFilter(OpenCmsUrlServletFilter.java:127)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:396)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:937)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Thread.java:842)
Caused by: javax.servlet.ServletException: org.postgresql.util.PSQLException: The connection attempt failed.
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:654)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.NVS_WEB.elements.counter2_jsp._jspService(counter2_jsp.java:299)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:67)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:376)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:324)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:642)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:518)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:461)
at org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:191)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:165)
at org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:666)
at org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:441)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:169)
at org.opencms.jsp.CmsJspTagInclude.includeActionWithCache(CmsJspTagInclude.java:379)
at org.opencms.jsp.CmsJspTagInclude.includeTagAction(CmsJspTagInclude.java:244)
at org.opencms.jsp.CmsJspTagInclude.doEndTag(CmsJspTagInclude.java:490)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.org_opencms_ade_config.formatters.function_jsp._jspx_meth_cms_005finclude_005f0(function_jsp.java:322)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.org_opencms_ade_config.formatters.function_jsp._jspx_meth_c_005fwhen_005f0(function_jsp.java:275)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.org_opencms_ade_config.formatters.function_jsp._jspx_meth_c_005fchoose_005f0(function_jsp.java:239)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.org_opencms_ade_config.formatters.function_jsp._jspService(function_jsp.java:169)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:67)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:376)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:324)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:642)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:518)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:461)
at org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:191)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:165)
at org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:666)
at org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:441)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:169)
at org.opencms.jsp.CmsJspTagInclude.includeActionWithCache(CmsJspTagInclude.java:379)
... 121 more
Caused by: org.postgresql.util.PSQLException: The connection attempt failed.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:385)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:57)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:277)
at org.postgresql.Driver.makeConnection(Driver.java:448)
at org.postgresql.Driver.connect(Driver.java:298)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:681)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:229)
at org.apache.jsp.WEB_002dINF.jsp.online.system.modules.NVS_WEB.elements.counter2_jsp._jspService(counter2_jsp.java:191)
... 161 more
Caused by: java.net.SocketTimeoutException: Connect timed out
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:551)
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:602)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
at java.base/java.net.Socket.connect(Socket.java:633)
at org.postgresql.core.PGStream.createSocket(PGStream.java:261)
at org.postgresql.core.PGStream.<init>(PGStream.java:122)
at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:146)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:289)
... 168 more
-------------- next part --------------
A non-text attachment was scrubbed...
Name: error with old driver.png
Type: image/png
Size: 30103 bytes
Desc: not available
URL: <http://lists.opencms.org/pipermail/opencms-dev/attachments/20250822/e38117f9/attachment.png>
More information about the opencms-dev
mailing list