Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Problem reading LONG Column using jdbc thin driver

Problem reading LONG Column using jdbc thin driver

From: <afrancis_at_my-dejanews.com>
Date: Thu, 25 Feb 1999 20:46:04 GMT
Message-ID: <7b4cq9$hjh$1@nnrp1.dejanews.com>


hi,

I'm trying to grab a LONG column off an oracle 8.x database. I've got the most recent jdbc from the oracle site, I'm using the thin driver. Is there a problem accessing this?

I'm trying to read it off the database, turn it into a string (it will be one long token).

         So after I do a select I then:

   while (rset.next()) {

       InputStream stream_var = rset.getAsciiStream ("COLUMN_NAME");
       Reader r = new BufferedReader (new InputStreamReader(stream_var));
       StreamTokenizer st = new StreamTokenizer(r);
       string_var = st.sval;
       System.out.println(string_var);

the printed line just returns: null But there is text in the LONG column, and when I was testing and using a varchar field type every thing worked.

So, I wondering what I'm doing wrong, or if the oracle thin driver has any problems with LONG (Note: not to be confused with the long integer type in java)

Any help appreciated. I'm pretty new to this so please, include details! Thanks in advance

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 25 1999 - 14:46:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US