Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004

    Unanswered: ORA-03115: unsupported network datatype or representation error

    Hi All,

    I have following code in DAO layer
    Connection conn = factory.createConnection();
    String sql = "SELECT group_id FROM " + this.GROUP_TABLE + " WHERE disabled = 'T' AND UPPER(group_name) = ? AND agency_id = ?";
    PreparedStatement pstmt = conn.prepareStatement(sql);
    pstmt.setString(1, groupName.trim().toUpperCase());
    pstmt.setInt(2, agencyId);
    rs = pstmt.executeQuery(sql);
    when I execute this code I am getting ORA-03115 error.

    If I change sql statement to simple
    HTML Code:
    String sql = "SELECT group_id FROM " + this.GROUP_TABLE;
    it works fine.

    I am using
    Oracle Database 11g Enterprise Edition Release - 64bit Production
    PL/SQL Release - Production
    "CORE Production"
    TNS for Linux: Version - Production
    NLSRTL Version - Production
    Oracle Driver ojdbc6.jar and
    Last edited by unzip; 02-02-12 at 11:01.

  2. #2
    Join Date
    May 2004
    Solved with referring to post java.sql.SQLException: ORA-03115: unsupported network datatype or representation (JDBC forum at JavaRanch).

    I was doing rs = pstmt.executeQuery(sql) instead of rs = pstmt.executeQuery();

  3. #3
    Join Date
    Jan 2013

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

    I have written new code to my maintenance project.

    returns connection object. for this only I getting the above error

    Connection connection = DBConnectionFactory.getInstance().getConnection(ED PConstants.DEFAULT_DATASOURCE);

    PreparedStatement preparedStatement = null;
    ResultSet resultSet = null;
    String alternate_Acct_Id = null;
    String sqlStatement = "SELECT alternate_acct_id FROM mpiefp.efp_account_profile WHERE client_etin = ?";
    preparedStatement = connection.prepareStatement(sqlStatement);
    preparedStatement.setString(1, rimsLogin);
    resultSet = DBUtil.executeQuery(connection, preparedStatement, sqlStatement, "fetchAlternateAcctId");
    alternate_Acct_Id = resultSet.getString(1);
    }catch(SQLException sqlException){
    throw new SystemException(""+sqlException);
    catch(Exception exception){
    throw new SystemException(""+exception);
    cleanup(null, preparedStatement, null, connection);
    return alternate_Acct_Id;
    error is

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

    at d(
    at com.multiplan.edp.reprice.RepriceBeanHelper.fetchA lternate_Acct_id(Re
    at com.multiplan.ep.RealTimeClaimHandler.processCheck RealTimeClaimStatus
    at com.multiplan.ep.RealTimeClaimHandler.checkRealTim eClaimStatus(RealTi
    at com.multiplan.ep.RequestProcessor.submitEPorRTClai m(RequestProcessor.
    at service(EdpHttpServ
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:689)
    at org.mortbay.jetty.servlet.ServletHolder.handle(Ser
    at org.mortbay.jetty.servlet.ServletHandler.dispatch(
    at org.mortbay.jetty.servlet.ServletHandler.handle(Se
    at org.mortbay.http.HttpContext.handle(HttpContext.ja va:1530)
    at org.mortbay.http.HttpContext.handle(HttpContext.ja va:1482)
    at org.mortbay.http.HttpServer.service(HttpServer.jav a:909)
    at org.mortbay.http.HttpConnection.service(HttpConnec
    at org.mortbay.http.HttpConnection.handleNext(HttpCon
    at org.mortbay.http.HttpConnection.handle(HttpConnect
    at org.mortbay.http.SocketListener.handleConnection(S
    at org.mortbay.util.ThreadedServer.handle(ThreadedSer
    at org.mortbay.util.ThreadPool$PoolThread****n(Thread
    04 Jan 17:52:35,734 [SocketListener0-4] ERROR com.multiplan.ep.RealTimeClaimHand
    ler - Error while processCheckIHPClaimStatus : java.sql.SQLException: ORA-03115
    : unsupported network datatype or representation:
    thanks in advance

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts