ColdFusion MX 7 Oracle support

[plum1120]

If you read the detailed system support matrix for CFMX 7, it is very clear
that any flavor of Oracle is not "supported" under the Standard edition of the
product. There is only "support" for Oracle in CFMX 7 Enterprise.

Can anyone convey the authoritative definition of what "support" means?

We have a substantial MX6.1Standard/Oracle 9i investment, and we need to move
to CFMX 7 because of the Java 1.5 support. I am trying to better understand if
we are now cornered into upgrading our licenses to Enterprise to keep our apps
working properly.:confused;

[esperry]

We are facing the same issue, I can't give you the authoritative definition but
our apps are no longer functioning correctly going from MX6 Standrd to MX7
Standard edition.

In the MX6 environment we used the JDBC class 4 driver to connect to Oracle.
It is documented in the MX7 install that this is what you should do for MX7
Standard as well.
We have found that you can connect the data source and and verify it as OK.
You can run a select query and get the expected results but when you try loop
through the results set it will only process the first record and no more.
We installed the 30 day demo of MX7 Enterprise and set the data source using
the Oracle dirver supplied with Enterprise and everything functions correctly.

What we are unsure of is if there is a problem with the Oracle class file with
Standard edition or if you do indeed now need Enterprise.