[jboss-user] [Datasource Configuration] New message: "Problem with number of database connections (Oracle)"
User development,
A new message was posted in the thread "Problem with number of database connections
(Oracle)":
http://community.jboss.org/message/519497#519497
Author : Michal Rorat
Profile : http://community.jboss.org/people/michal_rorat
Message:
--------------------------------------------------------------
Hi, I have a problem with configuring JBoss connetion to Oracle database. We are running
out of connections on Oracle machine because of this issue.
My configuration in oracle-ds.xml:
<local-tx-datasource>
<jndi-name>OracleDS</jndi-name>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<connection-url>jdbc:oracle:thin:@[dbname:port:sid]</connection-url>
<user-name>[user_name]<user-name>
<password>[password]</password>
<min-pool-size>0</min-pool-size>
<max-pool-size>60</max-pool-size>
I also have a library which creates its own connection pool with
min-pool-size=0
max-pool-size=10
And 5 MDBs with one connection reserver for each of them.
You might think that in this configuration after starting JBoss you will have 5
connections made to DB but I have 38! Even when I set max-pool-size in oracle-ds.xml to 5
it don't change the number of created connections which I get from Oracle Enterprise
Manager.
If I put for example 5 in min-pool-size the numer of connection created is 43.
I also tried to find out the configuration for ManagedConnectionPool MBean with this
command:
twiddle.bat invoke jboss.jca:service=ManagedConnectionPool,name=OracleDS
listFormattedSubPoolStatistics
Sub Pool Statistics:
Sub Pool Count: 1
---------------------------------
Track By Transaction: true
Available Connections Count: 60
Max Connections In Use Count:1
Connections Destroyed Count:2
Connections In Use Count:0
Total Block Time:0
Average Block Time For Sub Pool:0
Maximum Wait Time For Sub Pool:0
Total Timed Out:2
------------------------------------------------------------------------------------------
My questions are...
- how can I find the place where those connections are created?
- is there any other configuration for connection pools?
- is there a list of connections with a class name which created each one of them?
Regards,
Michal Rorat
--------------------------------------------------------------
To reply to this message visit the message page:
http://community.jboss.org/message/519497#519497