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.
Maybe this is that you are looking for:
Oracle Data Provider for .NET : Part II