Kbase P58380: Server not reachable or possible RPC error running SQL-92 stored procedures connecting to Oracle dat
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/10/2006 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D 64-bit
Linux Intel
SYMPTOM(s):
[JDBC Progress Driver]:Server not reachable possible RPC error
Error occurs when running sql-92 stored procedure
The stored procedure connects to Oracle database
Using Oracle's thin JDBC driver
Oracle 9.2 instance
The thin JDBC driver used is ojdbc14.jar
Able to connect to Oracle database using this driver from standalone Java application on the same machine when SQL-92 stored procedure is run
When running the standalone Java application, the JDK/JRE used is 1.4
Notes from Oracle regarding JDBC driver set up
On Solaris/Digital Unix:
- Add [ORACLE_HOME]/jdbc/lib/classes111.zip and
[ORACLE_HOME]/jdbc/lib
ls_charset11.zip to your CLASSPATH.
(Add classes12.zip and nls_charset12.zip if JDK 1.2.x or 1.3 is
used. Add ojdbc14.jar and nls_charset12.zip if JDK 1.4 is used.)
- Add [ORACLE_HOME]/jdbc/lib to your LD_LIBRARY_PATH.
CAUSE:
The ojdbc14.jar was for JDK1.4. Progress SQL-92 engine uses JDK1.3.1 on Linux to run stored procedures
FIX:
Modify $DLC/bin/java_env to include Oracle's classes12.zip and oracleJdbc.jar in the CLASSPATH environment variable instead of ojdbc14.jar. No other change was required.