Adapter for JDBC 10.3 | webMethods Adapter for JDBC Documentation | webMethods Adapter for JDBC Installation and User’s Documentation | JDBC Driver Specific Properties | DB2 | DB2 Universal Type 2
 
DB2 Universal Type 2
DataSource
Transaction Type
DataSource Class
NO_TRANSACTION, LOCAL_TRANSACTION
com.ibm.db2.jcc.DB2SimpleDataSource
XA_TRANSACTION
com.ibm.db2.jcc.DB2XADataSource
Other Properties
Specify the parameters in the Other Properties field:
Parameter
Description
driverType
Required.
driverType=2
readOnly
Creates a read only connection.
readOnly=true
currentSchema
Specifies the default schema name used to qualify unqualified database objects in dynamically prepared SQL statements.
currentSchema=YourSchemaName
loginTimeout
Maximum time in seconds to wait for the DataSource object to connect to a data source.
loginTimeout=number
Required Connection Property Fields
Driver
Server Name
User
Password
Database Name
Port Number
Network Protocol
DB2 Universal Type 2 for UDB 8.1, 9.1, and 9.5
Yes
Yes
Yes
Yes
Yes
No
For more information about limitations, see Limitations.