user manual

Chapter 22: Using JDBC 231
Configuring JDBC Datasources
below in “Defining the Connection Pool Properties for a JDBC Datasource” on
page 232. The same procedure is used for adding Driver Properties.
Consult your database documentation for any properties you need to define.
Once you're finished, save the module and dismiss the final modal window.
The JNDI Definitions Module is automatically re-deployed to the Partition.
Deploying Driver Libraries
If any external drivers are needed, which is usually the case, they must be
deployed to the target Partition as a library archive. See the User's Guide for
information on deploying libraries to Partitions. Note that this step is not
necessary if you are using the native all-Java database, JDataStore. When
trying to connect to another database like Oracle or Sybase the respective
JDBC driver must first be deployed to the target Partition. The steps are:
1 From the Console, select Tasks->Deployment->Deploy J2EE modules to a
Partition.
2 "Add" the library file and check the option to restart the Partition.
3 Proceed to deploy in the chosen Partition(s.)
4 Close the wizard; the driver is listed under the "Deployed Modules" folder of
the Partition once it restarts.