Accessinf Sybase ASE 11.0.3.3 from a JSP Page

My JSP is on Linux Redhat7.1 and the RDBMS is SybaseASE 11.0.3.3. I have Jakarta Tomcat running and and copied the jconnect5-5. I am trying to access a Sybase database from an JSP page and am getting the following error-
Error :  java.lang.ClassNotFoundException: Unable to load class com.sybase.jdbc2.jdbc.SybDriver

The code is as follows-

<html>
<head>
<title>
testinf JSPPage
</title>
</head>
<body>
<%!String username = "sa";
 String password = "";%>
<%
  try
    {     Class.forName("com.sybase.jdbc2.jdbc.SybDriver");
     java.sql.Connection con = java.sql.DriverManager.getConnection("jdbc:sybase:Tds:localhost:7101",username,password);
     java.sql.Statement stmt = con.createStatement();
     java.sql.ResultSet rs = stmt.executeQuery("SELECT * from javatest ");
%>
<table >
<%
       while (rs.next())
      {                        %>
<tr>
<td>
<%=rs.getString()%>
</td>
</tr>
 <%          
}  
   }     catch(Exception e)
      {%>
<b>Error : </b>
      <%= e.toString() %>
<%      }%>
</table>

</table>
</body>
</html>

Do I have to do other setup changes etc???
Pls. help
Regards
Chaitali
chaiti_cAsked:
Who is Participating?
 
kotanConnect With a Mentor Commented:
Remmeber to restart your tomcat server to take effect.
0
 
kotanCommented:
where do you reside the com.sybase.jdbc2.jdbc.SybDriver package?

Dose it exist in {tomcat path}/webapps/{appname}/WEB-INF/lib/ ?
0
 
chaiti_cAuthor Commented:
I have loaded copied jConnect5-5 under root . I have set the path in the the CLASSPATH as well.
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
kotanCommented:
So strange put it under root. Can you try to put it under the path I suggested?
0
 
chaiti_cAuthor Commented:
Yes the entire directory is under root. I cannot put the files directly under /
0
 
kotanCommented:
put the jConnect5-5.zip in
  {tomcat path}/webapps/{appname}/WEB-INF/lib/
0
 
chaiti_cAuthor Commented:
I have just done it this way- i copied the files form the zip into a directory called jConnect5-5 under /jakarta_tomact/webapps/{appname}/WEB-INF/lib/ bit it is still giving the same error. Do I have to specify the paths anywhere else other than the .bash_profile
0
 
kotanCommented:
No need the directory jConnect5-5, put the zip under ../lib/.
0
 
chaiti_cAuthor Commented:
Yes I have done that now.
Is any other configuration required for this. What if i put it in a class file and then access that file ?? If I have to access a class file do I need further configuration changes. I have changed it and have put the entire stuff in a java file which is getting compiled now I am trying to access this class but then also I am getting error
0
 
kotanCommented:
Sorry, I have made some mistake.
I have download the jConnect-5_5.zip and unzip it. I saw it there is a jar file call "jconn2.jar" under ../jConnect-5_5.zip/classes. This jar file consist of all the jdbc classes.

This is the jar file you need to locate at the
  {tomcat_dir}/webapps/{webapploc}/WEB-INF/lib/

or you may put under

  {tomcat_dir}/lib/
which is accessible to all web application.

Tell me does it work.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.