问题背景
WebLogic 10.3.5.0
创建WebLogic域之后,新建一个受管服务用来部署ADF程序,把相关libraries添加到此服务,然后部署ADF程序。说来也奇怪,只有一个页面报如下错误
- oracle.jbo.DMLException: JBO-26061: Error while opening JDBC connection.
- at oracle.jbo.server.ConnectionPool.createConnection(ConnectionPool.java:253)
- at oracle.jbo.server.ConnectionPool.instantiateResource(ConnectionPool.java:168)
- at oracle.jbo.pool.ResourcePool.createResource(ResourcePool.java:546)
- at oracle.jbo.pool.ResourcePool.useResource(ResourcePool.java:327)
- at oracle.jbo.server.ConnectionPool.getConnectionInternal(ConnectionPool.java:104)
- Truncated. see log file for complete stacktrace
- java.sql.SQLException: ORA-01005: null password given; logon denied
于是将程序直接部署到AdminServer下,则一切正常,于是检查libraries,发现oracle.jrf.system.filter 和oracle.pwdgen(11.1.1,11.1.1.2.0) 未添加。(具体由于哪个引起还未验证)
另外 网上看到一下解决方案,尚未验证
This is because, the ADF model project fails to register the password with the app server which cause this SQL exception.
In order to overcome this error, edit the EXTRA_JAVA_PROPERTIES and append -Djps.app.credential.overwrite.allowed=true property under the setSOADomainEnv.cmd (In Windows) or setSOADomainEnv.sh (In Linux) file as follows. This file will be located under <<Middleware_Home>>\user_projects\domains\<Your_Domain_Name>\bin folder.
set EXTRA_JAVA_PROPERTIES=%EXTRA_JAVA_PROPERTIES% -Djps.app.credential.overwrite.allowed=true -da:org.apache.xmlbeans...
Restart the Oracle Weblogic server.
http://sathyam-soa.blogspot.com/2011/03/adf-runtime-db-connection-error.html