Problem: There are two Web servers in the production environment, 227 and 228 respectively, the application code deployed is synchronized daily, the two sides are exactly the same, but some pages query data, 227 no results, and the background report the Java array out of bounds error, and 2,281 tangent normal. After the developer to adjust the page program, add fault-tolerant processing, 227 of the query returned to normal, but the query results in the date value is displayed in English, and 228 is the normal format of 2014-01-01 words.
227 Environment: WebLogic 8.1.0.0JDK jdk141_03228 Environment: WebLogic 8.1.6.0JDK jdk142_11 resolution process: started to suspect that the JDK version inconsistency caused by copying 228 of the JDK environment to 227 hosts, and modify the startweblogic.sh to start the Times connection pool error. Then look at the config file on both sides, found that the database driver used on both sides is different, 227 using "Weblogic.jdbc.oci.Driver", 228 is using " Oracle.jdbc.driver.OracleDriver ", after modifying the 227 driver for the Oracle JDBC, resumes normal after reboot. Drive Position:when installing WebLogic, a third-party driver is
WL_HOME
\server\ext\jdbc,若要使用这里的驱动有两个办法:
installed
1)在启动脚本CLASSPATH中添加驱动变量;2)把驱动jar包拷贝至系统驱动目录下
WL_HOME
\server\lib
Configuration method: Thin mode for Oracle JDBC
[Connection Pool Property value]
URL:jdbc:oracle:thin: @IP ADDRESS:1521:ORCL
Driver Classes:oracle.jdbc.driver.OracleDriver
Properties (key=value): user= Database user Name
password= Password
Dll=ocijdbc8 (not to be filled)
Protocol=thin (not to be filled)
WebLogic Page Application Query Oracle database background error or page date format display errors