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">&nbsp;
<P align="center">&nbsp;
<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">&nbsp;</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&nbsp;</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&nbsp;</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">&nbsp;&nbsp;&nbsp;&nbsp;
  If new user&nbsp;&nbsp;&nbsp; <a href="registration_form.htm">Sign
  up</a></font></p>

  <p align="center"><b><font color="#008000" size="3" face="Bookman Old Style">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
   <input type="submit" value="    Go   " name="submit"></span>&nbsp;
  <input type="reset" value="Reset" name="reset">
  </span>
  </font></b></p>
  <p align="center">&nbsp;</p>

  <p align="center">&nbsp;</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.

Edited 3 Years Ago by pyTony: fixed formatting

Please don't abuse power and beauty of JAVA, scriplets are no place for setting connection to database. Use servlet...

This article has been dead for over six months. Start a new discussion instead.