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. This application has no explicit mapping for /error
  60. java.lang.ClassNotFoundException: com.mysql.jdbc.Driver in Eclipse
  61. how to fix oracle ORA-01722 invalid number error
  62. ORA-00979 not a group by expression
  63. ORA-00907: missing right parenthesis
  64. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  65. error: ORA-65096: invalid common user or role name in oracle
  66. ORA-12154 could not resolve the connect identifier specified
  67. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  68. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  69. ORA-01843 not a valid month- Comparing Dates
  70. DB2 jdbc connection error Connection refused. ERRORCODE=-4499, SQLSTATE=08001
  71. Understanding Spring @Autowired usage
  72. com.atomikos.icatch.SysException: Error in init: Log already in use? tmlog in ./
  73. ORA-00918: column ambiguously defined in SELECT *
  74. Spring @PropertySources value not overriding
  75. Oracle error : ORA-00905: Missing keyword
  76. What does SQL Select symbol || mean?
  77. How do I limit the number of rows returned by an Oracle query after ordering?
  78. Oracle SELECT TOP 10 records
  79. “NoClassDefFoundError: Could not initialize class” error
  80. Can a foreign key be NULL and/or duplicate?
  81. How to Select Top 100 rows in Oracle?
  82. ORA-12560: TNS:protocol adaptor error
  83. Java Project: Failed to load ApplicationContext
  84. No String-argument constructor/factory method to deserialize from String value (”)
  85. BeanFactory vs ApplicationContext
  86. Spring boot – Request method ‘POST’ not supported. Tried everything
  87. What does the following Oracle error mean: invalid column index
  88. org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set
  89. “NoClassDefFoundError: Could not initialize class” error
  90. “NoClassDefFoundError: Could not initialize class” error
  91. ORA-00972 identifier is too long alias column name
  92. ORA-01830: date format picture ends before converting entire input string / Select sum where date query
  93. What does the following Oracle error mean: invalid column index
  94. What is difference between CrudRepository and JpaRepository interfaces in Spring Data JPA?
  95. java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
  96. Difference between spring @Controller and @RestController annotation
  97. How to fix org.hibernate.LazyInitializationException – could not initialize proxy – no Session
  98. Oracle Apex column link from LOV values
  99. PLS-00103: Encountered the symbol when expecting one of the following:
  100. What’s the difference between RANK() and DENSE_RANK() functions in oracle?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)