Oracle JDBC driver and CF MX 7 Standard edition

[cfskyline]

hi, guys.
is it possible to use Oracle JDBC driver with CF MX 7
Standard edition?
all our CF servers are Enterprise edition so we never ran into any
problems connecting to Oracle servers.
however, there will be a couple of new CF servers with relatively
simple jobs running and we're trying to determine if we can use the
Standard edition instead.
I'd like to test this on my own, but CF MX 7 Standard edition is not
available as a trial download.
if there's someone who's done this already, I'd love to hear from
you.
can anyone shed a little light on this?
thank you very much!

J

[Shigeru@Linkcom]

Hi, J.

We've used Oracle JDBC driver with CF7 std for our product.
I believe that you can use Oracle 9i JDBC driver with CF7 std.
But Oracle 10g JDBC driver with CF7 std has a problem.
The problem is related to "Date" type of table column.
ColdFusion can't convert from "Date field" of Oracle 10g driver to "Time" data
..
For example, value of "06/14/2006 14:15:32" in DB is converted to "06/14/2006
00:00:00".

[paross1]

For the date/timestamp issue, you might check thread [url]http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?catid=6&threadid=1145825[/url]

Phil

[Shigeru@Linkcom]

Thanks, paross1!!
( I didn't know about this. )