I have an issue connecting to Progress 9.1DO9 database from Java code.The select query executes fine but at times it gives 'Server not reachable '(Exception::java.sql.SQLException: [JDBC Progress Driver]:Server not reachable or possible RPC error) exception is thrown.Below is the stack trace of the issue:
Exception::java.sql.SQLException: [JDBC Progress Driver]:Server not reachable or possible RPC error
at com.progress.sql.jdbc.JdbcProgress.createSQLException(JdbcProgress.java:6562)
at com.progress.sql.jdbc.JdbcProgress.standardError(JdbcProgress.java:6736)
at com.progress.sql.jdbc.JdbcProgress.SQLUTFPrepare(JdbcProgress.java:4557)
at com.progress.sql.jdbc.JdbcProgressConnection.prepareStatement(JdbcProgressConnection.java:499)
at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:262)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:307)
Issue gets resolved only when actions are performed at DB end for connection clean up and probably SQL Broker restart also.Please help us resolve the issue as we are not able to trace the root cause of the exception.
Thanks in advance
