Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: neutral (nike.apache.org: local policy)
Message-ID: <4DA87756.9010400@att.net>
Date: Fri, 15 Apr 2011 12:50:30 -0400
From: Jeff Hubbs <jhubbslist@att.net>
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US;
 rv:1.9.2.15) Gecko/20110303 Thunderbird/3.1.9
MIME-Version: 1.0
To: Tomcat Users List <users@tomcat.apache.org>
Subject: Re: Working of Tomcat with MS Access
References: <BANLkTin9tuNXRp8jeAx-nztLoLjpQYdTEA@mail.gmail.com>
 <8CDC99A43BAA16B-177C-A63E@webmail-m051.sysops.aol.com>
In-Reply-To: <8CDC99A43BAA16B-177C-A63E@webmail-m051.sysops.aol.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

MySQL is indeed another good Open Source RDBMS; I would not call it 
"lightweight" in that it is used to power some mighty big Web apps, but 
the implementation does seem a little quaint.

On 4/15/11 11:38 AM, Troy 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<omrahulrajcse@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-unsubscribe@tomcat.apache.org
>
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
>
>
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org