We finally discovered why we were intermittently receiving a "No more data
available to read" error.

1) Some of our datasources were setup with a timeout value of 0 and an
interval value of 0. After an hour of inactivity if the datasource was used
again we would see the error. We changed these settings to timeout=58 and
interval=1.

2) If we ever stop and start Oracle then we need to stop and start Cold
Fusion to kill all the open datasource connections. Otherwise we will get the
"no more data to read" error for each datasource connection that we had open at
the time of stopping and starting Oracle.

We are using Cold Fusion MX 7, JDBC drivers 3.5 and Oracle 9i.