GeeCON Prague 2014*
The moose likes Servlets and the fly likes error in connectivity with database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Java » Servlets
Bookmark "error in connectivity with database" Watch "error in connectivity with database" New topic
Author

error in connectivity with database

gaurav chhabra
Ranch Hand

Joined: Jul 24, 2004
Posts: 109
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
James Carman
Ranch Hand

Joined: Feb 20, 2001
Posts: 580
You've got your parameters of your doGet() method in the wrong order. The request comes before the response. So, you're not overriding anything.


James Carman, President<br />Carman Consulting, Inc.
James Carman
Ranch Hand

Joined: Feb 20, 2001
Posts: 580
Oh, and you did it in your doPost() method too :-)
gaurav chhabra
Ranch Hand

Joined: Jul 24, 2004
Posts: 109
thank you for your help
James Carman
Ranch Hand

Joined: Feb 20, 2001
Posts: 580
No problem. Did that do the trick for you?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: error in connectivity with database