?
Solved

Accessinf Sybase ASE 11.0.3.3 from a JSP Page

Posted on 2002-03-06
10
Medium Priority
?
236 Views
Last Modified: 2008-02-01
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
0
Comment
Question by:chaiti_c
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
10 Comments
 
LVL 6

Expert Comment

by:kotan
ID: 6846502
where do you reside the com.sybase.jdbc2.jdbc.SybDriver package?

Dose it exist in {tomcat path}/webapps/{appname}/WEB-INF/lib/ ?
0
 

Author Comment

by:chaiti_c
ID: 6849547
I have loaded copied jConnect5-5 under root . I have set the path in the the CLASSPATH as well.
0
 
LVL 6

Expert Comment

by:kotan
ID: 6849567
So strange put it under root. Can you try to put it under the path I suggested?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:chaiti_c
ID: 6849632
Yes the entire directory is under root. I cannot put the files directly under /
0
 
LVL 6

Expert Comment

by:kotan
ID: 6849968
put the jConnect5-5.zip in
  {tomcat path}/webapps/{appname}/WEB-INF/lib/
0
 

Author Comment

by:chaiti_c
ID: 6852277
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
 
LVL 6

Expert Comment

by:kotan
ID: 6855045
No need the directory jConnect5-5, put the zip under ../lib/.
0
 

Author Comment

by:chaiti_c
ID: 6855925
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
 
LVL 6

Expert Comment

by:kotan
ID: 6855964
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
 
LVL 6

Accepted Solution

by:
kotan earned 1200 total points
ID: 6855965
Remmeber to restart your tomcat server to take effect.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

WooCommerce is becoming the most powerful e-commerce plugin for Wordpress. And why not. The platform comprises of numerous core plugins that may come in handy, powerful options to make your website development task much easier.
It’s time for spooky stories and consuming way too much sugar, including the many treats we’ve whipped for you in the world of tech. Check it out!
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question