Examples of com.caucho.sql.DBPool

com.caucho.sql.DBPool

al connection stuff } finally { conn.close(); }

Configuration

 <database name='jdbc/test'> <init> <driver>postgresql.Driver</driver> <url>jdbc:postgresql://localhost/test</url> <user>ferg</user> <password>foobar</password> </init> </database>

Pool limits and timeouts

The pool will only allow getMaxConnections() connections alive at a time. If getMaxConnection connections are already active, getPooledConnection will block waiting for an available connection. The wait is timed. If connection-wait-time passes and there is still no connection, getPooledConnection create a new connection anyway.

Connections will only stay in the pool for about 5 seconds. After that they will be removed and closed. This reduces the load on the DB and also protects against the database dropping old connections.

  @Override
  public DataSource create()
  {
    Class<?> driverClass = getDriverClass();
    
    DBPool pool = new DBPool();
    pool.setName(getName());
    
    DriverConfig driver = pool.createDriver();
    driver.setType(driverClass);
    
    ConfigType<?> configType = TypeFactory.getType(driverClass);


    if (getUrl() != null) {
      if (configType.getAttribute(URL) != null
          || Driver.class.isAssignableFrom(driverClass)) {
        driver.setURL(getUrl());
      }
    }


    if (getDatabaseName() != null) {
      driver.setProperty("database-name", getDatabaseName());
    }
    
    if (getUser() != null)
      driver.setUser(getUser());
    
    if (getPassword() != null)
      driver.setPassword(getPassword());
    
    try {
      driver.init();
      
      pool.init();
    } catch (Exception e) {
      e.printStackTrace();
      throw ConfigException.create(e);
    }