Topics: |
This section describes how to configure JDBC providers for the H2 database and Omni-Payer DB2 database.
How to: |
This section describes how to configure a JDBC provider for the H2 database, which will be used to store the Omni-Payer configuration database location.
The Create new JDBC provider pane opens, as shown in the following image.
Parameter |
Value |
---|---|
Database type |
User-defined |
Implementation class name |
org.h2.jdbcx.JdbcDataSource |
Name |
H2 Provider |
Description |
H2 JDBC 2.0-compliant Provider configuration |
The Enter database class path information pane opens, as shown in the following image.
C:/h2-1.3.176.jar
You can download the library from http://www.h2database.com/html/download.html.
Note: The H2 .jar file for IBM WebSphere Application Server version 8.5.5 in the AIX environment .jar must be version 1.4.186 or higher (for example, h2-1.4.186.jar).
This data source will be used by the Omni-Payer application to get a connection configuration (metadata) data source.
The Enter basic data source information pane opens, as shown in the following image.
Property |
Value |
---|---|
Property 1: |
|
Name |
auth |
Value |
Container |
Property 2: |
|
Name |
type |
Value |
javax.sql.DataSource |
Property 3: |
|
Name |
pooled |
Value |
true |
Property 4: |
|
Name |
driverClassName |
Value |
org.h2.Driver |
Property 5: |
|
Name |
username |
Value |
sa |
Property 6: |
|
Name |
|
Value |
|
Property 7: |
|
Name |
password |
Value |
password |
Property 8: |
|
Name |
URL Note: The absolute path must be used to define where the production database will be written to. In this case, write it to /prog/lc10683/prod-db (directory). Replace /prog/lc10683/prod-db with a site-specific directory. |
Value |
jdbc:h2:/prog/lc10683/prod-db/prodDb;MVCC= TRUE;LOCK_TIMEOUT=10000;DB_CLOSE_ON_EXIT= FALSE |
Property 9: |
|
Name |
numTestsPerEvictionRun |
Value |
3 |
Property 10: |
|
Name |
testOnBorrow |
Value |
true |
Property 11: |
|
Name |
testWhileIdle |
Value |
true |
Property 12: |
|
Name |
maxActive |
Value |
-1 |
Property 13: |
|
Name |
maxIdle |
Value |
30 |
Property 14: |
|
Name |
maxWait |
Value |
10000 |
Property 15: |
|
Name |
testonReturn |
Value |
false |
Property 16: |
|
Name |
validationQuery |
Value |
Select 1 |
Property 17: |
|
Name |
jdbcInterceptors |
Value |
ConnectionState |
Property 18: |
|
Name |
validationInterval |
Value |
15000 |
Property 19: |
|
Name |
maxAge |
Value |
600000 |
Property 20: |
|
Name |
timeBetweenEvictionRunsMillis |
Value |
5000 |
Property 21: |
|
Name |
minEvictableIdleTimeMillis |
Value |
60000 |
Property 22: |
|
Name |
removeAbandonedTimeout |
Value |
120 |
How to: |
This section describes how to configure a JDBC provider for the Omni-Payer DB2 database.
The Create new JDBC provider pane opens.
Note: Use a site-specific directory of where the database drivers reside.
jdbc/Omni-Workflow
The Enter database specific properties for the data source pane opens.
Note: The Database name, server name, and port number in this example are for documentation purposes. You should use a site-specific database name, server name, and port number as it relates to Omni-Payer.
The General Properties pane opens, as shown in the following image.
Note: When adding additional JNDI database names, proceed to Step 23 in this procedure.
Note: The Alias, User ID, and Password in this example are for documentation purposes. You should use a site-specific alias, user ID, and password as it relates to Omni-Payer
Note: For documentation purposes, use a site-specific node.
Note: This value changes for each schema as it relates to a JNDI data source.
A confirmation message indicates that connection was successful.