import javax.sql.*;
import java.sql.*;

public class Jdbc2Test
{
   public static void main(String[] args)
   {
       try
       {
           if(args.length != 1)
           {
               System.out.println("Usage:   Jdbc2Test <logical DataSource name>");
               System.out.println("Example: Jdbc2Test FOO");
               System.exit(0);
           }

           java.io.BufferedReader console = new java.io.BufferedReader(new java.io.InputStreamReader(System.in));
           java.util.Hashtable env = new java.util.Hashtable( 5 );
           env.put( "java.naming.factory.initial", "COM.ibm.db2.jndi.DB2InitialContextFactory" );
           javax.naming.Context ctx = new javax.naming.InitialContext( env );

           DataSource ds = (DataSource)ctx.lookup(args[0]);

           Connection con = ds.getConnection();
       
           System.out.println("Connection ready (Press Enter)");
           console.readLine();

           con.close();

           System.out.println("Connection put back to pool (Press Enter)");
           console.readLine();

           ctx.close();
       }
       catch(Exception ex)
       {
           ex.printStackTrace();
       }
   }
}