Results 1 to 2 of 2
Thread: connection pooling
- 06-24-2007, 05:42 PM #1
Member
- Join Date
- Jun 2007
- Posts
- 1
- Rep Power
- 0
connection pooling
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
- 06-27-2007, 02:50 PM #2
Senior Member
- Join Date
- Jun 2007
- Posts
- 132
- Rep Power
- 0
Similar Threads
-
connection problem
By subash in forum JDBCReplies: 5Last Post: 04-22-2008, 09:17 AM -
JSP - using connection cache
By Java Tip in forum Java TipReplies: 0Last Post: 01-30-2008, 09:54 AM -
no connection
By even in forum JDBCReplies: 15Last Post: 01-02-2008, 01:50 PM -
JDBC connection
By Java Tip in forum Java TipReplies: 0Last Post: 11-10-2007, 07:39 PM -
connection pool for db2
By paty in forum JDBCReplies: 1Last Post: 08-06-2007, 02:43 AM


LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks