Create a data source and connection pool.
About this task
Make sure that you create or establish the location of
the database for Decision
Center (see Mandatory: Create the databases). For a list of supported databases, consult IBM support site
Note: Unless you are using
Derby Embedded, make sure that your database is running before creating
the data source.
Procedure
- In the WebLogic Server Administration
Console, in Domain Structure, under
your domain select Services > Data
Sources.
- In the Summary of JDBC Data Sources page,
on the Configuration tab, in the Data
Sources table, click .
- Give a name to your data source (for example, Decision
Center Data Source) and type jdbc/ilogDataSource for
the JNDI name.
- Select your database type and click Next.
- In the next panel, select a database driver and click Next.
Tip: Best practice is to use a non-XA driver.
- In the panel that displays transaction options, keep the
default options and click Next.
- Define the connection properties and click Next.
For Derby Embedded:
| Property |
Value |
|---|
| Driver Class Name |
org.apache.derby.jdbc.EmbeddedDrive |
| URL |
jdbc:derby:c:\dcdb |
| Database user name |
dcdbUser |
| Password |
dcdbUser |
Derby Network users also need the following:
| Property |
Value |
|---|
| Host name |
localhost |
| Port number |
1527 |
- In the next page, click Test Configuration to
ensure that the connection pool is operational.
- Click Next.
- In the Servers table, select AdminServer and
click Finish.