[jboss-user] [JCA/JBoss] - Re: Connection closed problem after DB restart.

[jackminder]

I have read all FAQ pages regarding a restart of the Database.  However I am not 100% sure if I should still see errors like below in the server.log for a length of time (ex. 8hrs)?  Before when restarting the DB the J2EE app would just fail but now new entries are created in db and application is fine.  My assumption is due to opening Min 50 connections in the pool it takes time for the connection checker to close all dead connections since this is a Dev environment and not all connections are actually used.   

In the future could I modify the transaction-service.xml and turn debugging off to eliminate these errors?


  | Serverlog Errors:
  | SQLException occurred: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ); - nested throwable: (javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ))
  | 


  | My JCA config
  | <!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->
  |     <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>
  | 
  |     <!-- Checks the Oracle error codes and messages for fatal errors -->
  |     <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
  | 
  |         <!-- sql to call when connection is created -->
  |         <new-connection-sql>select 1 from dual</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>select 1 from dual</check-valid-connection-sql>
  | 
  |     <user-name>******</user-name>
  |     <password>*****</password>
  |     <min-pool-size>50</min-pool-size>
  |     <max-pool-size>50</max-pool-size>
  |     <idle-timeout-minutes>5</idle-timeout-minutes>        
  |     <blocking-timeout-millis>30000</blocking-timeout-millis>
  | 


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4105000#4105000

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4105000