line 63 is the last line of this code section which shows everything upto that point. it is basically where it tries to create the statement. I keep thinking it is something to do with the mySql driver because I am trying to run it on the machine it will work from normally, however it works fine on my developer machince when launched from NetBeans
public class initialEnq extends HttpServlet {
Connection con;
public void init(ServletConfig config) throws ServletException {
super.init(config);
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/pd206",
"root", "password");
} catch (ClassNotFoundException e) {
System.out.println("Class still not found");
} catch (SQLException e) {
System.out.println("SQL Exception in init");
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String a = request.getParameter("number");
String b = request.getParameter("rank");
String c = request.getParameter("surname");
String d = request.getParameter("forenames");
String e = request.getParameter("trade");
String f = request.getParameter("unit");
String g = request.getParameter("unitAddress");
String h = request.getParameter("workContactNo");
String i = request.getParameter("mobileContactNo");
String j = request.getParameter("actionTaken");
String k = request.getParameter("actionRequired");
String l = request.getParameter("submitedBy");
String m = request.getParameter("dateCompleted");
submitData(a, b, c, d, e, f, g, h, i, j, k, l, m);
RequestDispatcher view = request.getRequestDispatcher("submited.jsp");
view.forward(request, response);
}
public void submitData(String a, String b, String c, String d, String e, String f,
String g, String h, String i, String j, String k, String l, String m) {
try {
Statement stmt = con.createStatement();