Results 1 to 2 of 2
  1. #1
    kal132 is offline Member
    Join Date
    Jun 2007
    Posts
    1
    Rep Power
    0

    Default 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

  2. #2
    bbq
    bbq is offline Senior Member
    Join Date
    Jun 2007
    Posts
    132
    Rep Power
    0

Similar Threads

  1. connection problem
    By subash in forum JDBC
    Replies: 5
    Last Post: 04-22-2008, 09:17 AM
  2. JSP - using connection cache
    By Java Tip in forum Java Tip
    Replies: 0
    Last Post: 01-30-2008, 09:54 AM
  3. no connection
    By even in forum JDBC
    Replies: 15
    Last Post: 01-02-2008, 01:50 PM
  4. JDBC connection
    By Java Tip in forum Java Tip
    Replies: 0
    Last Post: 11-10-2007, 07:39 PM
  5. connection pool for db2
    By paty in forum JDBC
    Replies: 1
    Last Post: 08-06-2007, 02:43 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •