1-800-477-6473 Ready to Talk?

Feedback

Did this article resolve your question/issue?

Article

What does the error "No more data available to read" mean?

Information

Title	What does the error "No more data available to read" mean?

URL Name	What-does-the-error-No-more-data-available-to-read-mean

Article Number	000184840

Environment	Product: Connect drivers Version: All supported versions OS: Java Application: All supported applications

Question/Problem Description

What does the error "No more data available to read" mean?

Steps to Reproduce

Clarifying Information

Error Message	[DataDirect][JDBC Oracle driver] No more data available to read.

Defect Number

Enhancement Number

Cause

Resolution

The "No more data available to read" error is a generic error message that the driver generates when there has been a network problem such as a dropped connection.
This error can occur in several different situations involving query timeouts, firewall timeouts, network misconfiguration and defects.

Known Defects: "No more data available to read"

Connect for JDBC Oracle driver:

When ForcePortRedirection=true is used while establishing a connection a known issue was fixed in  5.1.4.000396 (F000335.U000156). For Refer to Article  "No more data available to read" error with the Oracle JDBC driver when ForcePortRedirection is set to true

When LOB data > 32770 characters fetched using getClobVal() against Oracle 11gR2. Refer to Article for alternate solutions  Exceptions occur trying to read XML type data (cast as CLOB using Oracle XML.getClobVal() method) when using the JDBC Oracle driver against Oracle 11gR2

Multiple stmt.execute() to Stored Procedure returning REF CURSOR fixed in build 4.0.0027. Refer to Article No more data available to read

Connect for JDBC DB2 driver

Retrieving clob data from DB2 9.1 fixed in build 4.0.0019. Refer to Article  No more data available to read on DB2 9.1 CM

Querying CLOB data on DB2 9.7 fixed in fixed in build 4.1.0020. Refer to Article  CLOB query returns "No more data available to read" on db2

Selecting CLOB data fixed in Fixed in 4.0.0062. Refer to Article  Error "No more data available to read" with Connect for JDBC DB2 driver

Stored procedure name > 18 characters which returns dynamic result sets, fixed in 5.1.4.0187. Refer to Article  Calling a DB2 stored procedure returns error "No more data available to read."

Improved checks when reading an 8-byte double from the wire in 4.2.1.0038. Refer to Article  "No more data available to read" exception with the Connect for JDBC DB2 driver when reading double data.

SQL Server JDBC driver

Querys that return large result sets fixed in build 3.7.38. Refer to Article  No more data available to read" error when query contain "order by" clause

Better Message handling when the maximum number of connections is reached in build 3.3.0035. Refer to Article  No more data available to read" error when maximum number of connections is reached

SELECT statement on a 'Text' column, fixed in build 4.1.024324 (042120.014908). Refer to Article  No more data available to read error when selecting data from Text column in SQLServer

JDBC Hive Driver

SET command improved to be used as an action verb to set or query a value, fixed in 5.1.3.000078. Article Executing "SET" commands to the Cloudera Hive 4.5 - 0.10.0 server causes error: [DataDirect][Hive JDBC Driver]No more data available to read.

Workaround

Notes

Last Modified Date	8/17/2023 6:36 PM

Files

Disclaimer

The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.

Progress, Telerik, Ipswitch, Chef, Kemp, Flowmon and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.