Connecting using JDBC data sources
- Last Updated: April 14, 2020
- 1 minute read
- Hybrid Data Pipeline
- Version 5.0
- Documentation
A JDBC data source is a Java object,
specifically a DataSource object, that defines
connection information required for a JDBC driver to connect to the database. Each JDBC
driver vendor provides their own data source implementation for this purpose. Progress
DataDirect provides a DataSource object for storing the
connection information needed for the JDBC driver to connect to a Hybrid Data Pipeline
data source, which in turn provides access to a data store.
JDBC data sources work with the Java Naming Directory Interface (JNDI) naming service, providing an extra level of abstraction that allows you to create and manage JDBC data sources (in this case, a Hybrid Data Pipeline connectivity service data source) separately from the applications that use them. The connection information is defined outside of the application, minimizing the effort to reconfigure applications when data source parameters change. The applications only refer to the name of the JDBC data source and therefore, do not need to change.
The Hybrid Data Pipeline Driver for JDBC data source class implements the following JDBC interfaces:
-
javax.sql.DataSource. -
javax.sql.ConnectionPoolDataSourceallows applications to use connection pooling.
To create your own JDBC data source implementation, consider the following requirements:
- If you plan to connect using a JNDI File System Service Provider, the fscontext.jar and providerutil.jar files that are shipped with the JNDI File System Service Provider, must be on your classpath. To download the JNDI File System Service Provider, go to the following Web site and select a JNDI version: