tracker issue : CF-3187440

select a category, or use search below
(searches all categories and all time range)
Title:

Macromedia Oracle JDBC Driver fails to connect to Oracle 11g R2 when database encryption is required

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/

Reporter/Name(from Bugbase): Peter Day / Peter Day (miclear)

Created: 05/10/2012

Components: Database

Versions: 9.0

Failure Type: Non Functioning

Found In Build/Fixed In Build: 9.0 /

Priority/Frequency: Critical / All users will encounter

Locale/System: English / Linux RH Adv Srvr 5.0 x86-64

Vote Count: 0

Problem Description: When Oracle database requires sqlnet encryption, an attempt to connect using the Macromedia Oracle JDBC Driver gets the error: No more data available to read.

Steps to Reproduce: Configure the Oracle database to REQUIRE encrypted communication, configure a datasource to use jdbc:macromedia:oracle://server_name:1521;ServiceName=your_servicename, and submit the connection in the administrator

Actual Result: Connection verification failed for data source: esdimd
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.

Expected Result: data source updated successfully.

Any Workarounds: None known at this time

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3187440

External Customer Info:
External Company:  
External Customer Name: miclear
External Customer Email:  
External Test Config: My Hardware and Environment details:

Oracle 11g R2 RAC

Cold Fusion 9,0,0,251028  Enterprise

Attachments:

Comments:

I need to be able to return a ref cursor from a stored procedure. Only the macromedia driver has been able to do this in the past. The oracle jdbc thin client will connect but not return the ref cursor. It works when encryption is not required by the server. Policy is now requiring that we used encrypted connections to the database.
Comment by External U.
19491 | May 10, 2012 01:27:22 PM GMT
This issue is fixed with ColdFusion 11 database drivers and we are supporting Oracle Advanced Security.
Comment by Nimit S.
19492 | December 03, 2014 04:40:32 AM GMT