Thanks for the detailed reply Mark,
It's for Pro so will have a play and ask if we're stuck.
Cheers
Grant
-----Original Message-----
From: Mark M [mailto:[EMAIL PROTECTED]
Sent: Monday, August 11, 2003 1:37 PM
To: CFAussie Mailing List
Subject: [cfaussie] Re: Oracle JDBC Drivers
> Anybody know a good set of native jdbc drivers for Oracle 9i that
> work with CFMX?
Grant -
Several points to this effect, it can depend.
1) Are you using Pro of Enterprise? Enterprise comes with it's own
Merant JDBC
driver that works a treat. Given the option, work with that. However,
pro doesn't
give you that driver.
For Pro Oracle/Macromedia suggest one of 2 options, and depending on
circumstances, use the one you need.
1) Oracle JDBC Thin Client.
This JDBC driver DOES NOT require that the Oracle 9i client be installed
on the
system that is hooking into the database.
Can be downloaded from here:
http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html
Technotes on setting it up can be found here:
http://www.macromedia.com/support/coldfusion/ts/documents/tn18344.htm
The bad thing about the Thin client is that (a) stored proc's in must be
PROCEDURES and NOT FUNCTIONS. (Under the merant driver, it doesn't seem
to care too much) and, (b) the BIG drawback is that any proc you do
have, will
throw an error if you try and return a result set.
2) Oracle ODBC driver.
This ODBC driver DOES require that you install the 9i client on the
server so it can
be used.
Can be downloaded from here:
http://otn.oracle.com/software/tech/windows/odbc/content.html
(May need to also download the Oracle Universal Installer)
Bad thing about this one - again, stored Procs, MUST be procs - HOWEVER,
yuo
can now return result sets from a stored procedure without any problem.
I have yet to see any major performance difference between the two.
Without any
testing, I feel like the ODBC one is faster, but that could just be
because the Thin
client one would always throw an error on all my stored procs.
If you have any problems let me know. Getting my drivers set up for Pro
took me
3 days or so of trial and error. The docs don't cover it too well. So
if I can aid
someone else in missing all the pain and suffering I went through,
hopefully it will
be worth it ;o)
HTH.
Mark
-----------------------------------
[EMAIL PROTECTED]
ICQ: 3094740
Safe From Bees
[www.safefrombees.com]
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
