Home/ Questions/Solving the error: java.sql.sqlexception no more data to read from socket.
Next
Answered
Alexandra Brown
  • 5
Asked: 2022-05-18T17:10:41+00:00 In:

Solving the error: java.sql.sqlexception no more data to read from socket.

  • 5

. Advertisement .

..3..

. Advertisement .

..4..

How to solve the problem – java.sql.sqlexception no more data to read from socket? I have the sample detail:

<bean class="org.apache.commons.dbcp.BasicDataSource"
  destroy-method="close" id="dataSource">value="${database.driverClassName}" />
  <property name="driverClassName" 
  <property name="url" value="${database.url}" />
  <property name="username" value="${database.username}" />
  <property name="password" value="${database.password}" />
  <property name="defaultAutoCommit" value="false" />
  <property name="initialSize" value="10" />
  <property name="maxActive" value="30" />
  <property name="validationQuery" value="select 1 from dual" />
  <property name="testOnBorrow" value="true" />
  <property name="testOnReturn" value="true" />
  <property name="poolPreparedStatements" value="true" />
  <property name="removeAbandoned" value="true" />
  <property name="logAbandoned" value="true" />
  </bean>

While I was running it, I found the warning message:

Caused by: java.sql.SQLRecoverableException: No more data to read from socket
  at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1142)
  at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1099)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:288)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
  at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863)
  at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
  at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620)
  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
  at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
  at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
  at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
  at org.hibernate.loader.Loader.getResultSet(Loader.java:1869)
  at org.hibernate.loader.Loader.doQuery(Loader.java:718)
  at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
  at org.hibernate.loader.Loader.doList(Loader.java:2449)
  ... 63 more
Thu Oct 20 10:29:44 2011
 Errors in file d:\oracle\diag\rdbms\ads\ads\trace\ads_ora_3836.trc (incident=31653):
 ORA-03137: TTC protocol internal error : [12333] [4] [195] [3] [] [] [] []
 Incident details in: d:\oracle\diag\rdbms\ads\ads\incident\incdir_31653\ads_ora_3836_i31653.trc
 Thu Oct 20 10:29:45 2011
 Trace dumping is performing id=[cdmp_20111020102945]
 Thu Oct 20 10:29:49 2011
 Sweep [inc][31653]: completed
 Sweep [inc2][31653]: completed
 Thu Oct 20 10:34:20 2011
 Errors in file d:\oracle\diag\rdbms\ads\ads\trace\ads_ora_860.trc (incident=31645):
 ORA-03137: TTC protocol internal error : [12333] [4] [195] [3] [] [] [] []
 Incident details in: d:\oracle\diag\rdbms\ads\ads\incident\incdir_31645\ads_ora_860_i31645.trc
 Thu Oct 20 10:34:21 2011

That is my question in my midterm exam, and it is urgent. I searched the solutions on some websites, but I didn’t get it. I may miss any line or other changes. I appreciate your assistance!

no more data to read from socket
Share

2 Answers

  1. Best Answer
    Expert

    The cause:

    The error happens may be due to optimizer bound peeking.

    Solution:

    To fix this error, you should ask Oracle for support. There are different workarounds, depending on Oracle version.

    There are two options for solving the error:

    1. Upgrading to 11.2

    2. Setting oracle parameter _optim_peek_user_binds = false

      However, note that underscore parameters should only ever be set after an Oracle support person has advised.

      • 0

    • The same problem was faced by us. We solved it by increasing the initialSize/maxActive connection pool.

      can be viewed at this link

      Perhaps this will help someone.

      • 13

    Leave an answer

    You must login to add an answer.

    Need An Account,