Connection Pooling How To ?

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

[933 byte] By [Jasdeep.Singha] at [2007-11-27 5:07:51]