Solved

compiler not finding:  OracleResultSet

Posted on 2001-08-15
10
1,043 Views
Last Modified: 2012-05-04
Hi all,

I am making the call below:        

Clob c = ((OracleResultSet) rs).getClob("TEXT");

and I get this error during compilation that OracleResultSet is not being found. what do i need to include in my classpath ?

thanks,
Johnny

0
Comment
Question by:xxxJohnnyBlaze
  • 6
  • 3
10 Comments
 
LVL 6

Expert Comment

by:kotan
ID: 6388438
Did you include the package of OracleResultSet?
0
 

Author Comment

by:xxxJohnnyBlaze
ID: 6388461
hi kotan,

i've included /jdbc/lib/classes111.zip.  is there a separate OracleResultSet package?

thanks
Johnny
0
 

Author Comment

by:xxxJohnnyBlaze
ID: 6388504
hi kotan,

i've included /jdbc/lib/classes111.zip.  is there a separate OracleResultSet package?

thanks
Johnny
0
 
LVL 19

Expert Comment

by:Jim Cakalic
ID: 6388517
You need to import oracle.jdbc.*, if memory serves, so that the OracleResultSet is visible in your code.

Best regards,
Jim Cakalic
0
 

Author Comment

by:xxxJohnnyBlaze
ID: 6388598
hi Jim Cakalic,

I imported oracle.jdbc.*
the compiler still can't find OracleResultSet.

thanks,
Johnny
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 19

Expert Comment

by:Jim Cakalic
ID: 6388632
Sorry, my memory _didn't_ serve me correctly. That should have been
    import 'oracle.jdbc.driver.*;

And, of course, the full path to classes111.zip (or classes12.zip) in the classpath.

Jim
0
 

Author Comment

by:xxxJohnnyBlaze
ID: 6388684
thanks for the help jim.  i was able to find the object. but then i get this error during compilation.
**** begin of error ***********
 The method oracle.jdbc2.Clob getClob(java.lang.String) declared in class oracle.jdbc.driver.OracleResultSet cannot override the method of the same signature declared in interface java.sql.ResultSet.  They must have the same return type.  

********  end of error ************

the same message appears for getBlob, getRef, getArray ...
it seems that there's method name conflict with java.sql.*

is there a way to take of this?

thanks,
Johnny
0
 

Author Comment

by:xxxJohnnyBlaze
ID: 6388722
Also,

I have my imports set up as this:

    import java.sql.Connection;
    import java.sql.ResultSet;
    import java.sql.Statement;
    import java.sql.PreparedStatement;
    import java.sql.SQLException;
    import oracle.sql.*;
    import oracle.jdbc.driver.*;
    import java.io.*;

now I get the error: that the compiler cannot find the Object "Clob"

Johnny
0
 
LVL 19

Accepted Solution

by:
Jim Cakalic earned 50 total points
ID: 6388895
First the compilation error. The conventional wisdom seems to be that there were some problems related to LOBs in early editions of the jdbc drivers. Several comments I have read indicate that using the latest edition (8.1.7) of the drivers will solve this. Oracle maintains excellent backwards compatibility so this shouldn't be a problem. The OTN download page links are wrong. Go directly to
    http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html

Also, is it necessary for you to use classes111.zip? This is for JDK 1.1.x environments. If you are using a Java 2 environment, you would be better served to download the drivers for Java 2 and use classes12.zip. Once you have the drivers, you can just drop the classes12.zip file in your lib directory and change the classpath.

As for your other problem, the Oracle javadoc seems to 'randomly' refer to oracle.jdbc2.Clob and oracle.sql.CLOB. I've looked through the driver classes and cannot find an oracle.jdbc2.Clob. I'm assuming that it is an old reference which hasn't been fixed in the javadoc. The class you want is oracle.sql.CLOB. Note that it is 'CLOB' and not 'Clob' -- all uppercase.

Hope this helps.
Jim
0
 

Author Comment

by:xxxJohnnyBlaze
ID: 6390318
thanks for all the help Jim.

oracle docs were very deceiving.  i finally had to create a work around.

thanks,
Johnny
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
groupNoAdj 7 83
base64 decode encode 12 119
printing a file in reverse order is easy in recursion rather than in iteration 3 48
windows explorer path to command prompt 5 27
Are you developing a Java application and want to create Excel Spreadsheets? You have come to the right place, this article will describe how you can create Excel Spreadsheets from a Java Application. For the purposes of this article, I will be u…
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
Viewers learn about the “while” loop and how to utilize it correctly in Java. Additionally, viewers begin exploring how to include conditional statements within a while loop and avoid an endless loop. Define While Loop: Basic Example: Explanatio…
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.

947 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now