Server not reachable issue with Progress9.1D09 database

Posted by habin123 on 18-Mar-2013 05:29

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

All Replies

Posted by gus on 18-Mar-2013 08:52

You are using an extrememly old release. The most recent version 9 release was 9.1E04, which came out in April 2006. Upgrading to that /may/ solve your problem but unfortunately I cannot remember very much about these old releases. The current release is 11.2.

This thread is closed