Title:
"Closed the physical connection" for some queries since Coldfusion 10 update 20
| View in TrackerStatus/Resolution/Reason: Closed/Withdrawn/Duplicate
Reporter/Name(from Bugbase): Stéphane Chauvin / Stéphane Chauvin (Stéphane Chauvin)
Created: 09/13/2016
Components: Database
Versions: 10.0
Failure Type: Non Functioning
Found In Build/Fixed In Build: Final / 303100
Priority/Frequency: Critical / All users will encounter
Locale/System: English / Win 2008 Server R2 64 bit
Vote Count: 0
Problem Description:
Since the update 20 of Coldfusion 10, we encounter a query problem that leads to closing the physical connection :
removeOnExceptions is true for <MY_DATASOURCE>. Closed the physical connection.
The select query actually runs well but after that, any other query fail with the following message :
"[Macromedia][Oracle JDBC Driver]Object has been closed"
The JDBC driver is the Oracle built-in driver.
The select query contains :
- one inner join
- 6 left outer joins, one of which is with a select subquery that contains itself 3 left joins
- string concats with '||' operators
- use of decode() function
Any Workarounds:
Uninstall "update 20" and go back to "update 19" : solves the issue.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 4188864
Reason: PRHaveInfo
External Customer Info:
External Company:
External Customer Name: Stéphane Chauvin
External Customer Email:
External Test Config: Coldfusion 10.0
Apache 2.2
Windows server 2008 / Windows 7Attachments:
Comments: