tracker issue : CF-3508732

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

Informix Driver Bug

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/

Reporter/Name(from Bugbase): Bill Moreno / Bill Moreno (AE Bill)

Created: 02/28/2013

Components: Database

Versions: 9.0.1

Failure Type: Non Functioning

Found In Build/Fixed In Build: 9.0.1 /

Priority/Frequency: Major / Some users will encounter

Locale/System: English / Win 2003 Server x64

Vote Count: 0

Problem Description:
We receive errors 2 to 3 times a day like this:

"[Informix JDBC Driver][Informix]Cannot execute a SELECT statement that is PREPAREd- must use cursor." 

When the initial error occurs, the server in question will then generate 10 - 40 errors over the course of a 1 to 2 minutes and then the error run stops. A trace on the error in Informix is below. It is always the same query that fails but the query does not always fail.

We have multiple servers connecting to a single informix database but this error only happens on one server at a time.

We have noticed that when the CF datasource in question has "0" Max Pooled Statements in it's config, the server will not recover from the error and the datasource either needs to have it's connection reset or the CF service needs a restart.

However, if we have >0 Max Pooled Statements in the config, the server will "fix" itself (reset connection?) within 1 to 3 minutes. 

Steps to Reproduce:
We have not be able to trigger this error but we see it happen daily. See attached trace and comments from IBM in AutoEurope-IBM-bug.txt

Any Workarounds:
None yet.

IBM is pointing fingers at DataDirect drivers and we've found that error happens with both native CF Informix driver and with the regular, non OEM DataDirect JDBC driver installed in CF.

DataDirect will not directly support us because we're using the OEM driver and didn't purchase their standard driver from them. They have suggested we open a CF bug so that we can work with Adobe and DataDirect's OEM support team.

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

Watson Bug ID:	3508732

Deployment Phase:	Release Candidate

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

Informix version: 11.70.FC7

ColdFusion Version: 9,0,1,274733  Enterprise

7 CF servers running on Windows2003 64-bit.

Errors happen on all servers but so far we have not been able to find the trigger or any pattern that causes the error.


  1. March 01, 2013 00:00:00: 1_AutoEurope-IBM-bug.txt


Is this issue still occurring? If yes. Please share below mentioned information: 1. Informix version 2. ColdFusion settings summary 3. Is there any specific query which is failing? If yes, then share the query syntax. You can share these details at
Comment by Nimit S.
16127 | December 17, 2013 02:37:24 AM GMT
We have not heard anything back on this issue. Hence, closing this bug. If you are still facing this issue please let us know so that we can re-open this bug. You can also connect CF support( for detailed investigation of this issue.
Comment by Nimit S.
16128 | December 03, 2014 01:37:03 AM GMT