Use these steps to configure the type4 JDBC provider for DB2 as well as various database types.
Library type | File name |
---|---|
DB2 |
|
Derby | ${WAS_APP_SERVER_ROOT}/ derby/lib/derby.jar |
Infomix Dynamic Server |
|
Oracle Enterprise Edition | ojdbc14.jar |
SQL Server Enterprise |
|
Type | JDBC provider |
---|---|
DB2 | DB2 Universal JDBC Driver Provider |
Derby | Derby JDBC Provider |
Infomix Dynamic Server | Informix JDBC Provider |
Oracle Enterprise Edition | Oracle JDBC Provider |
SQL Server Enterprise | IBM WebSphere embedded ConnectJDBC Provider for MS SQL Server |
Action type | Command |
---|---|
Database repositories | createIdMgrDBRepository |
Property extension repository | setIdMgrPropertyExtensionRepository |
Entry mapping repository | setIdMgrEntryMappingRepository |
Action type | Command |
---|---|
Database repositories | wsadmin> $AdminTask updateIdMgrDBRepository {-id database_ID -dbURL database_URL -JDBCDriverClass com.ibm.db2.jcc.DB2Driver} |
Property extension repository | wsadmin> $AdminTask setIdMgrPropertyExtensionRepository {-dbURL database_URL -JDBCDriverClass com.ibm.db2.jcc.DB2Driver -databaseType database_typ -dataSourceName data_source_nam -dbAdminId database_administrator_ID -dbAdminPassword database_administrator_password} |
Entry mapping repository | wsadmin> $AdminTask setIdMgrEntryMappingRepository {-dbURL database_URL -JDBCDriverClass com.ibm.db2.jcc.DB2Driver -databaseType database_type -dataSourceName data_source_name -dbAdminId database_admin_ID -dbAdminPassword database_administrator_password} |