import java.beans.PropertyVetoException;            
import java.sql.Connection;            
import com.mchange.v2.c3p0.ComboPooledDataSource;

public class Connections {
    private static ComboPooledDataSource ds = new ComboPooledDataSource();
    static {        
        ds.setJdbcUrl("jdbc:edb://192.168.66.129:5444/edb");    
        ds.setUser("enterprisedb");    
        ds.setPassword("enterprisedb"); 
        ds.setAcquireIncrement(15);    
        ds.setInitialPoolSize(20);    
        ds.setMinPoolSize(10);    
        ds.setMaxPoolSize(500);    
        ds.setAcquireRetryAttempts(30);    
        ds.setMaxIdleTime(0);    
        ds.setCheckoutTimeout(0);    
            
        try {    
            ds.setDriverClass("com.edb.Driver");
        } catch (PropertyVetoException e) {    
            
        }    
        ds.setMaxStatements(0);    
    }        
            
    public static Connection getConnection() {        
        Connection conn = null;    
        try {    
            conn = ds.getConnection();
        } catch (Exception e) {    
            e.printStackTrace();
        }    
        return conn;    
    }        
}            

import java.sql.*;
import java.io.*;
import java.lang.Thread;

public class test02{
 public static void main(String[] args)
 {
   try{
      for(;;){
          Connection con;

          con = Connections.getConnection();
          System.out.println("Got connection now!");
          Thread.sleep(240000);

          Statement stmt = con.createStatement() ; 
          System.out.println("Got Statement now!");
          Thread.sleep(240000);
  
          ResultSet rs = stmt.executeQuery("SELECT * FROM a5") ;  
          System.out.println("Got ResultSet now!");
          Thread.sleep(240000);

         int i=10;

         while(rs.next()){ 
              i--;
              if (i<0)
                  break;
 
              System.out.println("Got Record now!");
              Thread.sleep(5000);

              String id = rs.getString("ID");
              System.out.println("id is:"+id);   
         } 

         if(rs != null){
             try{   
                  rs.close() ;   
             }catch(SQLException e){   
                  e.printStackTrace() ;   
             }   
         }  

        if(stmt != null){
            try{   
               stmt.close() ;   
            }catch(SQLException e){   
              e.printStackTrace() ;   
            }   
        }   

        if(con != null){
            try{   
               con.close() ;   
            }catch(SQLException e){   
               e.printStackTrace() ;   
            }   
        }
     }///end of for loop
    }catch(Exception exp){
       exp.printStackTrace();
    } /////end of whole try catch pair
 }/////////////end of main
}//////////////////////end of class