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#3978853
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3978853
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
