Hi AJ, Thanks for the questions; I'm not sure if I can check which JBDC connect I am using without any admin privelages...do you know a way?
I will check tomorrow morning which version of Oracle it is vs. what they patch. Thanks again, Tomek On Mon, Oct 19, 2009 at 6:32 PM, AJ Mercer <[email protected]> wrote: > Make sure CF is patched > check out for latest db drivers > http://kb2.adobe.com/cps/000/42dcb10a.html > > I was using Oracle a couple of years ago and recall having this issue - but > cant exactly remember the solution. > I know this fixed something along the way. > > Are you using a JBDC connect? > Are you using the latest oracle client? > > > 2009/10/19 Tomek Kott <[email protected]> > > Hi Folks, >> >> I have been having trouble with getting the following errors: (using CF 7, >> Oracle 9i, FC 5.1.9) >> >> [Macromedia][Oracle JDBC Driver][Oracle]ORA-01000: maximum open cursors >> >> exceeded >> >> Now, from what I understand, if ColdFusion "Open Connections" (or whatever >> its called) is set low enough (say 200) and Oracle Open Cursors are set high >> enough (say 400) there shouldn't be this problem, since ColdFusion >> automatically closes open cursors after they are used. >> >> I ask because my server admin / dba keep telling me to check my code for >> open cursors, to which I keep replying that ColdFusion should take care of >> it if set properly and that it's not my fault. (I don't have access to CF >> Admin / DBA personally ) >> >> Any help with this would be very nice before I push the problem further up >> the management ladder. >> >> Thanks, >> >> Tomek >> >> >> > > > -- > AJ Mercer > Web Log: http://webonix.net > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message cos you are subscribed to "farcry-dev" Google group. To post, email: [email protected] To unsubscribe, email: [email protected] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry -~----------~----~----~----~------~----~------~--~---
