[jboss-user] [EJB/JBoss] - EJB Managed Connection close after 4 Hours

Hello Community, Version: 4.0.4GA(build: CVSTag=JBoss_4_0_4_GA date=200605151000) OS: Linux 2.6.5-7.244-smp (i386) JVM Version: 1.4.2_03-b02 (Sun Microsystems Inc.) JVM Name: Java HotSpot(TM) Server VM MySQL Driver 5.0.4 We encouter problems with EJB and the underlying mysql connection after an import process of 4 hours. The import is aborted and the server.log shows Exception's as follows: | [t] 2007-03-12 11:36:21,881 [level] ERROR [class] org.jboss.ejb.plugins.LogInterceptor [sid] admin [msg] EJBException in method: public abstract de.mms_dresde | n.process.State de.xyz.process.ProcessInfo.getStatus() throws java.rmi.RemoteException, causedBy: | org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking timeout ( 100000 [ms] ); - nested throwable: (javax.resource.Res | ourceException: No ManagedConnections available within configured blocking timeout ( 100000 [ms] )) | at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:94) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:160) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:88) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadEntity(JDBCStoreManager.java:646) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadEntity(JDBCStoreManager.java:628) | at org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistenceManager.java:406) | at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.loadEntity(CachedConnectionInterceptor.java:252) | at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchronizationInterceptor.java:243) | at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158) | at org.jboss.ejb.plugins.EntityReentranceInterceptor.invoke(EntityReentranceInterceptor.java:126) | at org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:276) | at org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockInterceptor.java:104) | at org.jboss.ejb.plugins.EntityCreationInterceptor.invoke(EntityCreationInterceptor.java:68) | ... | As the problem occours after 4 hours i think there is a problem with opening and closing connections. Maybe this is related to this post: http://www.theserverside.com/discussions/thread.tss?thread_id=42193 The mysql-ds.xml describes as follows: | <local-tx-datasource> | <jndi-name>defaultDataSource</jndi-name> | <use-java-context>false</use-java-context> | <connection-url>jdbc:mysql://dbserver:3306/xxxxxx</connection-url> | <driver-class>com.mysql.jdbc.Driver</driver-class> | <user-name>xyz</user-name> | <password>xyz</password> | <min-pool-size>1</min-pool-size> | <max-pool-size>1</max-pool-size> | <blocking-timeout-millis>100000</blocking-timeout-millis> | <track-statements>true</track-statements> | <idle-timeout-minutes>5</idle-timeout-minutes> | <exception-sorter-class-name>com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter</exception-sorter-class-name> | <valid-connection-checker-class-name>com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker</valid-connection-checker-class-name> | <metadata> | <type-mapping>mySQL</type-mapping> | </metadata> | </local-tx-datasource> | Maybe you can give me a hint about the problem and how to solve it. Many thanks in advance! Greetings, Michael View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4027169#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...