Saturday, 27 August 2011

How to create datasource for Oracle Database Express Edition in weblogic 11g (10.3.5)

1. Login to weblogic administrator console
2. In the Left pane (Domain Structure) we find Services tree. Expand the tree again
   we find Data Sources link. Click that link.

3. we can find now datasources configuratin page. Click the New button to add the datasource.
   when we click the button we find three options select "Generic Data Source"
4. Now we find the page to create new jdbc data source. Now try to fill the JDBC Data Source
   properties. Provide the Datasource name, JNDI name as shown in the screen shot and select the
   Database type as "Oracle"
Weblogic 11g Datasource page

5. Now select the Oracle Driver which is appropriate to our Database.Click the Next button.
   Leave the settings for "Transactions Options" as it is. Click the Next button.


6. Since we are going to connect Oracle Express Database provide the default database name "XE"
   hostname,port,database username and password of Oracle Database Account. Click the Next button

7. Now click the button "Test Configuration" to test whether all parameters to Database are correct.
   Message in green color will be displayed if all of our settings are correct as shown in the screen shot.
   Click the Next Button

8. Now select the targets i.e. to which server the datasource to be deployed. currently on the screen shot
   there is only one server is installed. so select that server as target. Click the "Finish" button and now
   the configuration for Datasource is completed and now we can see the screenshot of list of datasources
   available in the server.


No comments:

Post a Comment