skip to main content
DataDirect tools : 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. In this example we use Oracle, so the DataSource class is OracleDataSource. Refer to your the user’s guide for your driver for the name of your driver's DataSource class.
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/ConnectOracle>.
//// 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 java.util.Hashtable;

import javax.naming.Context;
import javax.naming.InitialContext;

import com.ddtek.jdbcx.oracle.OracleDataSource;
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 DataSource");
ds.setServerName("Server3");
ds.setPortNumber(1521);
ds.setUser("User123");
ds.setPassword("secret");
ds.setSID("ORCL");

// 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:\\JNDI_Test_Dir");
Context ctx = new InitialContext(env);

// Register the data source to JNDI naming service
ctx.bind("jdbc/ConnectOracle", ds);

} catch (Exception e) {
System.out.println(e.getStackTrace());
e.printStackTrace();
return;
}
}// Main
}
// class OracleDataSourceRegisterJNDI