Jeff has some really good points here, Rahul. I'm a guy who spent several years doing ASP development with both MS Access and SQL Server over the web before getting into Java. Even still, I didn't fathom trying to mess with MS Access with Java when I was making that transition. I started with mySQL on my Windows desktop to get started, but when I got access to our Oracle servers, went that route.
Like Jeff says, you can do this basically for no cost using both Tomcat and mySQL. Sure, it's command line, unlike MS Access, but you shouldn't have too much trouble with it. Jeff, if he's using MS Access, he's probably not on Linux, is he? -----Original Message----- From: Jeff Hubbs [mailto:jhubbsl...@att.net] Sent: Friday, April 15, 2011 12:46 PM To: Tomcat Users List Subject: Re: Working of Tomcat with MS Access A beginner needs to at least begin with workable platforms and software. PostgreSQL on Linux has a total software license cost of $0.00; your barrier to entry with inappropriate software is considerably higher. On 4/15/11 1:35 PM, RAHUL RAJ wrote: > Since I am a beginner, I have to start with some trial projects, > right? I know this is nothing! and help me...pls answer to the "question.". > > On Fri, Apr 15, 2011 at 8:41 PM, Jeff Hubbs<jhubbsl...@att.net> wrote: > >> You do realize, I hope, that what you're proposing is akin to >> sourcing parts for your jet engine from Fisher-Price? >> >> IMHO MS Access is not and never has been useful as a professional >> database product. I'm not even sure if what you are proposing even >> holds up in the looking-through-binoculars-from-the-big-end sense. >> >> MS Access is a desktop application that accesses files on disk. Java >> apps running on Tomcat typically access an RDBMS over a network >> connection via SQL statements and their responses. AFAIK there is >> not a "server instantiation" of MS Access; in fact, part of the whole >> point of MS Access as an ongoing product is that it acts as a >> "gateway drug" to MS' SQL Server product, the transition to which >> would be triggered by the inherent limitations (and, in my past >> experience, persistent unaddressed bugs) of Access. >> >> I think you need to back up a bit and work toward getting your data >> liberated from MS Access and ported into a proper RDBMS like >> PostgreSQL or one of MS SQL Server, Oracle, IBM DB2, etc. if you feel >> that money must be continually spent on software licenses for such. >> Then you will be facing Java apps and Tomcat in a far more conventional way. >> >> So, to sum up this and earlier responses: 1) Learn to code Java 2) >> Understand real RDBMSses. >> >> - Jeff >> >> >> On 4/15/11 6:04 AM, RAHUL RAJ wrote: >> >>> 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 >>> >>> >>> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org >> For additional commands, e-mail: users-h...@tomcat.apache.org >> >> --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
