Yes, switching to native Oracle driver fixed the problem, looks like the Java driver doesn't support cursors yet. The original reason for us using Java JDBC driver instead of the native driver was due to native driver having problems with shared mode of the Oracle server (it was dropping connections often or something like that). The last time native driver was tested was about 1-1.5 years ago, I think with CF 6.0. Does anyone know whatever native Oracle driver for CF 6.1 was improved? Does it work fine with the shared mode of the Oracle server? This would save me a lot of testing. Thanks for your help Janet,
TK > >I think this is a problem with the jdbc thinclient driver. Look at live >docs on Macromedia's site >(http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-b17.htm). > > > >IAt 09:27 AM 10/20/2004 -0400, you wrote: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182008 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
