Re: CLOBS work with thin driver?

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(OraclePreparedStatement.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 Fri Feb 14 2003 - 22:32:37 CST