Professional Web Applications Themes

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

Here is the technote from Macromedia regarding this issue: [url]http://www.macromedia.com/go/tn_17660[/url] Hope this helps!...

Sponsored Links
  1. #1

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

    Here is the technote from Macromedia regarding this issue:

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

    Hope this helps!
    Sponsored Links
    CF_DAWG Guest

  2. #2

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

    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]

    ldbc Guest

  3. #3

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

    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

    sdupre Guest

Similar Threads

  1. Oracle JDBC driver and CF MX 7 Standard edition
    By cfskyline in forum Coldfusion Database Access
    Replies: 3
    Last Post: June 16th, 07:57 AM
  2. Oracle JDBC driver and CF Standard edition
    By maruchi70 in forum Coldfusion Database Access
    Replies: 0
    Last Post: June 13th, 11:18 PM
  3. [Macromedia][Oracle JDBC Driver]No more data availableto read.
    By stick35 in forum Coldfusion Database Access
    Replies: 3
    Last Post: January 25th, 08:03 PM
  4. [Macromedia][Oracle JDBC Driver]No more dataavailable to read.
    By BKBK in forum Coldfusion Database Access
    Replies: 1
    Last Post: January 25th, 03:22 PM
  5. SQLException: [Oracle JDBC Driver]No more data availableto read ?!?!?
    By kilokilo in forum Coldfusion Database Access
    Replies: 0
    Last Post: March 1st, 04:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139