JDE - JDBC Driver的安裝心得

Check JDBC Driver version:

http://www.oracledistilled.com/java/determine-jdbc-driver-version/

[oracle@e1oas03 OracleAS_1]$ head jdbc/Readme.txt
Oracle JDBC Drivers release 10.1.0.2.0 (10g) README
=====================================================
What Is New In This Release ?
-----------------------------
New classes file name for JDK 1.4 and beyond
    Beginning with this release the classes files for JDK 1.4 and


//*******************************************************************************************************************

[oracle@e1oas03 20131203]$ /u01/OracleAS_1/jdk/bin/java -cp ./:/u01/OracleAS_1/jdbc/lib/ojdbc14.jar JDBCVersionInfo
Driver Name: Oracle JDBC driver
Driver Version: 10.1.0.5.0

Applicable for Oracle 10g R2 JDBC Driver:

Oracle JDBC driver patch p4711863 is required for Oracle Application Server 10g R3 (10.1.3.1.0). This patch was built for database release 10.2.0.2, and can only be applied to this release. At this time there is no patch for database release 10.2.0.3, however, it has been verified that JDBC 10.2.0.2 is compatible with JDBC 10.2.0.3.

Applicable for Oracle 11g JDBC Driver:

Oracle 11g JDBC driver is supported with Oracle Application Server 10g (10.1.3.x) only.




透過Oracle官方建議的方式，deploy一個小的程式來檢查  JDBC Driver version。

http://<server>:<port>/drvtest/dbdetails.jsp

Driver Version: 10.1.0.5.0

透過Oracle官方建議的方式，透過Server Manager 升級 JDBC Driver version。

再檢查一次
http://<server>:<port>/drvtest/dbdetails.jsp
Driver Version: 10.1.0.5.0

手動進入ASC，安裝 ojdbc5.jar 11.1.0.7.0 ，再手動修改 $ORACLE_HOME/j2ee/<container-name>/config/system-application.xml

<import-shared-library name="oracle.jdbc" min-version="10.1.0.7"/>


再檢查一次
http://<server>:<port>/drvtest/dbdetails.jsp
Driver Version: 11.1.0.7.0