2.7.2 How to connect to resources
To connect to a database form a batch application, directly use JDBC drivers or use resource adapters provided on Application Server. Use DB Connector if you want to use a resource adapter. The following table describes the functionality that you can use when connecting to a database from a batch application, for each connection method. If you use DB Connector, in addition to the functionality mentioned in the table below, you can also use the functionality provided by DB Connector. For details on the functionality provided by DB Connector, see 2.7.4(1) Resource adapter functionality.
Functionality that you can use |
How to connect |
|||
---|---|---|---|---|
DB Connector |
JDBC driver |
|||
Executing SQL |
Y |
Y |
||
Using transactions |
Transactions by Connection API |
Y |
Y |
|
JTA |
Local transactions |
Y |
N |
|
Global transactions |
N |
N |
||
GC control functionality |
Y |
N |