Skip to main content
M
mjsale
Participating Frequently
February 8, 2013
Question

Error Creating Oracle Data Source - no more data to read

  • February 8, 2013
  • 1 reply
  • 2385 views

I am working with a client who is trying to create an Oracle data source in ColdFusion and is receiving the following error message:

Connection verification failed for data source: cqat

java.sql.SQLNonTransientConnectionException: [Macromedia][Oracle JDBC Driver]No more data available to read.

The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][Oracle JDBC Driver]No more data available to read.

Here is the information for the given situation:

Oracle 11.2 64-bit Enterprise running on Linux (No RAC or encryption on the database server)

ColdFusion 9.0.1.274733 32-bit running on Windows 2008

We are trying to create an Oracle data source using the built-in Oracle drivers in CF (data direct).

I have never had this issue before when trying to connect to an Oracle server.. even when my CF installation was 32 bit and my Oracle installation is 64 bit.

Any help or thoughts would be much appreciated.

PS - An ODBC Socket type data source works like a charm.

~Mike

This topic has been closed for replies.

1 reply

K
Kaif_Akbar
Inspiring
March 1, 2013

Normally error such as "No more data available to read" is thrown when any CFM page containing any cfquery is executed and not able to fetch complete data, whereas you have reported that you are getting this error during Oracle datasource creation, can you please reconfirm that you are getting this during datasource creation?

-

Kaif Akbar

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices