CLOB is hosing me!

[Tom Jackson]

Hi:

I have a Java application running on an HPUX 11i WebSphere application server and I can't get a result set back when I request CLOB data type. I get the error:

"Exception: java.sql.SQLException: ORA-03115: unsupported network datatype or representation"

when I do my statement.executeQuery(sqlString). I'm running the thin driver. I make several other sql queries in other parts of my application and they work fine. It's just the request for CLOB that causes a problem. I can change the sql so that it doesn't select the CLOB data and the call works fine.

I've done some reading about the OCI8 driver, and upgrading. Where can I get the OCI8 driver that will run on my HPUX box and how do I install it?

I'm migrating this application from an old Linux PC. The Oracle 8.0.5 database runs on an NT box.

Tom :-(

[harry d brown jr]

http://www.orafaq.com/faqjdbc.htm#OCI

live free or die
harry

[Steve Steel]

Hi

http://forums.java.sun.com/thread.jsp?thread=85882&forum=48&message=221023

http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a88879/adl03p10.htm

http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a88879/adl06fa6.htm

Good Luck


Steve Steel

[Tom Jackson]

Hi:

FIXED IT!

Tried to install Oracle 9.0.1 client on my HP web server, but it failed. However, it did load several files on my workstation including /bla/bla/OraHome/jdbc/lib/classes111.jar. I imported this file into my web application lib directory in place of the 8.0.5 classes111.zip file and the statement.executeQuery(sqlString) call worked without generating an exception! It also returned the clob of data I was thirsting for!:-)

I also had to change the java code. In my code, the previous definition of the variable clob was:
oracle.jdbc.driver.OracleClob clob = null;

With the new jar file the define is as follows:

oracle.jdbc2.Clob clob = null;

Thanks for the links Larry and Steve.

Tom