I have already talked about how to create the JNDI data source for OC4J and how to use it in BI Publisher. The same configuration for the OC4J can be also applied to Oracle Application Server. But how about Oracle WebLogic Server?
Today I’ll talk about how to create a database connection pool and register with JNDI on WebLogic Server.
JDBC Data Source with JNDI Creation on WebLogic Server
Here is a list of steps to create the JDBC/JNDI data source.
1. Login to WebLogic Server Administrative Console
2. Click ‘JDBC’ link within ‘Domain Configuration’ section
3. Click ‘New’ button
4. Type the data source name
5. Type JNDI Name
6. Select Database type
7. Select Database Driver
8. Click ‘Next’ button
9. Leave all the parameters as they are and click ‘Next’ button
10. Type Database Name (SID)
11. Type Database Hostname
12. Type Database Port
13. Type Database Username/Password
14. Click ‘Next’ button
15. Click ‘Test Configuration’ button to test the database connection
16. Note: Make sure you get ‘Connection test succeeded’ message.
17. Click ‘Next’ button
18. Select ‘AdminServer’ checkbox and click ‘Finish’ button
Once you get a message below your JNDI data source is now created at the WebLogic server.
At this point you should have a working JNDI data source on the WebLogic server so you can register it in BI Publisher as shown in the yesterday’s post, Register JNDI Connection in BI Publisher, and start using it!