Sign Up

Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.

Have an account? Sign In

Have an account? Sign In Now

Sign In

Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.

Sign Up Here

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

You must login to ask question.(5)

Forgot Password?

Need An Account, Sign Up Here

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Sign InSign Up

ITtutoria

ITtutoria Logo ITtutoria Logo

ITtutoria Navigation

  • Python
  • Java
  • Reactjs
  • JavaScript
  • R
  • PySpark
  • MYSQL
  • Pandas
  • QA
  • C++
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Python
  • Science
  • Java
  • JavaScript
  • Reactjs
  • Nodejs
  • Tools
  • QA
Home/ Questions/Solving the error: java.sql.sqlexception no more data to read from socket.
Next
Answered
Alexandra Brown
  • 5
Alexandra Brown
Asked: May 18, 20222022-05-18T17:10:41+00:00 2022-05-18T17:10:41+00:00In: Programs

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
  • 2 2 Answers
  • 84 Views
  • 0 Followers
  • 0
Answer
Share
  • Facebook
  • Report

2 Answers

  • Voted
  • Oldest
  • Recent
  • Random
  1. Best Answer
    lyytutoria Expert
    2022-06-13T17:03:06+00:00Added an answer on June 13, 2022 at 5:03 pm

    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
      • Reply
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
        • Share on LinkedIn
        • Share on WhatsApp
        • Report
    • Léa Pasquier
      2022-05-25T20:37:46+00:00Added an answer on May 25, 2022 at 8:37 pm

      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
      • Reply
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
        • Share on LinkedIn
        • Share on WhatsApp
        • Report

    Leave an answer
    Cancel reply

    You must login to add an answer.

    Forgot Password?

    Need An Account, Sign Up Here

    Sidebar

    Ask A Question
    • How to Split String by space in C++
    • How To Convert A Pandas DataFrame Column To A List
    • How to Replace Multiple Characters in A String in Python?
    • How To Remove Special Characters From String Python

    Explore

    • Home
    • Tutorial

    Footer

    ITtutoria

    ITtutoria

    This website is user friendly and will facilitate transferring knowledge. It would be useful for a self-initiated learning process.

    @ ITTutoria Co Ltd.

    Tutorial

    • Home
    • Python
    • Science
    • Java
    • JavaScript
    • Reactjs
    • Nodejs
    • Tools
    • QA

    Legal Stuff

    • About Us
    • Terms of Use
    • Privacy Policy
    • Contact Us

    DMCA.com Protection Status

    Help

    • Knowledge Base
    • Support

    Follow

    © 2022 Ittutoria. All Rights Reserved.

    Insert/edit link

    Enter the destination URL

    Or link to existing content

      No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.