3 Replies Latest reply on Dec 15, 2006 5:53 PM by Peter Johnson

    Connection Pooling java.sql.Connection?

    Benjamin Nutting Newbie

      I am trying to connection pool a AS400 JDBC Connection. Have been trying to find a good tutorial but have yet to find one.

      Basically right now for each user I am creating a connection (example below). I would like to get a pool of these types of connections that expands when necissary, and contracts say after 30 minutes.

      public static java.sql.Connection getApplicationSecurityConnection() {
       String description = "Connection to the Application Security Database";
       //String driver = "com.inet.tds.TdsDriver";
       //String protocol = "inetdae";
       //String serverDNS = "localhost";
       //String port = "1433";
       //String instance = "";
       //String database = "APP_SECURITY";
       //String user = "security";
       //String password = "ssSetjESN5sgve6jQdNM8BTra";
      
       String driver = "com.ibm.as400.access.AS400JDBCDriver";
       String protocol = "";
       String serverDNS = "";
       String port = "";
       String instance = "";
       String database = "";
       String user = "CPSERVER";
       String password = "CPPROFILE";
      
      
      
       java.sql.Connection conn = null;
       try {
       // make sure DriverManager can load proper class to establish connection
       Class.forName(driver);
       String URL = "jdbc:" + protocol + ":" + serverDNS;
       Properties DBProperties = new Properties();
       if (!port.equals("")){
       DBProperties.setProperty("port",port);
       }
       if (!instance.equals("")){
       DBProperties.setProperty("instance",instance);
       }
       if (!database.equals("")){
       DBProperties.setProperty("database",database);
       }
       if (!user.equals("")){
       DBProperties.setProperty("user",user);
       }
       if (!password.equals("")){
       DBProperties.setProperty("password",password);
       }
       if(!getApplicationName().equals("")){
       DBProperties.setProperty("appname",getApplicationName());
       }
       conn = DriverManager.getConnection(URL,DBProperties);
       if (conn == null){
       throw new Exception("getDATAConnection(String, String): Unspecified error occured.");
       }
       } catch (Exception e) {
       System.out.println("\n\n*******************************************************");
       System.out.println("CONNECTION ERROR!!!!");
       System.out.println("DESCRIPTION: " + description);
       System.out.println("ERROR: " + e.getMessage());
       System.out.println("\n\n*******************************************************");
       e.printStackTrace();
       }
       return conn;
       }


      any help us MUCH appreciated