Title:
Between CF 11,0,04,293328 and 11,0,10,300066, DataDirect Oracle JDBC driver updated and now causing closed connections.
| View in TrackerStatus/Resolution/Reason: Closed/Withdrawn/Duplicate
Reporter/Name(from Bugbase): Stephen Johnson / Stephen Johnson (Stephen Johnson)
Created: 10/24/2016
Components: Database
Versions: 11.0
Failure Type: Non Functioning
Found In Build/Fixed In Build: CF11_Final /
Priority/Frequency: Critical / All users will encounter
Locale/System: English / Win 2012 Server x64
Vote Count: 4
Problem Description:
Issuing a SELECT against a table with NCLOB data causes subsequent SELECT queries to fail with the following error:
[Macromedia][Oracle JDBC Driver]Object has been closed.
Steps to Reproduce:
Assume you have a table with 2 columns represented as NCLOBs in Oracle 12.1.0.2.0.
Assume also that that table has more than a 10 records.
Issue the following query via <cfquery>:
SELECT NVL(NCLOB_1_Column, NCLOB_2_Column)
FROM NCLOB_TABLE
Results will be returned without incidence.
Issue an other query, for example:
SELECT 'test' a
FROM DUAL
With CF 11,0,04,293328, you'll get results without incidence.
With CF 11,0,10,300066, the connection will close or will have been closed because of the prior statement.
Suspect that DataDirect broke their Oracle JDBC drivers with last release.
Note the build Number on DataDirect JDBC drivers between CF builds:
#Wed, 03 Sep 2014 10:49:47 -0400
#
# Copyright (c) 2002 DataDirect Technologies, Inc.
# This software contains confidential and proprietary
# information of DataDirect Technologies, Inc. All rights reserved.
#
buildid=000166
vs.
#Thu, 19 May 2016 09:41:02 -0400
#
# Copyright (c) 2002 DataDirect Technologies, Inc.
# This software contains confidential and proprietary
# information of DataDirect Technologies, Inc. All rights reserved.
#
buildid=000328
Any Workarounds: Nope. We need to use NCLOB.
- Steve Johnson
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 4197019
External Customer Info:
External Company:
External Customer Name: Stephen Johnson
External Customer Email:
External Test Config: My Hardware and Environment details:
Server Product ColdFusion
Version 11,0,10,300066
Edition Enterprise
Operating System Windows Server 2012
OS Version 6.2
Update Level /C:/ColdFusion11/cfusion/lib/updates/chf11000010.jar
Adobe Driver Version 5.1.3 (Build 000094)Attachments:
- February 07, 2017 00:00:00: datasource_log_cf10_ok.log
- February 07, 2017 00:00:00: datasource_log_cf2016_error.log
Comments: