[jdjlist] RE: Issue with weblogic6.1

[Himanshu Goel]

Hi Rathna,
It seems you are using Weblogic's connection pool to connect to Oracle. We
also faced the similar problem while accessing CLOB and BLOB's from database
using Weblogic connection pool.
Try using oracle's DriverManager classes (included in classes12.zip) to
connnect to oracle directly and then execute the same statements, see
whether this error is coming or not.

regards
himanshu 

-----Original Message-----
From: Rathna [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 4:39 PM
To: JDJList
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