0 Replies Latest reply on Feb 10, 2003 2:55 PM by Ana Roizen

    db connections never used

    Ana Roizen Newbie

      Hi,
      I´m running a J2EE app under JBoss 2_4_10 and I have a question about the behaviour of the pool.
      I configured the pool for my user "desa" with a minsize of 30. (I include the whole datasource configuration below)
      When I do start the JBoss, I can see at my DB's Monitor that 30 new sessions have been created for user "desa".That´s great.
      ...But as soon as I run my application, other 3 new sessions/connections are created for user "desa".
      So I look at every session's last call time: the first 30 have never been called since start up time. The other 3 have a recent lastcall time.
      So a question arises: why does the pool create new sessions instead of using one of the first 30 ?

      Lately it´s been happening that the pool exceeds the DB's maximum connection size(450), and my application dies...
      Is there a way to track the pools's behaviour?
      Can anyone help me?
      Thanks,
      Ana Roizen

      PS:
      The server is runnig on a Solaris 2.8 , and the DB version is Oracle 8.1.7.

      The pool configuration is the folowing:

      true
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
      true
      120000
      900000
      1200000
      true
      false
      desa
      true
      1.0
      300
      30
      desa
      intrad
      true
      jdbc:oracle:thin:@dbserver:1521:db8
      true