I am running my application on Jboss 4.0.4.GA and Jboss 4.0.4.c and on both of them on the
ManagedConnectionPool MBEAN
ConnectionCreatedCount (Keep going up)
ConnectionDestroyedCount (Keep going up )
InUseConnectionCount (Only goes up until managed connection error is thrown and
application crashes).
Other Information
----------------------
- Log file:
I see no entry for any connection leak or house keeping message.
I can't see any message related to IDLE REMOVERrunning.
- I am retrieving the connection using getConnection() only, no user/passwd. This was
working fine on jboss-4.0.2 but not since then.
- I have two hibernate applications running on this jboss which use same database but are
running fine and aren't using JNDI pooling.
Oracle-ds.xml file
-------------------------
| <?xml version="1.0" encoding="UTF-8"?>
| <datasources>
| <local-tx-datasource>
| <jndi-name>jdbc/oracle</jndi-name>
|
<connection-url>jdbc:oracle:thin:@localhost:1521:proddb</connection-url>
| <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
| <user-name>user</user-name>
| <password>pass</password>
|
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
| <min-pool-size>20</min-pool-size>
| <max-pool-size>150</max-pool-size>
| <idle-timeout-minutes>1</idle-timeout-minutes>
| <blocking-timeout-millis>7000</blocking-timeout-millis>
| <!-- sql to call when connection is created
| <new-connection-sql>some arbitrary sql</new-connection-sql>
| -->
| <!-- sql to call on an existing pooled connection when it is obtained from
pool - the OracleValidConnectionChecker is prefered
| <check-valid-connection-sql>some arbitrary
sql</check-valid-connection-sql>
| -->
| <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional)
-->
| <metadata>
| <type-mapping>Oracle9i</type-mapping>
| </metadata>
| </local-tx-datasource>
|
| </datasources>
|
Please, any ideas are welcome. I am confused as to why the idle remover is not running and
why are the inUseConnections not coming down even when no one is connected to the
application for hours.
Thanks,Kazam.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3978853#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...