Win a copy of Practical SVG this week in the HTML/CSS/JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

connecting to database through servlets

 
jilla yuvaraj
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i tried to connect to databases ms-access through servlets but i didn't get the correct answer, when i used the same program as application it was working properly,
i have a database in which i have a table called emp which has two fieds one is eno and another one is ename , both are of type text.
The actual code is
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Sample extends HttpServlet{
public void doGet(HttpServletRequest req, HttpServletResponse res)throws ServletException,IOException{
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
res.setContentType("text/html");
PrintWriter out = res.getWriter();
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc dbc:test");
stmt=con.createStatement();
rs=stmt.executeQuery("select * from emp");
out.println("<html>welcome<html><ul>");
while(rs.next())
{
out.println("<li>"+rs.getString("eno")+" "+rs.getString("ename"));
}
out.println("</ul>");
} catch(Exception e){out.println(e);}
}
}
i got the following exception when i create the dsn as system dsn
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'DriverId'.
i got the following exception when i create the dsn as user dsn

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

i tried the same with username and password for oracle
but i got the same exception as i got for ms-access.
can anybody help me out ?? do i need to do any modification in creating the dsn name??
Yuvaraj
 
Ramesh Magadi
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
just try this one
con=DriverManager.getConnection("jdbc dbc:test","","");
Where test is the name of the Database
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!