Configuration : Error when trying to thest the database connection

[Elisma Jooste]

Error I receive:

HTTP Status 500 – Internal Server Error

Type Exception Report

Message An exception occurred processing [/licensing/6.jsp] at line [26]

Description The server encountered an unexpected condition that prevented it from fulfilling the request.

Exception

org.apache.jasper.JasperException: An exception occurred processing [/licensing/6.jsp] at line [26]

23:
24:
25:
26: <%boolean connectionError = DataSourceManager.testConnection();%>
27: <%if (!connectionError) {
28: out.print("Success");
29: } else {

Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:593)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:467)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
com.wanhive.basic.web.Configure.doGet(Configure.java:138)
javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

Root Cause

javax.servlet.ServletException: java.lang.NoClassDefFoundError: snaq/db/ConnectionPoolManager
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:667)
org.apache.jsp.licensing._6_jsp._jspService(_6_jsp.java:167)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:444)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
com.wanhive.basic.web.Configure.doGet(Configure.java:138)
javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

Root Cause

java.lang.NoClassDefFoundError: snaq/db/ConnectionPoolManager
com.wanhive.basic.utils.licensing.Application.getConnectionPool(Application.java:121)
com.wanhive.basic.utils.licensing.Application.getConnection(Application.java:148)
com.wanhive.basic.db.DataSourceManager.newConnection(DataSourceManager.java:42)
com.wanhive.basic.db.DataSourceManager.testConnection(DataSourceManager.java:52)
org.apache.jsp.licensing._6_jsp._jspService(_6_jsp.java:145)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:444)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
com.wanhive.basic.web.Configure.doGet(Configure.java:138)
javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

Note The full stack trace of the root cause is available in the server logs.
Apache Tomcat/9.0.1

[Wanhive]

In response to your report I executed following steps:
A. Downloaded Tomcat 7 (Tomcat's version doesn't matter that much) and started it
B. Downloaded the war file (2.1.0) from the sourceforge and deployed it inside Tomcat I had downloaded in step A
C. Stopped Mysql service
D. Tested Connection (screenshot attached), off course stacktrace been printed on the tomcat's console and log however error code 500 is not returned to the browser and a proper error message is displayed.

The root cause is NoClassDefFoundError which suggests an issue with your runtime environment. Please make sure that Java 8 is installed on your machine and the Tomcat you are running is the official package.