Solved

Accessinf Sybase ASE 11.0.3.3 from a JSP Page

Posted on 2002-03-06
10
231 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
Technology Partners: 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 300 total points
ID: 6855965
Remmeber to restart your tomcat server to take effect.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

The conference as a whole was very interesting, although if one has to make a choice between this one and some others, you may want to check out the others.  This conference is aimed mainly at government agencies.  So it addresses the various compli…
We take a look at some of the most common obstacles that IT teams run into as they work relentlessly to keep all the alarms and sirens from going off at once.
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

717 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