skip to main content
Using the Driver : Connection Pool Manager : Implementing DataDirect Connection Pooling : Creating a Driver DataSource Object

Try DataDirect Drivers Now
Creating a Driver DataSource Object
The following Java code example creates a Progress DataDirect DataSource object and registers it with a JNDI naming service. The DataSource class is database-dependent. This example is drawn from an Oracle use case; therefore, the DataSource class is OracleDataSource. Nevertheless, the example informs the implementation of DataSource objects for most Progress DataDirect drivers.
Note: The DataSource class implements the ConnectionPoolDataSource interface for pooling in addition to the DataSource interface for non-pooling.
// This code creates a Progress DataDirect for JDBC data source and
// registers it to a JNDI naming service. This JDBC data source uses the
// DataSource implementation provided by DataDirect Connect Series
// for JDBC Drivers.
// This data source registers its name as <jdbc/ConnectSparkyOracle>.
//// NOTE: To connect using a data source, the driver needs to access a JNDI data
// store to persist the data source information. To download the JNDI File
// System Service Provider, go to:
// java-archive-downloads-java-plat-419418.html#7110-jndi-1.2.1-oth-JPR
// Make sure that the fscontext.jar and providerutil.jar files from the
// download are on your classpath.
// From DataDirect Connect Series for JDBC:
import javax.sql.*;
import java.sql.*;
import javax.naming.*;
import java.util.Hashtable;
public class OracleDataSourceRegisterJNDI
{   public static void main(String argv[])
      try {
      // Set up data source reference data for naming context:
      // ----------------------------------------------------
      // Create a class instance that implements the interface
      // ConnectionPoolDataSource
      OracleDataSource ds = new OracleDataSource();
      ds.setDescription("Oracle on Sparky - Oracle Data Source");
      // Set up environment for creating initial context
      Hashtable env = new Hashtable();
      env.put(Context.PROVIDER_URL, "file:c:\\JDBCDataSource");
      Context ctx = new InitialContext(env);
      // Register the data source to JNDI naming service
      ctx.bind("jdbc/ConnectSparkyOracle", ds);
      } catch (Exception e) {
   } // Main
   // class OracleDataSourceRegisterJNDI