i am using tomcat 5.5,but i am unable to connect to database
<HTML>
<HEAD>
<TITLE> </TITLE>
</HEAD>
<BODY bgcolor="#8D9BCA" text="#333300" marginheight="0" marginwidth="0">
<center>
<!-- row 2 -->
<table height="1" width="381">
<td height="1" width="373">
<P align="center">
<P align="center">
<p align="center"><span style="letter-spacing: 1pt"><b><font size="3" face="Bookman Old Style">Login
Form for Clients</font></b></span></p>
<p align="center"> </p>
<form action="clientcheck.jsp" method="POST">
<div align="center">
<table border="0" width="50%" cellspacing="5" cellpadding="5" height="80">
<tr>
<td width="33%" align="center" height="25">
<p align="center"><font size="3" face="Bookman Old Style">Client ID </font></p>
</td>
<td width="33%" height="25">
<p align="center"><font size="3" face="Bookman Old Style"><input type="text" name="client_id" size="20"></font></p>
</td </tr>
<tr>
<td width="33%" align="center" height="23">
<p align="center"><font size="3" face="Bookman Old Style">Password </font></p>
</td>
<td width="33%" height="23">
<p align="center"><font size="3" face="Bookman Old Style"><input type="password" name="client_password" size="20"></font></p>
</td>
</tr>
</table>
</div>
<p align="center"><font size="3" face="Bookman Old Style">
If new user <a href="registration_form.htm">Sign
up</a></font></p>
<p align="center"><b><font color="#008000" size="3" face="Bookman Old Style">
<input type="submit" value=" Go " name="submit"></span>
<input type="reset" value="Reset" name="reset">
</span>
</font></b></p>
<p align="center"> </p>
<p align="center"> </p>
</form>
</td>
</table>
</center>
</BODY>
</html>
clientcheck.jsp
<%@ page import="java.sql.*" %>
<html>
<BODY bgcolor="#8D9BCA" text="#333300" marginheight="0" marginwidth="0">
<%
//Context ctx=null;
ResultSet rs;
Connection con;
Statement st;
String clientid;
String password;
int arraylen;
clientid=request.getParameter("client_id");
password=request.getParameter("client_password");
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:Nikki","","");
st = con.createStatement();
rs=st.executeQuery("select * from clientlogin ");
//rs = st.getResultSet();
while(rs.next()){
String clientid1= rs.getString("client_id");
String pwd1=rs.getString("password");
if((clientid.equals(clientid1))&&(password.equals(pwd1)))
{
session.setAttribute("CLIENT_ID",clientid);
out.println(clientid);
}
}
}
catch(Exception e)
{
out.println(e.toString());
}
%>
</body>
</html>
i created dsn name correctly.After i open browser http://localhost:8080/login/clientlogin.html
it is excuted & sent to next page but i am getting error
SQL EXCEPTION:GeneralError
for tomcat do i need to install jsdk and do i need to create war file plz tell me how to create war file.
