Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
    Bookmark Topic Watch Topic
  • New Topic

error in connectivity with database

 
gaurav chhabra
Ranch Hand
Posts: 109
  • Mark post as helpful
  • send pies
  • Report post to moderator
sir
i want to connect my servlet with MICROSOFT ACCESS and it is giving the error GET methord does not supported..
my code is as follows.........




import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.io.*;

public class connection extends HttpServlet
{
public void init(ServletConfig config) throws ServletException
{
super.init(config);
}

public void doPost(HttpServletResponse res,HttpServletRequest req) throws ServletException,IOException
{
PrintWriter out=null;
try
{
String url = "jdbc dbc:ram";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection conn = DriverManager.getConnection(url,"","");

Statement st = conn.createStatement();

String query = "insert into check values('ram',100)";

st.executeUpdate(query);

res.setContentType("text/html");
out = res.getWriter();

out.println("<html>");
out.println("<body>");
out.println("<jai shri ram>");
out.println("</body>");
out.println("</html>");

conn.close();
}
catch(Exception e)
{
out.println("there is some problem");
}

}


public void doGet(HttpServletResponse res,HttpServletRequest req)throws ServletException,IOException
{
doPost(res,req);
}



}


please tell my mistake
thank you
gaurav
 
Craig Jackson
Ranch Hand
Posts: 405
  • Mark post as helpful
  • send pies
  • Report post to moderator
This is actually more of a JSP/Servlet issue than a JDBC problem. I believe you have the parameter order for your doGet and doPost methods backwards.

The correct method signature should be:
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34837
369
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Report post to moderator
Craig is correct. Interestingly, that code shouldn't even compile.

I'm going to move this to the Servlets forum.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34837
369
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Report post to moderator
Gaurav,
Please don't post the same question in multiple forums
 
    Bookmark Topic Watch Topic
  • New Topic