Member Avatar for aruna_k_2006

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 by TrustyTony because: fixed formatting
  • 3 Contributors
  • 3 Replies
  • 91 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by aruna_k_2006

Recommended Answers

All 3 Replies

Member Avatar for peter_budo

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

Member Avatar for jwenting

and don't use the bridgedriver.

Member Avatar for aruna_k_2006

thank u 4 ur suggestions.i will write in servlet

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.