JSP and Databases

[vinot85]

How to connect a JSP page with a database?

I have tried connecting a MS Access database with a JSP Page.Im using Apache Tomcat as my Web server.

It is showing a Sql Execption as,
No default driver specified.
Plz tell me how can i avoid the error...

[r035198x]

How to connect a JSP page with a database?

I have tried connecting a MS Access database with a JSP Page.Im using Apache Tomcat as my Web server.

It is showing a Sql Execption as,
No default driver specified.
Plz tell me how can i avoid the error...

Post the code you used to connect the database.

[vinot85]

Here is the Code i have used to create the thing.

 <%@page import="java.sql.*"%>
<%
 
      String a1,a2;
    Connection con;
    Statement p;
    ResultSet rs;
      a1= request.getParameter("t1");
      a2 =  request.getParameter("t2");
      try{ 
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch(ClassNotFoundException cnf){
        cnf.printStackTrace();
    }
    try{
        out.println("im here");
            con=DriverManager.getConnection("jdbc:odbc:praise1","exam01", "exam01");
            p=con.createStatement();
        rs = p.executeQuery("select * from emptable");
        while(rs.next()){
            out.println(" "+rs.getInt("no"));
            out.println(rs.getString("name"));
        }
       }
     catch(SQLException rr){
            out.println(rr);
       }
%>