Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Problem reading LONG Column using jdbc thin driver
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