WebLogic Page Application Query Oracle database background error or page date format display errors

Source: Internet
Author: User

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\libConfiguration 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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.