servlet database connnetivity using MS SQL server

Ranch Hand

Posts: 43

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

The following code runs fine but prints "failed connection" .
Here's the code :" form.html"

Code for servlet : "ganesha.java"

public class ganesha extends HttpServlet {
   
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException, ClassNotFoundException, SQLException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        String roll=request.getParameter("roll");
        String name=request.getParameter("name");
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con=DriverManager.getConnection("jdbc:odbc:divya","divya","divya");
          //Statement s=(Statement) con.createStatement();
            //PreparedStatement st=con.prepareStatement("select * from di");
           // ResultSet rs=st.executeQuery("select * from di");
            String sql = "insert into di values (?,?)";
  PreparedStatement pst = con.prepareStatement(sql);
  pst.setString(1, roll);
  pst.setString(2, name);
  
            int a=pst.executeUpdate();

} finally { 
            out.println("Failed connection");
            out.close();
        }
    }

// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /** 
    * Handles the HTTP <code>GET</code> method.
    * @param request servlet request
    * @param response servlet response
    */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        try {
            processRequest(request, response);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(ganesha.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(ganesha.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

/** 
    * Handles the HTTP <code>POST</code> method.
    * @param request servlet request
    * @param response servlet response
    */
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        try {
            processRequest(request, response);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(ganesha.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(ganesha.class.getName()).log(Level.SEVERE, null, ex);
        }
        
        
    }

/** 
    * Returns a short description of the servlet.
    */
    public String getServletInfo() {
        return "Short description";
    }
    // </editor-fold>
}

Kindly help me sort out this.

Matthew Brown

Bartender

Posts: 4568

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

You're printing "Failed connection" in a finally block. That means it's always going to be printed - the finally block will always run (that's what it's for).

I suspect what you really wanted to do was print that out if there's an exception, in which case it needs to be in a catch block.

Thank you my well lotioned goddess! Here, have my favorite tiny ad!

a bit of art, as a gift, that will fit in a stocking

https://gardener-gift.com