Yes of course...I did the same...then what to do with this error? Remember
that Now I am working in ACCESS. code is not much different...

On Sat, Apr 16, 2011 at 12:10 AM, Troy <troylparr...@aol.com> wrote:

> I believe the drivers should be located in: YourApp/WEB-INF/lib/
>
>
> Troy
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: RAHUL RAJ <omrahulraj...@gmail.com>
> To: Tomcat Users List <users@tomcat.apache.org>
> Sent: Fri, Apr 15, 2011 2:35 pm
> Subject: Re: Working of Tomcat with MS Access
>
>
> Thank you very much for your help! When I did with mysql, the corresponding
>
> jdbc driver is stored in /webapps/ROOT/lib directory in tomcat.
>
>
>
> On Fri, Apr 15, 2011 at 11:56 PM, Troy <troylparr...@aol.com> wrote:
>
>
>
> > I wrote a quick little jsp to access one of my db (a mysql)
>
> >
>
> >
>
> > <%@page contentType="text/html" pageEncoding="UTF-8"%>
>
> > <%@page import="java.sql.*" %>
>
> > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
>
> >   "http://www.w3.org/TR/html4/loose.dtd";>
>
> >
>
> > <html>
>
> >    <head>
>
> >        <meta http-equiv="Content-Type" content="text/html;
> charset=UTF-8">
>
> >        <title>Test Connection</title>
>
> >    </head>
>
> >    <body>
>
> >
>
> >        <%
>
> >        String name = "";
>
> >        Class.forName("com.mysql.jdbc.Driver");
>
> >        Connection conn =
>
> > DriverManager.getConnection("jdbc:mysql://localhost/dbName", "XXXX",
>
> > "XXXXXX");
>
> >        Statement stmt = conn.createStatement();
>
> >        String query = "select * from friends where id='1'";
>
> >        ResultSet rs = stmt.executeQuery(query);
>
> >        while(rs.next()){
>
> >         name = rs.getString(3);
>
> >        }
>
> >
>
> > %>
>
> >
>
> > <%= name %>
>
> >
>
> >    </body>
>
> > </html>
>
> >
>
> > Worked like expected.  I know this is not a java thread . . . but still
>
> > trying to help since it is a time sensitive matter.
>
> > Silly question, but are your jdbc drivers added to your library for the
> web
>
> > app?  I make this mistake ALL the time.
>
> >
>
> > Troy
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> > -----Original Message-----
>
> > From: RAHUL RAJ <omrahulraj...@gmail.com>
>
> > To: Tomcat Users List <users@tomcat.apache.org>
>
> > Sent: Fri, Apr 15, 2011 1:59 pm
>
> > Subject: Re: Working of Tomcat with MS Access
>
> >
>
> >
>
> > ya...I did the same thing  you told in mysql...but communications
> Exception
>
> >
>
> > occured..
>
> >
>
> > This is like a small assignment that has to be submitted urgently..so I
>
> > have
>
> >
>
> > to run away from the error! and tried with MS ACCESS.
>
> >
>
> > The jdbc program for access works perfect alone..
>
> >
>
> >
>
> >
>
> > On Fri, Apr 15, 2011 at 11:19 PM, Troy <troylparr...@aol.com> wrote:
>
> >
>
> >
>
> >
>
> > > Raj,
>
> >
>
> > >
>
> >
>
> > > I think everyone is saying to take a look at this syntax:
>
> >
>
> > >
>
> >
>
> > >
>
> >
>
> > > >String url = "jdbc:odbc:rahul";
>
> >
>
> > > >                Connection con = DriverManager.getConnection(url, "",
>
> > "");
>
> >
>
> > >
>
> >
>
> > >
>
> >
>
> > > I know that when I make this type of simple jdbc connection in mysql
> the
>
> >
>
> > > syntax is:
>
> >
>
> > >
>
> >
>
> > > String url = "jdbc:mysql://localhost/dbName";
>
> >
>
> > > Connection conn = DriverManager.getConnection(url, "", "");
>
> >
>
> > >
>
> >
>
> > > Troy
>
> >
>
> > >
>
> >
>
> > >
>
> >
>
> > >
>
> >
>
> > >
>
> >
>
> > >
>
> >
>
> > >
>
> >
>
> > >
>
> >
>
> > >
>
> >
>
> > >
>
> >
>
> > >
>
> >
>
> > > -----Original Message-----
>
> >
>
> > > From: RAHUL RAJ <omrahulraj...@gmail.com>
>
> >
>
> > > To: Tomcat Users List <users@tomcat.apache.org>
>
> >
>
> > > Sent: Fri, Apr 15, 2011 1:31 pm
>
> >
>
> > > Subject: Re: Working of Tomcat with MS Access
>
> >
>
> > >
>
> >
>
> > >
>
> >
>
> > > I got communications exception when I did this with mysql...and no one
>
> >
>
> > > knows
>
> >
>
> > >
>
> >
>
> > > the reason perfectly...no response from mysql forum too...
>
> >
>
> > >
>
> >
>
> > >
>
> >
>
> > >
>
> >
>
> > > On Fri, Apr 15, 2011 at 9:08 PM, Troy <troylparr...@aol.com> wrote:
>
> >
>
> > >
>
> >
>
> > >
>
> >
>
> > >
>
> >
>
> > > > Raj;
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > > To all reading this response, this is my first response on this list
> so
>
> >
>
> > > if
>
> >
>
> > >
>
> >
>
> > > > I get it a little wrong have patience.
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > > You may want to look at the light weight RDBMS mysql.  It is free,
>
> > easily
>
> >
>
> > >
>
> >
>
> > > > installed and can be utilized with the companion Workbench to make
>
> >
>
> > > dealing
>
> >
>
> > >
>
> >
>
> > > > with the db very easy, a lot like the access interface.  You will
> have
>
> >
>
> > > good
>
> >
>
> > >
>
> >
>
> > > > driver support from the java end as well and a lot of documentation
> and
>
> >
>
> > >
>
> >
>
> > > > tutorials to get you connected in your web app to your persistence
>
> > layer.
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > > mysql.com
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > > Just my two cents and an attempt to give back a little to the
>
> > community.
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > > Troy
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > > -----Original Message-----
>
> >
>
> > >
>
> >
>
> > > > From: RAHUL RAJ <omrahulraj...@gmail.com>
>
> >
>
> > >
>
> >
>
> > > > To: users <users@tomcat.apache.org>
>
> >
>
> > >
>
> >
>
> > > > Sent: Fri, Apr 15, 2011 6:05 am
>
> >
>
> > >
>
> >
>
> > > > Subject: Working of Tomcat with MS Access
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > > Hello,
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >     I am working on  building a jsp website with MS Access as
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > > database. When my login page is loaded on tomcat
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > > (localhost:8080/login.jsp), it shows the following error:
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > > java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > > name not found and no default driver specified.
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > > The jdbc program alone is working perfectly, So There might not be
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > > problems due to  Driver, Data source name, Database Tables or any
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > > other software version compatibilities.
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > > OS: Windows Vista Home Basic
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > > Tomcat Version: 5.5.x
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > > jdk version: 1.6
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > > MS Access 2010
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > > code is given below:
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > > <%@ page language="java" import="java.sql.*" %>
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >  <html>
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >  <body>
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >  <form method="post">
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >  <p> Enter your username :  <input type="text" name="username"/> </p>
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >  <p> Enter your password :  <input type="text" name="password"/> </p>
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >  <input type="submit" value="Login"/>
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >  <%
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >    String usn = request.getParameter("username");
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >        String pass = request.getParameter("password");
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >        try{
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >                 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >                 String url = "jdbc:odbc:rahul";
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >                 Connection con = DriverManager.getConnection(url, "",
>
> >
>
> > > "");
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >                 Statement s = con.createStatement();
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >                 ResultSet rs = s.executeQuery("select * from
>
> > customers");
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >                 while(rs.next())
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >                 {
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >                   String u = rs.getString(1);
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >                   String p = rs.getString(2);
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >                   if(usn.equals(u) && pass.equals(p))
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >                   {
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >                      out.println("login successfull");
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >                          }
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >                   else
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >           {
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >              out.println("login failed");
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >             }
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >           }
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >        }
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >                catch(Exception e)
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >                {
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >                   out.println("Error"+e);
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >                   }
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >  %>
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >  </form>
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >  </body>
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >  </html>
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > > ---------------------------------------------------------------------
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > > For additional commands, e-mail: users-h...@tomcat.apache.org
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > > >
>
> >
>
> > >
>
> >
>
> > >
>
> >
>
> > >
>
> >
>
> > >
>
> >
>
> >
>
> >
>
> >
>
>
>
>

Reply via email to