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
