WebLogic Server manages the databases you can use and allows you to access configured databases through JDBC data sources. If you wish to use a new database, there must be a JDBC connection pool and data source set up that allows you to access that database. You can set up a new connection pool and data source in the WebLogic Server console.
WebLogic Server includes pre-configured drivers for accessing Microsoft SQL Server and Oracle. These drivers are listed in the WebLogic Server console. If you want to use a driver other than one of the recommended drivers, you may need to install the driver yourself and add it to your class path.
To Change the Data Source Used by a Database Control
To Access the WebLogic Server Console
You can use the WebLogic Server console to configure a new connection pool and data source in WebLogic Server. If you are running WebLogic Workshop and WebLogic console on the same computer, you can access the console as shown in the following procedure. Otherwise, check with your system administrator to configure WebLogic Server.
Note. For more information, see How Do I: Administer WebLogic Server Through the Administration Console?
Next, you must create a new connection pool.
To Create a New Connection Pool
Once you set up a connection pool, you must set up a data source based on that connection pool. The JNDI name you provide for the data source is the name that you will use to set the data-source-jndi-name attribute of the connection tag for the Database control.
To Set Up a Data Source Based on a Connection Pool
Clear the Honor Global Transactions check box if necessary. By default this check box is selected, which is the desired setting in nearly all cases. When selected, WebLogic Workshop provides default transaction semantics for web service operations using this data source. These transaction semantics include wrapping database operations that occur within a web service operation in a transaction. If you check this option, you may not attempt to control transaction semantics directly (for example, via calls to java.sql.Connection.setAutoCommit). The sample data source cgSampleDataSource honors global transactions.
To learn more about WebLogic Workshop's default transaction semantics, see Transactions in WebLogic Workshop.
For more information on configuring connection pools and data sources, see Configuring WebLogic JDBC Features.
How Do I: Use a Database from a Web Service?
How Do I: WebLogic Workshop-Enable an Existing WebLogic Server Domain?