Attached is the code:
Please note that this code works within a command line if I add
main(string[]) function.
There is no problem with setting up the dsn or odbc. I havent figured out
why it does not work within a servlet?
--------------------------------------------------------
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class tappDisplay extends HttpServlet {
public void init()
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
}catch(Exception e){e.printStackTrace();}
}
public void doGet(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
Connection con = null;
Statement stmt = null;
String sUserType = null;
String sUserIsAuthorized = null;
ResultSet rs = null;
HttpSession ses = req.getSession(true);
res.setContentType("text/html");
PrintWriter out = res.getWriter();
try {
out.println("<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0
Transitional//EN'
'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'>");
out.println("<html>");
out.println(" <head>");
out.println("<title></title>");
out.println("<meta http-equiv='Content-Type' content='text/html;
charset=windows-1252' />");
out.println("<meta name='Keywords' content='' />");
out.println("<meta name='Description' content='' />");
out.println("<meta http-equiv='pragma' content='no-cache' />");
out.println("<meta http-equiv='cache-control' content='no-cache'
/>");
out.println("<link rel='stylesheet' type='text/css' href='/std.css'
/>");
out.println("</head>");
out.println("<body>");
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//con = DriverManager.getConnection("jdbc:odbc:dsn_customers","","");
java.util.Enumeration en = DriverManager.getDrivers();
while(en.hasMoreElements())
{
Driver s = (Driver) en.nextElement();
out.println("["+s.toString()+"]");
}
con = DriverManager.getConnection("jdbc:odbc:ex");
stmt = con.createStatement();
rs = stmt.executeQuery("SELECT * FROM [T_IND]");
out.println("<table><tr>");
out.println("<th>NAME</th>");
out.println("<th>STREET</th>");
out.println("<th>CITY</th>");
out.println("<th>STATE</th>");
out.println("<th>ZIP</th>");
out.println("<th>MYDATE</th>");
out.println("<th>SOURCE</th>");
out.println("<th>ETHNIC</th>");
out.println("<th>EMAIL</th>");
out.println("<th>PRIMID</th>");
out.println(" </tr><tr> ");
while (rs.next())
{
String sNAME = rs.getString("NAME");
String sSTREET = rs.getString("STREET");
String sCITY = rs.getString("CITY");
String sSTATE = rs.getString("STATE");
String sZIP = rs.getString("ZIP");
String sMYDATE = rs.getString("MYDATE");
String sSOURCE = rs.getString("SOURCE");
String sETHNIC = rs.getString("ETHNIC");
String sEMAIL = rs.getString("EMAIL");
String sPRIMID = rs.getString("PRIMID");
out.println(" <tr> ");
out.println("<td align=left>" + sNAME + "</td>");
out.println("<td align=left>" + sSTREET + "</td>");
out.println("<td align=left>" + sCITY + "</td>");
out.println("<td align=left>" + sSTATE + "</td>");
out.println("<td align=left>" + sZIP + "</td>");
out.println("<td align=left>" + sMYDATE + "</td>");
out.println("<td align=left>" + sSOURCE + "</td>");
out.println("<td align=left>" + sETHNIC + "</td>");
out.println("<td align=left>" + sEMAIL + "</td>");
out.println("<td align=left>" + sPRIMID + "</td>");
out.println("</tr>");
}
out.println("</table>");
out.println("</body></html>");
}
catch(SQLException e)
{
e.printStackTrace(out);
//out.println("SQL Error: "+ e.getMessage());
}
finally
{
try
{
if (con != null) con.close();
}
catch (SQLException ignored) { }
}
}
}
--------------------------------------------------------
check
whether driver is there in the class path used by webserver or not.
check whether u have registered the driver with Database Manger or
not in the init or static method.
Regards
sathya
-----Original Message-----
From: Mehmet Gurmen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 16, 2001 12:04 AM
To: [EMAIL PROTECTED]
Subject: ms access driver in a servlet
Hi all,
I have installed j2ee including Sun's web server on a win2K
professional.
I wrote a simple servlet that gets a resultset from an ms access 2000
database which I use the odbc-jdbc driver to connect to.
I included a main function into the servlet and the class seems to get
the
resultset when I run it within a command prompt. But when I call that as
a
servlet, it just puts into the error log "No Suitable Driver Found".
I do not think that there are any other drivers than that comes with the
j2ee form ms access. I have been developing server side applications
that
could easily connect to system dsn's but when it comes to the servlet I
get
this message. Does the servlet only accept SQL server in the dsn? Can't
I
use ms access database?
Thanks
________________________________________________________________________
___
To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
