File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Java » Servlets
Reply locked 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
Craig Jackson
Ranch Hand

Joined: Mar 19, 2002
Posts: 405
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 29219
    
134

Craig is correct. Interestingly, that code shouldn't even compile.

I'm going to move this to the Servlets forum.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29219
    
134

Gaurav,
Please don't post the same question in multiple forums
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: error in connectivity with database
 
Similar Threads
error in connectivity with database
problem in excuting Basicservlet
servlet class not compiling. Classpath problem?
Progress bar on IE6
if (req.getMethod().equals("HEAD")) return