| Author |
error in connectivity with database
|
gaurav chhabra
Ranch Hand
Joined: Jul 24, 2004
Posts: 109
|
posted

0
|
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
|
posted

0
|
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: 26144
|
posted

0
|
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: 26144
|
posted

0
|
Gaurav, Please don't post the same question in multiple forums
|
 |
 |
|
|
subject: error in connectivity with database
|
|
|