[
https://issues.apache.org/jira/browse/AMQ-7398?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17032530#comment-17032530
]
David Sheris commented on AMQ-7398:
-----------------------------------
Thanks
Jean, here you go
<beans xmlns="http://www.springframework.org/schema/beans";
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
<bean id="oracle-ds" class="org.apache.commons.dbcp2.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
<property name="url"
value="jdbc:oracle:thin:@ficdbs1-scan:1521/CDBP_app_ficdbpd1"/>
<property name="username" value="CAASDBO"/>
<property name="password" value="${jdbcpassword}"/>
<property name="poolPreparedStatements" value="true"/>
</bean>
</beans>
logs also
2020-01-28 17:34:05,617 | INFO | Refreshing
org.apache.activemq.xbean.XBeanBrokerFactory$1@675d3402: startup date [Tue Jan
28 17:34:05 EST 2020]; root of context hierarchy |
org.apache.activemq.xbean.XBeanBrokerFactory$1 | main
2020-01-28 17:34:06,544 | INFO | Loading properties file from URL
[file:/fcamqdrtp1/activemq/5.13.3.1/fcamqdrtp1-amq1//conf/default-vah.properties]
| com.sts.paas.stdutils.EncryptationAwarePropertyPlaceholderConfigurer | main
2020-01-28 17:34:06,545 | INFO | Loading properties file from URL
[file:/fcamqdrtp1/activemq/5.13.3.1/fcamqdrtp1-amq1//conf/vah-activemq.properties]
| com.sts.paas.stdutils.EncryptationAwarePropertyPlaceholderConfigurer | main
2020-01-28 17:34:07,010 | INFO | Using Persistence Adapter:
JDBCPersistenceAdapter(org.apache.commons.dbcp2.BasicDataSource@5d908d47) |
org.apache.activemq.broker.BrokerService | main
2020-01-28 17:34:07,297 | INFO | JMX consoles can connect to
service:jmx:rmi:///jndi/rmi://localhost:1099/jmxrmi |
org.apache.activemq.broker.jmx.ManagementContext | JMX connector
2020-01-28 17:34:07,811 | INFO | Database adapter driver override recognized
for : [oracle_jdbc_driver] - adapter: class
org.apache.activemq.store.jdbc.adapter.OracleJDBCAdapter |
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | main
2020-01-28 17:34:08,787 | INFO | Database lock driver override not found for :
[oracle_jdbc_driver]. Will use default implementation. |
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | main
2020-01-28 17:34:08,790 | INFO | Attempting to acquire the exclusive lock to
become the Master broker | org.apache.activemq.store.jdbc.DefaultDatabaseLocker
| main
and
2020-01-28 17:34:05,617 | INFO | Refreshing
org.apache.activemq.xbean.XBeanBrokerFactory$1@675d3402: startup date [Tue Jan
28 17:34:05 EST 2020]; root of context hierarchy |
org.apache.activemq.xbean.XBeanBrokerFactory$1 | main
2020-01-28 17:34:06,544 | INFO | Loading properties file from URL
[file:/fcamqdrtp1/activemq/5.13.3.1/fcamqdrtp1-amq1//conf/default-vah.properties]
| com.sts.paas.stdutils.EncryptationAwarePropertyPlaceholderConfigurer | main
2020-01-28 17:34:06,545 | INFO | Loading properties file from URL
[file:/fcamqdrtp1/activemq/5.13.3.1/fcamqdrtp1-amq1//conf/vah-activemq.properties]
| com.sts.paas.stdutils.EncryptationAwarePropertyPlaceholderConfigurer | main
2020-01-28 17:34:07,010 | INFO | Using Persistence Adapter:
JDBCPersistenceAdapter(org.apache.commons.dbcp2.BasicDataSource@5d908d47) |
org.apache.activemq.broker.BrokerService | main
2020-01-28 17:34:07,297 | INFO | JMX consoles can connect to
service:jmx:rmi:///jndi/rmi://localhost:1099/jmxrmi |
org.apache.activemq.broker.jmx.ManagementContext | JMX connector
2020-01-28 17:34:07,811 | INFO | Database adapter driver override recognized
for : [oracle_jdbc_driver] - adapter: class
org.apache.activemq.store.jdbc.adapter.OracleJDBCAdapter |
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | main
2020-01-28 17:34:08,787 | INFO | Database lock driver override not found for :
[oracle_jdbc_driver]. Will use default implementation. |
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | main
2020-01-28 17:34:08,790 | INFO | Attempting to acquire the exclusive lock to
become the Master broker | org.apache.activemq.store.jdbc.DefaultDatabaseLocker
| main
> PoolableConnectionFactory (IO Error: Connection reset by peer, Authentication
> lapse 204252 ms.) | org.apache.activemq.store.jdbc.JDBCPersistenceAdapter |
> main
> --------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: AMQ-7398
> URL: https://issues.apache.org/jira/browse/AMQ-7398
> Project: ActiveMQ
> Issue Type: Bug
> Components: AMQP, Broker
> Affects Versions: 5.13.1
> Environment: Non -PROD
> Reporter: David Sheris
> Assignee: Jean-Baptiste Onofré
> Priority: Major
>
> {color:#000000}I am getting the following error on RHEL7 Red Hat Openstack ,
> Migrating from REL 6 LINUX -Citric {color}
> {color:#000000}2020-01-27 11:54:49,331 | WARN | Could not get JDBC
> connection: Cannot create PoolableConnectionFactory (IO Error: Connection
> reset by peer, Authentication lapse 204252 ms.) |
> org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | main{color}
> {color:#000000}java.sql.SQLException: Cannot create PoolableConnectionFactory
> (IO Error: Connection reset by peer, Authentication lapse 204252 ms.){color}
> {color:#000000}ORACLE Connection drops after some time and only restating AMQ
> seems to reestablish{color}
>
> {color:#000000}ORACLE 12DB {color}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
