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
**************************Disclaimer************************************
Information contained in this E-MAIL being proprietary to Wipro Limited is
'privileged' and 'confidential' and intended for use only by the individual
or entity to which it is addressed. You are notified that any use, copying
or dissemination of the information contained in the E-MAIL in any manner
whatsoever is strictly prohibited.
***************************************************************************
To change your membership options, refer to:
http://www.sys-con.com/java/list.cfm
