Error while running a JSP file

[deeptic]

Hi,

 

 

 

I am following a documentation on Using FusionCharts with JSP > Plotting data from a database. Please find the same in:

 

 

 

https://www.cre8ivewebsites.com/js/3rdparty/FusionCharts/Contents/JSP_DB.html

 

 

 

 

 

 

 

I am trying to run the BasicDBExample.jsp file in Tomcat. But, I keep getting this error:

 

 

 

 

 

HTTP Status 500 -

 

 

 

--------------------------------------------------------------------------------

 

 

 

type Exception report

 

 

 

message

 

 

 

description The server encountered an internal error () that prevented it from fulfilling this request.

 

 

 

exception

 

 

 

org.apache.jasper.JasperException: An exception occurred processing JSP page /DBExample/BasicDBExample.jsp at line 59

 

 

 

56: strQuery = "select * from Factory_Master";

 

57:

 

58:

 

59: st1=oConn.createStatement();

 

60: rs1=st1.executeQuery(strQuery);

 

61:

 

62: String factoryId=null;

 

 

 

 

 

Stacktrace:

 

org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)

 

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:416)

 

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)

 

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)

 

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

 

 

 

 

 

root cause

 

 

 

java.lang.NullPointerException

 

org.apache.jsp.DBExample.BasicDBExample_jsp._jspService(BasicDBExample_jsp.java:150)

 

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

 

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

 

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)

 

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)

 

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)

 

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

 

 

 

 

 

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs.

 

 

 

 

 

--------------------------------------------------------------------------------

 

 

 

Apache Tomcat/6.0.18

 

 

 

 

 

Can somebody please guide me on this

[srividya_sharma]

Please verify that you have performed the step 5 of the readme which says:

5. In order to configure the MySQL database:

Open the file "CATALINA_HOME"/webapps/FusionCharts_JSP/META-INF/context.xml. 

In this xml,please change the username,password,url according to your database.

Hope this helps!

Srividya

[deeptic]

Hi Srividya,

 

 

 

Yes, I had made the changes initially. But I realized that the changes weren't being reflected in the folder in WEBAPPS. So, I worked on it ; I made all the changes before loading the folder in WEBAPPS. This has been successful; the chart is now visible in the browser.

[srividya_sharma]

Glad to hear that your problem got solved with that.