sl314.util.sql.ConnectionPool

[Oscar Camilo Luna]

Hi! I tried to activate an example Web application with a PointBase database but failed. The example needs a java class named ConnectionPool, but I can't find the associated files.

Below is the code for InitializeConnectionPool.java:

package sl314.web;
 
// Servlet imports
import javax.servlet.ServletContextListener;
import javax.servlet.ServletContextEvent;
import javax.servlet.ServletContext;
// Support classes
import sl314.util.NamingService;
[B]import sl314.util.sql.ConnectionPool[/B];
import java.sql.SQLException;
 
/**
 * This listenter is used to initialize the JDBC Connection Pool for a
 * given Web Application.
 */
public class InitializeConnectionPool implements ServletContextListener {
   private static final int DEFAULT_MIN_CONN = 1;
   private static final int DEFAULT_MAX_CONN = 5;
 
   /**
    * This method creates the connection pool.
    */
   public void contextInitialized(ServletContextEvent sce) {
      ServletContext context = sce.getServletContext();
      String jdbcDriver = context.getInitParameter("jdbcDriver");
      String jdbcURL = context.getInitParameter("jdbcURL");
      String jdbcUserName = context.getInitParameter("jdbcUserName");
      String jdbcPassword = context.getInitParameter("jdbcPassword");
      int minimumConnections = DEFAULT_MIN_CONN;
      int maximumConnections = DEFAULT_MAX_CONN;
      String strValue = null;
      [B]ConnectionPool connectionPool[/B];
 
      // Determine the minimum number of connections for the pool
      // from the context parameter
      try {
         strValue = context.getInitParameter("minimumConnections");
         int value = Integer.parseInt(strValue);
         if ( value > 0 ) {
             minimumConnections = value;
         } else {
             context.log("The minimumConnections value must be positive."
                         + "; using the default: " + DEFAULT_MIN_CONN);
         }
      } catch (NumberFormatException nfe) {
          context.log("The minimumConnections value was not an integer '"
                      + strValue + "'; using the default: "
                      + DEFAULT_MIN_CONN);
      }
 
      // Determine the maximum number of connections for the pool
      // from the context parameter
      try {
         strValue = context.getInitParameter("maximumConnections");
         int value = Integer.parseInt(strValue);
         if ( value > 0 ) {
             maximumConnections = value;
         } else {
             context.log("The maximumConnections value must be positive."
                         + "; using the default: " + DEFAULT_MAX_CONN);
         }
      } catch (NumberFormatException nfe) {
          context.log("The maximumConnections value was not an integer '"
                      + strValue + "'; using the default: "
                      + DEFAULT_MAX_CONN);
      }
 
      // Intialize the connection pool object
      try {
        NamingService nameSvc = NamingService.getInstance();
        [B]connectionPool = new ConnectionPool(jdbcDriver, jdbcURL,
                                            jdbcUserName, jdbcPassword,
                                            minimumConnections,
                                            maximumConnections)[/B];
        nameSvc.setAttribute("connectionPool", connectionPool);
        context.log("Connection pool created for URL=" + jdbcURL);
 
      } catch (ClassNotFoundException cnfe) {
         context.log("The JDBC Driver class " + jdbcDriver
                     + " was no tfound.", cnfe);
 
      } catch (InstantiationException ie) {
         context.log("The JDBC Driver class " + jdbcDriver + " could "
                     + "no tmake an object.", ie);
 
      } catch (IllegalAccessException iae) {
         context.log("The JDBC Driver (" + jdbcDriver + ") class "
                     + "or initializer is no taccessible.", iae);
 
      } catch (SQLException sex) {
         context.log("There was an error in creating the "
                     + "connection pool for " + jdbcURL, sex);
      }
   }
 
   /**
    * This method destroys the connection pool.
    */
   public void contextDestroyed(ServletContextEvent sce) {
      ServletContext context = sce.getServletContext();
      NamingService nameSvc = NamingService.getInstance();
      ConnectionPool connectionPool
        = (ConnectionPool) nameSvc.getAttribute("connectionPool");
 
      // Shutdown the connection pool
      [B]connectionPool.shutdown()[/B];
      context.log("Connection pool shutdown.");
   }
}

Can anybody there help? I'm sure the files doesn't exists.

Thanks,

Camilo

[ March 23, 2008: Message edited by: Oscar Camilo Luna ]

[ March 23, 2008: Message edited by: Oscar Camilo Luna ]
[ March 25, 2008: Message edited by: Jeanne Boyarsky ]

[Muhammad Saifuddin]

Welcome to Javaranch.

Please be sure to use UBB Code tags when posting code to the forums. Please read this for more information.

You can go back and change your post to add code tags by clicking the

Good Luck with your question.

[Jeanne Boyarsky]

Oscar,
Welcome to JavaRanch!

Are you getting the error at compile time or runtime? The answer to this will determine which classpath to check in order to check that database jar is present.