Configure Data Source in Oracle WebLogic Server
How to Configure Data Source in Oracle WebLogic Server
By Sangu Patil
A data source is an object that enables a Java Database Connectivity (JDBC) client to obtain a database connection. WebLogic JDBC data sources provide database access and database connection management.
Step 1: Log on to WebLogic Server (Path – Services -> Data Sources -> New)
From the drop down, select Generic Data Sources.
Generic Data Sources: – Generic data sources and their connection pools provide connection management processes that help keep your system running efficiently.
GridLink Data Sources: – An event-based data source that adaptively responds to state changes in an Oracle RAC instance.
Multi data sources: – A multi data source is an abstraction around a group of generic data sources that provides load balancing or failover processing.
Step 2: Give the following details.
Name: – JDBC Data Source-Test
Database Type: – Oracle
JNDI Name: jdbc/TestDS < give the name of the database connection followed by DS, which is used in your application >
Step 3 – Select the database drive type – *Oracle’s Driver (Thin) for instance connections; Versions:9.0.1 and later.
Note – We are not using (Thin XA), XA data source should be never use with ADF/Fusion applications because it closes all cursors upon commit. Click Next.
Step 4: Provide the database connection details. Enter name, host name, port, username, password. Click next and test the connection.
Step 5: Select the server in which you want to create the data source and click finish.
About the Author
Sangu Patil is working with Trinamix Systems as a Technical Consultant. He has 5 years of experience in Oracle applications. His focus areas are OAF and ADF.