Status/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): Dave Irovic / Dave Irovic (Dave Irovic)
Created: 03/04/2013
Components: Database
Versions: 10.0
Failure Type:
Found In Build/Fixed In Build: Final / CF11 Update5
Priority/Frequency: Major / All users will encounter
Locale/System: English / Win 2008 Server R2 64 bit
Vote Count: 0
Problem Description:
When attempting to setup a data source using the ColdFusion Oracle driver to connect to an Oracle database using Oracle Advanced Security, we always get the error: "java.sql.SQLNonTransientConnectionException: [Macromedia][Oracle JDBC Driver]No more data available to read." We tried to add the parameters to use encryption in the connection string for the data source "EncryptionLevel=accepted;EncryptionTypes=(AES256,RC4_256,AES192,3DES168,AES128,RC4_128);" but we get the same error. Can someone document the steps to add a data source using this encryption method? Thanks.
Steps to Reproduce:
Follow the standard steps for adding an Oracle data source by entering the SID Name, Server, port, user name, password with the Oracle data source type. Click Show Advanced Settings and enter "EncryptionLevel=accepted;EncryptionTypes=AES256,RC4_256,AES192,3DES168,AES128,RC4_128);" into the connection string field. Press Submit. The above error appears on verification, and any call to query the data source.
Any Workarounds:
Nothing works using the ColdFusion driver. If we download the native thin Oracle JDBC driver, we can create a connection using the Other data source type, and it connects fine. The problem with using this option is we lose the query timeout parameter, and long or runaway queries never return and hang threads in ColdFusion. We are trying to avoid this with the CF10 upgrade.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3512854
External Customer Info:
External Company:
External Customer Name: IrovicD
External Customer Email:
External Test Config: My Hardware and Environment details:
Server is a VM running with 4 CPU and 12GB RAM (3GB allocated to the JVM ColdFusion instance), and running on Windows Server 2008 R2 Enterprise.
Attachments:
Comments: