skip to main content
Connection Pool Manager : Using a DataDirect Connection Pool : Creating a Driver DataSource Object
  
Creating a Driver DataSource Object
The following Java code example creates a DataDirect Connect Series for JDBC driver DataSource object and registers it with a JNDI naming service.
The DataSource class is provided by DataDirect Connect Series for JDBC and is database-dependent. In this example we use Oracle, so the DataSource class is OracleDataSource. Refer to the appropriate driver chapter in the DataDirect Connect Series for JDBC User’s Guide for the name of the DataSource class for your driver.
Note: The DataSource class implements the ConnectionPoolDataSource interface for pooling in addition to the DataSource interface for non-pooling.
//************************************************************************
// This code creates a DataDirect Connect Series 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:
//
// http://www.oracle.com/technetwork/java/javasebusiness/downloads/
// 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 com.ddtek.jdbcx.oracle.OracleDataSource;
import javax.sql.*;
import java.sql.*;
import javax.naming.*;
import javax.naming.directory.*;
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");
      ds.setServerName("sparky");
      ds.setPortNumber(1521);
      ds.setUser("scott");
      ds.setPassword("test");
      // Set up environment for creating initial context
      Hashtable env = new Hashtable();
      env.put(Context.INITIAL_CONTEXT_FACTORY,
         "com.sun.jndi.fscontext.RefFSContextFactory");
      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) {
      System.out.println(e);
      return;
      }
   } // Main
   // class OracleDataSourceRegisterJNDI