Friends I'm using Rational application developer 7.0 and db2express c. I connected the database in RAD using new data connection wizard. I imported db2jcc.jar file too. I'm using Websphere application server community edition.
But while running the page this error displayed in every page.
ERROR : COM.ibm.db2.jcc.DB2Driver
I built the path too. My coding is as follows
<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" %>
<%
try
{
Class.forName("COM.ibm.db2.jcc.DB2Driver");
Connection con = DriverManager.getConnection("jdbc:db2:d1");
String username,password,usertype,query;
ResultSet rs=null;
PreparedStatement ps=null;
username = request.getParameter("username");
password=request.getParameter("password");
usertype=request.getParameter("usertype");
query="select * from login where username='"username"'and usertype="usertype"";
ps=con.prepareStatement(query);
rs=ps.executeQuery();
if (rs.next())
{
if (rs.getString("password").equals(password))
{
session.setAttribute("userid", rs.getString("userid"));
session.setAttribute("usertype", rs.getString("usertype"));
session.setAttribute("loginstatus", "1");
if(rs.getString("userid").equals("0"))
{
%>
<jsp:forward page="adminhome.jsp"></jsp:forward>
<%
}
if(rs.getString("usertype").equals("2"))
{
String query1="select designation from emp_work_profile where userid="session.getAttribute("userid")"";
ResultSet rs1=null;
PreparedStatement ps1=null;
ps1=con.prepareStatement(query1);
rs1=ps1.executeQuery();
while(rs1.next())
{
session.setAttribute("empdesig",rs1.getString("des ignation"));
if(rs1.getString("designation").equals("6")||rs1.g etString("designation").equals("7"))
{
%>
<jsp:forward page="ration/rationhome.jsp"></jsp:forward>
<%
}
else {%>
<jsp:forward page="employee/employeehome.jsp"></jsp:forward>
<% }
}
}
if(rs.getString("usertype").equals("1")) {
%>
<jsp:forward page="citizenhome.jsp"></jsp:forward>
<%}
if(rs.getString("usertype").equals("3")) {
%>
<jsp:forward page="hospital/hospital_main.jsp"></jsp:forward>
<%}
if(rs.getString("usertype").equals("4")) {
%>
<jsp:forward page="schoolhome.jsp"></jsp:forward>
<%}
}
else
{
%>
<jsp:forward page="wronguser.jsp"></jsp:forward>
<%
}
}
else
{
%><jsp:forward page="wronguser.jsp"></jsp:forward><%
}
con.close();
}
catch(Exception e)
{
out.println("Error "+e.getMessage());
}
%>
Please solve this error. i'll be thankful to you all