Open Cursors Error in Oracle; ColdFusion Problem?

[Tomek Kott]

Some parts of this message have been removed. Learn more about Nabble's security policy.

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

--~--~---------~--~----~------------~-------~--~----~
You received this message cos you are subscribed to "farcry-dev" Google group.
To post, email: farcry-dev@...
To unsubscribe, email: farcry-dev+unsubscribe@...
For more options: http://groups.google.com/group/farcry-dev
--------------------------------
Follow us on Twitter: http://twitter.com/farcry
-~----------~----~----~----~------~----~------~--~---

[AJ Mercer]

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 <tkott.spam@...>

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: farcry-dev@...
To unsubscribe, email: farcry-dev+unsubscribe@...
For more options: http://groups.google.com/group/farcry-dev
--------------------------------
Follow us on Twitter: http://twitter.com/farcry
-~----------~----~----~----~------~----~------~--~---

[Tomek Kott]

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 <ajmercer@...> 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 <tkott.spam@...>

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: farcry-dev@...
To unsubscribe, email: farcry-dev+unsubscribe@...
For more options: http://groups.google.com/group/farcry-dev
--------------------------------
Follow us on Twitter: http://twitter.com/farcry
-~----------~----~----~----~------~----~------~--~---