I noticed differences when we moved as well. I am betting when you connected to non-RAC instances, you used the Oracle driver from the pulldown in the DSN section. When you connect to RAC instances, you have downloaded Oracle's thin client and are using Oracle jdbc string.
You have 3 options in my experience: - change your code to manipulate the date strings - change mask on date columns in database - change driver. If you use Macromedia's (DataDirect's) jdbc connection to your RAC instances your date issues will disappear. However if you use OID, this driver does not support it. If you use stored procs, this is the only driver you can use. On Mon, Oct 6, 2008 at 12:20, Boysie Tupaz <[EMAIL PROTECTED]> wrote: > Hi everyone, > > I have an application that uses ColdFusion 8 and Oracle 10g R2. Both CF8 > and 10g are working very well but the problem that I'm having is that the > cursor never gets drop every time a query runs. All cursors never get > release. > > Does anyone experienced this problem before? > Any suggestions, ideas, answers are welcome. > > Thanks in advance. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313526 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
