ww.klgsystel.com>
-Original Message-
From: A mailing list about Java Server Pages specification and reference
[mailto:[EMAIL PROTECTED]]On Behalf Of Hitesh panchal
Sent: Thursday, June 15, 2000 8:36 PM
To: [EMAIL PROTECTED]
Subject: Re: [SQL question for long data type]
helen ge <[EMA
Hi Helen,
import oracle.sql.*;
...
BLOB blob = ((OracleResultSet)rs).getBLOB ("body");
CLOB clob = ((OracleResultSet)rs).getCLOB ("body");
...
file://read
Reader instream = clob.getCharacterStream();
InputStream instream = blob.getBinaryStream();
...
file://write
Writer outstream = clob.getCharac
Sounds like a problem with the statement itself, not the retrieval of value.
What is the actual select statement?
-Original Message-
From: helen ge [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 15, 2000 10:42 AM
To: [EMAIL PROTECTED]
Subject: Re: SQL question for long data type
SQLException "ORA-00997 illegal use of Long data type"
>From: Joe Milora <[EMAIL PROTECTED]>
>Reply-To: A mailing list about Java Server Pages specification and
> reference <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: SQL question for long da
rs.getString and (String)rs.getObject should work. What is the error you're
receiving?
-Original Message-
From: Rob van Oostrum [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 15, 2000 9:39 AM
To: [EMAIL PROTECTED]
Subject: Re: SQL question for long data type
are you sure the po
are you sure the pointer is not at a row that has no value for that column?
> -Original Message-
> I have an oracle table which has a long data type field named body.
> in my java code I created a SQL and try to get that long field througn
> ResultSet and print it out as a String.
>
>
> S
The long datatype in Oracle is way different from the Java long. A Long in
Oracle is a
Character string of upto 2GB in length. There are specialized methods for
getting this out - See Oracle documentation of the JDBC driver
-Original Message-
From: helen ge [mailto:[EMAIL PROTECTED]]
Sent
helen ge <[EMAIL PROTECTED]> wrote:
Hi,
may be this is a simple question, but I stucked here.
I have an oracle table which has a long data type field named body.
in my java code I created a SQL and try to get that long field througn
ResultSet and print it out as a String.
String body = rs.getSt
http://technet.oracle.com/doc/java.815/a64685/basic4.htm#1002507
-Original Message-
From: helen ge [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 15, 2000 10:26 AM
To: [EMAIL PROTECTED]
Subject: SQL question for long data type
Hi,
may be this is a simple question, but I stucked here.
