There is a 4K restriction. Oracle has created extension classes
(oracle.sql.BLOB, oracle.sql.CLOB) with
methods to write data to BLOBs.
--
Terry Dykstra
Canadian Forest Oil Ltd.
"D.Y." <dyou98_at_aol.com> wrote in message
news:f369a0eb.0302142032.6a86a78e_at_posting.google.com...
> I am not sure if Oracle implemented LOB APIs in the Thin Driver in 9i. If
I
> have to guess I'd say no because performance would have been horrible.
>
> You can always access LOBs using the JDBC OCI driver. You would have to
create
> a separate, dedicated connection for the LOB streams. There are some good
code
> examples in JDBC Developer's Guide.
>
>
> "Chris Gokey" <cgokey_at_gcmd.nasa.gov> wrote in message
news:<pan.2003.02.14.23.26.56.253111_at_gcmd.nasa.gov>...
> > Hi everyone,
> >
> > Here is my specs to give some context:
> >
> > Oracle 9.2.0
> > Redhat 8.0
> > java version "1.4.1_01"
> > JDBC Thin Driver (ojdbc.jar, latest off the web site)
> >
> > I tried storing/retrieving data from Oracle using CLOBs and it looks
like
> > this will not work. Attached is a short example of storing data
> > to a CLOB and later retrieving it. Here is the sample table that I
> > created:
> >
> > create table test (summary CLOB);
> >
> > And here is the error I received:
> >
> > ----------------
> >
> > [cgokey_at_cgokey cgokey]$ java md.clients.Test Exception in thread "main"
> > java.sql.SQLException: Io exception: Connection reset at
> > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
> > at
> > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
> > at
> > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
> > at
> >
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2061
)
> > at
> >
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
> > at
> >
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:2709)
> > at
> >
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
ment.java:589)
> > at md.clients.Test.main(Test.java:33)
> >
> > ----------------
> >
> > I'm trying to store the CLOB using:
> > st.setCharacterStream(1,new
StringReader(summary),summary.length());
> > st.executeUpdate();
> >
> > I think this is the right way to do it. I've been told it is also
> > possible to do this with stored procedures, but I'd like to keep my code
> > as database independant as possible and use the method above or some
> > slight variation where I don't have to cast to Oracle classes.
> >
> > I read somewhere the CLOBS are supported now under the latest Oracle
thin
> > driver, am I doing something wrong?
> >
> > Is there any other data type in Oracle that can store text (<100,000
> > characters) besides CLOB and LONG. The LONG datatype will not work
> > for me because I have a table with more than one column with LONG.
> >
> > Any help would be greatly appreciated :)
> >
> > Chris
Received on Sat Feb 15 2003 - 14:40:31 CST
