Hi.. im doing a reporting system that involves heavy data retrieval from
database. Data source is Informix, connected via JDBC.
Im talking about 20 or more lines of SQL SELECT statement with complex
aggregates functions.
Now after a few executions of the queries , all queries (even a small one)
return 0 records, or sometimes with following error message..

The system has attempted to use an undefined value, which usually indicates a
programming error, either in your code or some system code.
Null Pointers are another name for undefined values.

I check the database directly, the db and server still works fine. I even run
the query directly to database, it works fine.
So i believe there's nothing wrong the database.

I managed to work around this by disabling the DB connection from CF Admin,
and enable it back. The system comes back to normal..

But, what is the problem here? CF Bug or.. is there any setting on Admin that
need to be changed?
Data source connection setting?

I cant keep on toggling the connection every time this happens.
I can simplify the queries by having a pre-generated datamart table, and
having CF just do a simple select from the table.
But this will give overhead to the server and obviously database spaces.

Need a smart solution here.

Thanks.