Description: This post demonstrates how to create a generic data source in your WebLogic domain using the WebLogic Administration console. MySQL database is used as example.
References: http://docs.oracle.com/cd/E21764_01/web.1111/e13737/jdbc_datasources.htm#i1204742
1. Login to the WebLogic Server Administration Console.
2. On the home page, select Data Sources which is under the Services section.
3. On the Summary of JDBC Data Sources section, click New.
4. After clicking New, select Generic Data Source from the drop down menu.
5. On the JDBC Data Source Properties page, supply the following information:
Name - The name of JDBC Data Source. This name is used in the configuration file (
config.xml).JNDI Name - Enter the JNDI path to where this JDBC data source will be bound. Applications look up the data source on the JNDI tree by this name when reserving a connection.
Database Type - Select the DBMS of the database that you want to connect to. If your DBMS is not listed, select Other.
6. Select the database driver. The JDBC drivers must be installed before using them.
7. Specify transaction options. Refer to the link given at the beginning of this post for more details of each transaction option.
8. Define the connection properties of your data source.
9. Test the configuration of your data source.
10. Select the servers or clusters on which you want to deploy the data source.
11. Save. The WebLogic server needs to be restarted for the changes to take effect.
No comments:
Post a Comment