No more data to read from socket error

For errors like this you should involve oracle support. Unfortunately you do not mention what oracle release you are using. The error can be related to optimizer bind peeking. Depending on the oracle version different workarounds apply.

You have two ways to address this:

  • upgrade to 11.2
  • set oracle parameter _optim_peek_user_binds = false

Of course underscore parameters should only be set if advised by oracle support

Related Posts:

  1. issue ORA-00001: unique constraint violated coming in INSERT/UPDATE
  2. ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
  3. Hibernate dialect for Oracle Database 11g?
  4. SQL error “ORA-01722: invalid number”
  5. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  6. QL Error: ORA-00933: SQL command not properly ended
  7. ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client
  8. ORA-28040: No matching authentication protocol exception
  9. SQL Error: ORA-00942 table or view does not exist
  10. ORA-00984: column not allowed here [duplicate]
  11. ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
  12. How to resolve ORA 00936 Missing Expression Error?
  13. SQL not a single-group group function
  14. PLS-00201 – identifier must be declared
  15. HTTP Status 405 – Request method ‘POST’ not supported (Spring MVC)
  16. org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘MyController’:
  17. ORA-30926: unable to get a stable set of rows in the source tables
  18. Error creating bean with name ‘entityManagerFactory’ defined in class path resource : Invocation of init method failed
  19. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  20. PLS-00103: Encountered the symbol “CREATE”
  21. Oracle client ORA-12541: TNS:no listener
  22. SQL error “ORA-01722: invalid number”
  23. ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
  24. Error creating bean with name ‘entityManagerFactory’ defined in class path resource : Invocation of init method failed
  25. Unable to create requested service [org.hibernate .engine.jdbc.env.spi.JdbcEnvironment]-MySQL
  26. ORA-12899: value too large for column
  27. Oracle startup not possible – ORA-00845: MEMORY_TARGET not supported on this system – but memory size seems to be fine
  28. How does spring.jpa.hibernate.ddl-auto property exactly work in Spring?
  29. Oracle date format picture ends before converting entire input string
  30. HTTP Status 405 – Request method ‘POST’ not supported (Spring MVC)
  31. SQLPLUS error:ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
  32. SQL Error: ORA-00913: too many values
  33. UTL_FILE.FOPEN() procedure not accepting path for directory?
  34. ORA-01653: unable to extend table by in tablespace ORA-06512
  35. SQL Error: ORA-01861: literal does not match format string 01861
  36. ORA-28001: The password has expired
  37. ORA-01461: can bind a LONG value only for insert into a LONG column-Occurs when querying
  38. Oracle “SQL Error: Missing IN or OUT parameter at index:: 1”
  39. sqldeveloper error : no ocijdbc11 in java.library.path on windows 7
  40. Oracle SQL Developer: Failure – Test failed: The Network Adapter could not establish the connection?
  41. ORA-01747: invalid user.table.column, table.column, or column specification
  42. How to solve the “failed to lazily initialize a collection of role” Hibernate exception
  43. SQL Queries “00904. 00000 – “%s: invalid identifier”
  44. How to display databases in Oracle 11g using SQL*Plus
  45. SQL Error: 0, SQLState: 08S01 Communications link failure
  46. grant select on view
  47. What kind of Java type is “[B”?
  48. Query to display all tablespaces in a database and datafiles
  49. ‘NOT LIKE’ in an SQL query
  50. What does java:comp/env/ do?
  51. ORA-20002: YOU ARE NOT ALLOWED TO CHANGE THE PASSWORD FOR CRITICAL SCHEMAS
  52. How can I set a custom date time format in Oracle SQL Developer?
  53. How to copy files into a virtual box oracle box
  54. Find out the history of SQL queries
  55. Spring Hibernate – Could not obtain transaction-synchronized Session for current thread
  56. ORA-00904: invalid identifier
  57. What is a spring service annotation? [duplicate]
  58. java.lang.ClassNotFoundException: com.mysql.jdbc.Driver in Eclipse
  59. ORA-12154 could not resolve the connect identifier specified
  60. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  61. DB2 jdbc connection error Connection refused. ERRORCODE=-4499, SQLSTATE=08001
  62. “NoClassDefFoundError: Could not initialize class” error
  63. How to Select Top 100 rows in Oracle?
  64. ORA-12560: TNS:protocol adaptor error
  65. No String-argument constructor/factory method to deserialize from String value (”)
  66. BeanFactory vs ApplicationContext
  67. What is difference between CrudRepository and JpaRepository interfaces in Spring Data JPA?
  68. How to fix org.hibernate.LazyInitializationException – could not initialize proxy – no Session
  69. Oracle Apex column link from LOV values
  70. org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set
  71. java.lang.ClassNotFoundException: org.springframework.web.context.ContextLoaderListener
  72. org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set
  73. How to resolve Error listenerStart when deploying web-app in Tomcat 5.5?
  74. Failed to load ApplicationContext from Unit Test: FileNotFound
  75. ORA-01861: literal does not match format string
  76. Failed to load ApplicationContext from Unit Test: FileNotFound
  77. SQLRecoverableException: I/O Exception: Connection reset
  78. What are the possible values of the Hibernate hbm2ddl.auto configuration and what do they do
  79. How to fix the Hibernate “object references an unsaved transient instance – save the transient instance before flushing” error
  80. PersistentObjectException: detached entity passed to persist thrown by JPA and Hibernate
  81. How to insert date values into table
  82. intellij incorrectly saying no beans of type found for autowired repository
  83. java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver Exception occurring. Why?
  84. Is spring default scope singleton or not?
  85. Hibernate Error: a different object with the same identifier value was already associated with the session
  86. Hibernate throws org.hibernate.AnnotationException: No identifier specified for entity: com..domain.idea.MAE_MFEView
  87. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  88. MultipartException: Current request is not a multipart request
  89. How do I reset a sequence in Oracle?
  90. MySQL equivalent of DECODE function in Oracle
  91. What’s the difference between JPA and Hibernate?
  92. How to map a composite key with JPA and Hibernate?
  93. Configure active profile in SpringBoot via Maven
  94. Downloading a file from spring controllers
  95. LEFT function in Oracle
  96. How do I view the Explain Plan in Oracle Sql developer?
  97. ORA-01779: cannot modify a column which maps to a non key-preserved table
  98. when spring boot startup,throw out the “method names must be tokens” exception
  99. Hibernate show real SQL
  100. Spring 3 MVC resources and tag mvc:resources /

Leave a Comment