Today we talk about PeopleSoft Remote Database Connection (RDC) setup, It
require correct database bin directory path and classpath (jdbc) in app server
config file.
If it is not setup properly or wrong jdbc version you may get below error. JDBC deriver usually
ship with 11g database, but at times it doesn’t work so you have to use old 10g
jdbc files in folder and classpath.
Java
Exception: java.lang.NoClassDefFoundError: Could not initialize class
oracle.jdbc.driver.DMSFactory: during call of
com.peoplesoft.pt.remotedb.PSJDataSource.TestConnection. (2,763)
MISCTOOLS_WRK.TEST_CONNECT.FieldChange PCPC:283 Statement:3
The noted Java error was thrown during a call of the given method.
The noted Java error was thrown during a call of the given method.
Download:
Download if it is not available with database installation:
ojdbc14.jar
http://www.oracle.com/technetwork/database/enterprise-edition/jdbc101040-094982.html
ojdbc14.jar
http://www.oracle.com/technetwork/database/enterprise-edition/jdbc101040-094982.html
Copy to %ORACLE_HOME%/jdbc/lib
Add to CLASSPATH=%Oracle_Home%/jdbc/lib
Or
Add to CLASSPATH=%ORACLE_HOME%/jdbc/lib/ojdbc14.jar
Add to CLASSPATH=%ORACLE_HOME%/jdbc/lib/orai18n.jar
Add to CLASSPATH=%ORACLE_HOME%/jdbc/lib/orai18n.jar
