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 ?