Configuring JDBC Data Sources

Using JDBC data sources provides flexibility to make environment changes and reduces the time it takes to reconfigure your infrastructure when a change is made. For example, if a service is reconfigured (moved to another machine, port, and so on), the OpenAccess SDK administrator can change and run the configuration source file described in Creating and Managing JDBC Data Sources , reassigning the logical name of the JDBC data source to the changed data source configuration. As a result, the client application code does not have to change, because it only refers to the logical name of the JDBC data source.

OpenAccess SDK supports the following JDBC data source implementations defined by the JDBC 2.0 Optional Package:

• JNDI for Naming Databases
• Connection pooling

Note: You must include the javax.sql.* and javax.naming.* classes to create and use JDBC data sources. The JDBC Client provides all the necessary JAR files that contain the required classes and interfaces.