• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

HTML-Servlet-MYSQL problem ? help needed?

 
Raghav
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I am trying to insert data from html page through post operation into a MYSQL database through a servelt, every time i enter a value in the html page and submit , i get a IllegalAccessException , can any body help me , i have attached the code below and the error below ,
servlet code:
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
class insert extends HttpServlet
{
Connection conn=null;
Statement st=null;
ResultSet rs=null;
PreparedStatement pst=null;
public void init(ServletConfig cfg) throws ServletException
{
try
{
super.init(cfg);
Class.forName("org.gjt.mm.mysql.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost/mysql?user=root&password=******","root","******");

}
catch(SQLException se)
{
}
catch(ClassNotFoundException ce)
{
}
}
public void service(HttpServletRequest req,HttpServletResponse res) throws IOException,ServletException
{
doPost(req,res);
}
public void doPost(HttpServletRequest req,HttpServletResponse res) throws IOException,ServletException
{
try
{
String aged = req.getParameter("age");
String query = "insert into rag(age) values(?)";
pst=conn.prepareStatement(query);
pst.setString(1,aged);
pst.executeUpdate();
PrintWriter pw = res.getWriter();
pw.println("done");
pw.close();
}
/*catch(Exception e)
{
System.out.println("class not found");
//e.printStackTrace();
}*/
catch (SQLException se) {
System.out.println("SQLException: " + se.getMessage());
System.out.println("SQLState: " + se.getSQLState());
System.out.println("VendorError: " + se.getErrorCode());
}
}
public void destroy()
{
try
{
rs.close();
conn.close();
}
catch(Exception e){}
}
}
error when invoked from a html page:
Error: 500
Internal Servlet Error:
java.lang.IllegalAccessException: insert
at java.lang.Class.newInstance0(Native Method)
at java.lang.Class.newInstance(Unknown Source)
at com.sun.web.core.ServletWrapper.loadServlet(ServletWrapper.java:90)
at com.sun.web.core.ServletWrapper.handleRequest(ServletWrapper.java:109)
at com.sun.web.core.InvokerServlet.service(InvokerServlet.java:169)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:840)
at com.sun.web.core.ServletWrapper.handleRequest(ServletWrapper.java:140)
at com.sun.web.core.Context.handleRequest(Context.java:375)
at com.sun.web.server.ConnectionHandler.run(ConnectionHandler.java:135)
thanks
raghav
 
Vlad Patryshev
Ranch Hand
Posts: 61
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I would at least try to catch this exception in init(); while it is kind of obvious that the exception is thrown when trying to load the JDBC driver for mySQL, it is better to make sure that this is the case.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic