CFMX 6.1 and Oracle 9i Connection Pooling

Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.

  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. Similar Questions and Discussions

    1. slow connection - pooling is a solution?
      Hi, Every time, I create a connection to mySQL server, it takes about 3 seconds before the connection is made. The server is at the other side of...
    2. Connection Pooling Error
      Our development team has inherited a web site written in Cold Fusion. In some situations we are now getting an error message "HTTP connection...
    3. Connection Pooling
      Hi, Every now and then (once a week maybe), I get this error on my page saying Timeout Expired. The timeout period elapsed prior to obtaining a...
    4. Oracle connection pooling
      Hi, I am getting issues that Oracle collecting opened sessions (connections) from my webservice using regular System.Data.OleDb.OleDbConnection...
    5. Java Connection/Pooling Question
      Hello Everyone, I received an inquiry from one of our developers about a pooling situation he is trying to code for. Not being a java or JDBC...
  3. #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

Posting Permissions

  • You may not post new threads
  • You may 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