File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Servlets and the fly likes Connecting to database form servlets Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Bookmark "Connecting to database form servlets" Watch "Connecting to database form servlets" New topic

Connecting to database form servlets

jilla yuvaraj

Joined: Nov 28, 2001
Posts: 4
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.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;
PrintWriter out = res.getWriter();

con=DriverManager.getConnection("jdbc dbc:test");
rs=stmt.executeQuery("select * from emp");
out.println("<li>"+rs.getString("eno")+" "+rs.getString("ename"));
} 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??


Bashir Mirzad

Joined: Nov 28, 2001
Posts: 25
Hi dear !
for your Oracle problem I can tell if you have problem wiht the user name and password, if you using Windows 2000, go to the Control Panel/Performance and Maintenance/Administrative Tools/Services then start the all services for Oracle
Hope it can help
Pranit Saha
Ranch Hand

Joined: Sep 09, 2001
Posts: 130

i got the following exception when i create the dsn as user dsn

You have o make the DSN as System DSN..
I agree. Here's the link:
subject: Connecting to database form servlets
It's not a secret anymore!