Professional Web Applications Themes

CFMX 6.1 and Oracle 9i Connection Pooling - Coldfusion - Advanced Techniques

I'm running CF MX 6.1 Enterprise with the Native Oracle driver and connecting to an Oracle 9i database. I have maintain connections selected . A timeout of 20 min and interval of 7 min. I'm not noticing connection pooling it looks like. When I hit the server with a bunch of requests, it opens connections to the DB, but then it shuts them all down after when I was looking with netstat. So it would not appear to be doing connection pooling. Any information would be useful. I thought it would maintain the connection across client requests since that was ...

  1. #1

    Default CFMX 6.1 and Oracle 9i Connection Pooling

    I'm running CF MX 6.1 Enterprise with the Native Oracle driver and connecting
    to an Oracle 9i database. I have maintain connections selected . A timeout of
    20 min and interval of 7 min. I'm not noticing connection pooling it looks
    like. When I hit the server with a bunch of requests, it opens connections to
    the DB, but then it shuts them all down after when I was looking with netstat.
    So it would not appear to be doing connection pooling. Any information would be
    useful. I thought it would maintain the connection across client requests
    since that was checked as well. Instead, it is connecting and then
    disconnecting therefore leading me to believe it is not maintaing connection
    between requests. Any help on this topic would be appreciated.

    Thanks,

    Chris


    crentz Guest

  2. #2

    Default CFMX 6.1 and Oracle 9i Connection Pooling

    I'm running CF MX 6.1 Enterprise with the Native Oracle driver and connecting
    to an Oracle 9i database. I have maintain connections selected . A timeout of
    20 min and interval of 7 min. I'm not noticing connection pooling it looks
    like. When I hit the server with a bunch of requests, it opens connections to
    the DB, but then it shuts them all down after when I was looking with netstat.
    So it would not appear to be doing connection pooling. Any information would be
    useful. I thought it would maintain the connection across client requests since
    that was checked as well. Instead, it is connecting and then disconnecting
    therefore leading me to believe it is not maintaing connection between
    requests. Any help on this topic would be appreciated.

    Thanks,

    Chris


    crentz Guest

Similar Threads

  1. Replies: 5
    Last Post: June 14th, 04:10 PM
  2. Connection Pooling Error
    By CRoesener in forum Coldfusion Database Access
    Replies: 0
    Last Post: June 8th, 02:57 PM
  3. Connection Pooling
    By Trevor Hartman in forum Coldfusion Server Administration
    Replies: 5
    Last Post: May 24th, 07:18 PM
  4. Oracle connection pooling
    By Lenny Shprekher in forum ASP.NET Web Services
    Replies: 0
    Last Post: December 9th, 04:22 PM
  5. Java Connection/Pooling Question
    By John Hibner in forum Informix
    Replies: 0
    Last Post: November 6th, 04:41 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