[kal132]

Hi,
I have a web app running on jboss and oracle as database. My app is basically a reporting app

where I have many sql queries being called to get result from db.I am using JDBC connection pool

to get and return connection from the pool just before and after each query.There will be about

45-50 users accessing this application at the same time and I am trying to find out
1) howmuch should be the size of the connection pool.
2) What should be minimum no. of connections defined for the pool.
3) In case a user doesnt have any available connection how long will it look for new connection

before timing out. Can I change this default timeout.

This is urgent for me as its going into production next week.
Any response appreciated.
Thanks,
kal