You might want to try using the Thin Drivers instead of the OCI-based
drivers.
Paul Franz
----- Original Message -----
From: "Rathna" <[EMAIL PROTECTED]>
To: "JDJList" <[EMAIL PROTECTED]>
Sent: Friday, August 16, 2002 7:09 AM
Subject: [jdjlist] Issue with weblogic6.1
> Hi all,
>
> I have problem in reading CLOB type from Oracle database. I am using
> WebLogic 6.1..and sql API I am getting the following error.
>
> SQLException : ORA-03115: unsupported network datatype or representation
>
> Start server side stack trace:
> java.sql.SQLException: ORA-03115: unsupported network datatype or
> representati
>
> at weblogic.db.oci.OciCursor.getCDAException(OciCursor.java:240)
> at weblogic.jdbc.oci.Statement.executeQuery(Statement.java:208)
> at weblogic.jdbc.pool.Statement.executeQuery(Statement.java:850)
> at
> weblogic.jdbc.rmi.internal.StatementImpl.executeQuery(StatementImpl
> ava:79)
> at
> weblogic.jdbc.rmi.internal.StatementImpl_WLSkel.invoke(Unknown
> Sour
> )
> at
> weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:305
> at
> weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.j
> a:274)
> at
> weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteReque
> java:22)
> at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
> at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
> End server side stack trace
>
> import java.sql.*;
> import java.sql.Date;
> public class CLOBRead extends DBConnection {
> public static void main( String args[] ) {
> CLOBRead cr = new CLOBRead();
> cr.getCLOB();
> }
>
> public void getCLOB() {
> getDBConnection(); // do the database connection
> ResultSet results = null;
> Statement stmt = null;
> PreparedStatement psmt = null;
> try {
> String sqlText = "SELECT OLD_TEXT FROM AMEND_TEXT"; //
> OLD_TEXT is the CLOB type
> stmt = m_connection.createStatement();
> results = stmt.executeQuery(sqlText);
> } catch (SQLException sqle) {
> System.out.println( "SQLException : " + sqle.getMessage() );
> } finally {
> try {
> if (results != null) results.close();
> if (stmt != null) stmt.close();
> } catch (SQLException sqlex ) {}
> closeDBConnection();
> }
> }
> }
>
> Could somebody through light on this as how to get rid of the problem.
>
> Thanks and Regards,
> Rathna
>
>
----------------------------------------------------------------------------
----
> To change your membership options, refer to:
> http://www.sys-con.com/java/list.cfm
>
To change your membership options, refer to:
http://www.sys-con.com/java/list.cfm
