Folk,
Hello. This discussion continues https://community.oracle.com/thread/4068699?start=0&tstart=0 .
I have developed 2 applications in JDeveloper 11.1.1.6.0 with Integrated WebLogic Server 10.3.5.0 and Production WebLogic Server 10.3.6.0. The 2 applications are running in the same database instance.
I have deployed the first application to Production WebLogic Server 10.3.6.0 successfully and test the application correctly in browser.
JDBC Data Source is working correctly for the first application !
But JDBC Data Source cannot work correctly for the 2nd application as below:
In JDeveloper, using Database connection URL, the 2nd application run correctly for each page.
After I have deployed the second application to Production WebLogic Server 10.3.6.0, I copy/paste the test point from EM to Browser and copy/past the rest of URL from JDeveloper to browser and test the 2nd application. But the data is not displayed out of database table in browser. The error message is:
ORA-01005: Null Password given. Logon denied. java.lang.NullPointer Exception.
Because of the above error, in JDeveloper, I change connection type from Database URL to Database Source
java:comp/env/jdbc/My2ndAppDS or jdbc/My2ndAppDS, but the application cannot run correctly and gets the error message below:
Error: While trying to lookup 'jdbc.My2ndAppDS' didn't find subcontext 'jdbc'. Resolved. java.lang.NullPointerException.
JDBC Data Source even cannot run my 2nd application correctly in JDeveloper ! JDBC Data Source definitely cannot deploy my 2nd application correctly.
In the thread https://community.oracle.com/thread/4068699?start=15&tstart=0 , Timo Hahn told me to create a small application and test the JDBC Data Source. Timo said that "Run it locally (don't forget to define hte data source in hte intergrated WLS via the console application!)."
I am getting confusing regarding Integrated WLS console because I never use Integrated WLS console. Integrated WLS is 10.3.5.0.
When deploy the application, I deploy to production WLS 10.3.6.0. and its console URL is http://192.168.122.1:7003/console. I deploy and test the application in this console.
Now, I have just checked Integrated WLS console http://192.168.196.102:7101/console.
The settings for the 2nd application has the same 9 tabs with Production below:
Overview
Deployment Plan
Configuration
Security
Target
Control
Testing
Monitoring
Notes
I have checked each tab and don't see anywhere to define "JDBC Data Source"!
I assume that something is missing in either Integrated WLS console or Production WLS console causes JDBC Data Source cannot work correctly for my 2nd application.
I have 2 questions:
1) Where to define the Data source in Integrated WLS console http://192.168.196.102:7101/console for my 2nd application ?
2) Do we need to define Data Source in Production WLS console http://192.168.122.1:7003/console for my 2nd application ? Where to define it ?
Thanks in advance.