We ran into this with CFMX 6.1 and most solutions we found online said to increase the setting in Oracle. What we found however was that it was JDBC version related. It does not happen at all when using CFMX 7.1 and whatever drivers it has.
On 6/20/05, Dustin Tinney <[EMAIL PROTECTED]> wrote: > > Current Setup: > > Dual Sun Station running Production Web server (CFMX 6.1) & DB Oracle > 8i. Single CPU test station connected to the Live DB. > > My Question is this: > We've recently started getting number of open cursors exceeded. I > know that our Production Env. is set to have 100 Max Pooled > Statements allowed to it. Our test Env. has it set to 50 Max Pooled > Statements. I know that Max Pooled Statements are usually based upon > your applications load but I'm trying to figure out what MOST web > servers are run with in hopes of our IT dept increasing our Max > Pooled Statements. > > Thanks, > /Dustin > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209975 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
