JDBC Driver for HPCC

Build 21.0.7930

JNDI

Connection Pooling with JNDI

The Java Naming and Directory Service (JNDI) is an API which allows distributed application to look up services. JNDI can be used to easily set up connection pools.

To set up a connection pool using JNDI, you will need to initialize the JNDI File System Service Provider, as shown in the example code below. To run the example, you need to add the fscontext.jar and providerutil.jar files to your classpath. You can download these files from the Oracle Java Archive: Under the Java SE section, select Java Platform Technologies > Java Naming and Directory Interface.

 
Hashtable env = new Hashtable();
env.put(Context.INITIAL_CONTEXT_FACTORY,
    "com.sun.jndi.fscontext.RefFSContextFactory");
env.put(Context.PROVIDER_URL, "file:///tmp");

Context ctx = new InitialContext(env); 
DataSource ds = null;
Connection conn = null;
The following code registers the HPCCDataSource with the JNDI naming service, gets an instance of the DataSource from the service, and creates pooled connections from that instance.
try {
  HPCCConnectionPoolDataSource hpccDataSource = new HPCCConnectionPoolDataSource();
  hpccDataSource.setURL("jdbc:hpcc:UseConnectionPooling=true;URL=http://127.0.0.1:8510;User=test;Password=xA123456;Version=1;Cluster=hthor;");
  ctx.bind("jdbc/hpcc", hpccDataSource);
  ds = (DataSource) ctx.lookup("jdbc/hpcc");

  conn = ds.getConnection();
  Statement stat = conn.createStatement();
  boolean ret = stat.execute("SELECT 1");
  ResultSet rs=stat.getResultSet(); 
} catch(Exception ex) { } finally {
  if(conn != null) conn.close();
}

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930