[Macromedia][Oracle JDBC Driver][Oracle]ORA-01000:maximum open cursors exceeded

[CF_DAWG]

Here is the technote from Macromedia regarding this issue:

[url]http://www.macromedia.com/go/tn_17660[/url]

Hope this helps!

[ldbc]

I ran into this problem last week. I was using the <cfqueryparam> tag in my
code. I just had to remove the tags and the code ran fine. I found the
solution in this article:
[url]http://jehiah.com/archive/maximum-open-cursors-exceeded[/url]

[sdupre]

The technote is for an older version of ColdFusion. CF_DAWG is right. My
guess is it's bug 53884. The number of 'max pooled statements' (default 1000)
in the CF admin datasource is set higher than the number of open cursors Oracle
allows (max cursor setting). The evidence is getting rid of <CFQUERYPARAM>
for CF_DAWG. Since users may need <CFQUERYPARAM> for input validation for
queries (to avoid SQL injection attacks), you're probably better off putting
that back in. Lower the Max Pooled Statements setting. We recommend 0 on many
applications. There was only one other issue I'm aware of but it only happened
with looping (CFQUERY in a loop). That was fixed in 3.3 build 67. What
ColdFusion MX are you running? CFMX 6.1 + Updater? CF 7.0? Regards,
Stephen Dupre Macromedia QA