We use shared mode and we had to turn off the "maintain connections" setting (i.e. JDBC pooling) in the CF datasource as we were getting non-sql errors for no good reason. With shared mode the connection setup is quite fast so it doesn't impact us much at all.
-----Original Message----- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Thursday, 21 October 2004 12:00 To: CF-Talk Subject: Re: Oracle stored procedure returning a cursor 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182011 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54