0 Replies Latest reply on May 22, 2007 10:12 AM by jsbhangra

    Connection Pooling  How To ?

    jsbhangra

      Hi All ,

      i am developing a struts based web-application with JBoss 4.0.5 as Application Server and Oracle 10g Express edition .
      I am configuring my application for connection pooling .
      I have tried following methods :
      1. Oracle Connection Pooling following thius link http://www.lc.leidenuniv.nl/awcourse/oracle/java.920/a96654/connpoca.htm
      2. Configuring Jboss's Internal Container Level Connection pooling simply creating the datasources
      3. JDBC level Connection Pooling

      but unluckily did not succeed in any of these method .
      The application works OK with Second method but When it is being hit with 200 request/second The pool gets exhaulsted .

      i am unable to decide which approach i should be using as my application can receive large no. of requests around 1000/sec ?

      Please help me out ,

      Tell some useful link if possible ..

      Regards Jasdeep