that looks as if the connection pool is returning a connection that may have been terminated on the server... it may be possible to configure the pool to validate a connection before returning.
On 6 February 2013 10:17, mandar.wanpal <[email protected]> wrote: > Hi All, > > We have configured AMQ in lease DB locking mechanism. I am facing strange > issue in which AMQ after some random time once its up, crashes throwing > below error. > > 2013-02-04 22:49:45,168 | WARN | <hostname>, failed to update lease: > java.sql.SQLRecoverableException: IO Error: Connection reset | > org.apache.activemq.store.jdbc.LeaseDatabaseLocker | ActiveMQ Cleanup Timer > java.sql.SQLRecoverableException: IO Error: Connection reset > > below is my activemq.xml snap for jdbc config. > > <persistenceAdapter> > > <jdbcPersistenceAdapter lockKeepAlivePeriod="5000" > lockAcquireSleepInterval="16000" dataDirectory="${activemq.base}/data" > dataSource="#oracle-ds"> > <databaseLocker> > <lease-database-locker/> > </databaseLocker> > </jdbcPersistenceAdapter> > </persistenceAdapter> > > > <bean id="oracle-ds" > class="org.apache.commons.dbcp.BasicDataSource" > destroy-method="close"> > <property name="driverClassName" > value="oracle.jdbc.driver.OracleDriver"/> > <property name="url" value="jdbc:oracle:thin:@ > (DESCRIPTION = > (ADDRESS_LIST = (ADDRESS = (PROTOCOL = > TCP)(HOST > = <host ip>)(PORT = 1521))) > (CONNECT_DATA = (SERVER = > DEDICATED)(SERVICE_NAME = <servicename>)) )" /> > <property name="username" value="<username>"/> > <property name="password" value="<password>"/> > <property name="maxActive" value="5"/> > <property name="initialSize" value="2"/> > <property name="maxIdle" value="2"/> > <property name="minIdle" value="0"/> > <property name="poolPreparedStatements" value="true"/> > </bean> > > > Has someone faced such error before. what could be causing this. This setup > that we are doing is pretty new and yet we are not having any traffic on > it. > > > > ----- > Regards, > Mandar Wanpal > Email: [email protected] > -- > View this message in context: > http://activemq.2283324.n4.nabble.com/Failed-to-update-lease-Oracle-connection-Reset-tp4662859.html > Sent from the ActiveMQ - User mailing list archive at Nabble.com. > -- http://redhat.com http://blog.garytully.com
