On 9/23/05, kugh ng <[EMAIL PROTECTED]> wrote: > Thanks for replying Dave. > It seems to be a very big bug - of not being able to use oracle ref cursors > with coldfusion ! Big for me beacuse I cannot imagine how data driven > applications can then be developed on coldfusion > > Could you tell me how do I replace the version 3.3/3.4 DataDirect driver - > with the 3.5 version that works? > I mean is there some path/procedure to follow to be able to replace this > properly and ask ColdFusion to use the new version instead? >
Well, it's a bug, but not one the Macromedia or DataDirect introduced. It's really a change in functionality on Oracle's end that is now effecting third-party vendors. If you'd like to use the DD driver trial, so you can at least move ahead for 15 days, go to their site, sign up for the trial, download the drivers, and run the installer for them. This will lay down the appropriate jar files with the correct trial license. Then drop base.jar and oracle.jar into your /servers/lib directory and restart ColdFusion. To configure the driver in the MX Admin: 1) Under "Driver", choose "Other" 2) The driver settings are: JDBC URL: jdbc:datadirect:oracle://[servername]:[portnumber]; SID=[your SID]; sendStringParametersAsUnicode=false; MaxPooledStatements=300; Driver Class: com.ddtek.jdbc.oracle.OracleDriver Driver Name: com.ddtek.jdbc.oracle.OracleDriver Username/Password as appropriate for your instance. Note that the JDBC URL is all one line. If you don't want to go through this trouble, you'll need to sit tight while Macromedia fixes things up. Since Oracle 10g R2 is less than a month old (well, Linux came out about 2 months ago), time will be needed by all vendors to QA the updates. Regards, Dave. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219086 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
