Datasource is configured using camelcontext.But we are facing Connection reset.
Issue
- we are getting below issue
2018-01-25 17:52:58,372 | ERROR | ault-workqueue-2 | RetrieveErrorResponseService | 410 - csg-base - 0.0.5.SNAPSHOT | IO Error: Connection reset
java.sql.SQLRecoverableException: IO Error: Connection reset
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:792)[405:wrap_file__home_fueadmin_.m2_repository_com_oracle_ojdbc6_11.2.0_ojdbc6-11.2.0.jar:0.0.0]
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)[405:wrap_file__home_fueadmin_.m2_repository_com_oracle_ojdbc6_11.2.0_ojdbc6-11.2.0.jar:0.0.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)[405:wrap_file__home_fueadmin_.m2_repository_com_oracle_ojdbc6_11.2.0_ojdbc6-11.2.0.jar:0.0.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)[405:wrap_file__home_fueadmin_.m2_repository_com_oracle_ojdbc6_11.2.0_ojdbc6-11.2.0.jar:0.0.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)[405:wrap_file__home_fueadmin_.m2_repository_com_oracle_ojdbc6_11.2.0_ojdbc6-11.2.0.jar:0.0.0]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)[405:wrap_file__home_fueadmin_.m2_repository_com_oracle_ojdbc6_11.2.0_ojdbc6-11.2.0.jar:0.0.0]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)[356:org.apache.servicemix.bundles.commons-dbcp:1.4.0.3]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)[356:org.apache.servicemix.bundles.commons-dbcp:1.4.0.3]
- can you please suggest configuration parameter for below data source
<bean class="oracle.jdbc.pool.OracleDataSource"
destroy-method="close" id="someDb">
<property name="driverType" value="$[driverType]"/>
<property name="serverName" value="$[serverName]"/>
<property name="databaseName" value="$[DBdatabaseName]"/>
<property name="portNumber" value="$[DBportNumber]"/>
<property name="user" value="$[bDBuser]"/>
<property name="password" value="$[DBpassword]"/>
</bean>
Environment
- Red Hat JBoss Fuse
- 6.3.0
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.