Examples of PGPoolingDataSource

org.postgresql.ds.PGPoolingDataSource
DataSource which uses connection pooling. Don't use this if your server/middleware vendor provides a connection pooling implementation which interfaces with the PostgreSQL ConnectionPoolDataSource implementation! This class is provided as a convenience, but the JDBC Driver is really not supposed to handle the connection pooling algorithm. Instead, the server or middleware product is supposed to handle the mechanics of connection pooling, and use the PostgreSQL implementation of ConnectionPoolDataSource to provide the connections to pool.
If you're sure you want to use this, then you must set the properties dataSourceName, databaseName, user, and password (if required for the user). The settings for serverName, portNumber, initialConnections, and maxConnections are optional. Note that only connections for the default user will be pooled! Connections for other users will be normal non-pooled connections, and will not count against the maximum pool size limit.

If you put this DataSource in JNDI, and access it from different JVMs (or otherwise load this class from different ClassLoaders), you'll end up with one pool per ClassLoader or VM. This is another area where a server-specific implementation may provide advanced features, such as using a single pool across all VMs in a cluster.

This implementation supports JDK 1.3 and higher.
@author Aaron Mulder (ammulder@chariotsolutions.com)

Examples of org.postgresql.ds.PGPoolingDataSource

        this.dataDb = "biblioteca";
    }
    
    
    public DataSource getSource(){
        PGPoolingDataSource source = new PGPoolingDataSource();
        source.setDatabaseName(this.dataDb);
        source.setServerName(this.serverDb);
        source.setPortNumber(this.portDB);
        source.setUser(this.userDb);
        source.setPassword(this.passDb);
        source.setMaxConnections(5);       
        return source;
    }

View Full Code Here

Examples of org.postgresql.ds.PGPoolingDataSource

  /**
   * Construct a new <code>PostgreSQLConnectionPool</code> object.
   * 
   */
  protected PostgreSQLConnectionPool() {
    source = new PGPoolingDataSource();
    source.setDataSourceName(Configuration.getString("dbDataSource"));
    source.setServerName(Configuration.getString("dbServerName"));
    source.setDatabaseName(Configuration.getString("dbName"));
    source.setUser(Configuration.getString("dbUser"));
    source.setPortNumber(Configuration.getInt("dbPort"));

View Full Code Here

Examples of org.postgresql.ds.PGPoolingDataSource

  /**
   * Construct a new <code>PostgreSQLConnectionPool</code> object.
   * 
   */
  protected PostgreSQLConnectionPool() {
    source = new PGPoolingDataSource();
    source.setDataSourceName(Configuration.getString("dbDataSource"));
    source.setServerName(Configuration.getString("dbServerName"));
    source.setDatabaseName(Configuration.getString("dbName"));
    source.setUser(Configuration.getString("dbUser"));
    source.setPortNumber(Configuration.getInt("dbPort"));

View Full Code Here

Examples of org.postgresql.ds.PGPoolingDataSource

  /**
   * Construct a new <code>PostgreSQLConnectionPool</code> object.
   * 
   */
  protected PostgreSQLConnectionPool() {
    source = new PGPoolingDataSource();
    source.setDataSourceName(Configuration.getString("dbDataSource"));
    source.setServerName(Configuration.getString("dbServerName"));
    source.setDatabaseName(Configuration.getString("dbName"));
    source.setUser(Configuration.getString("dbUser"));
    source.setPortNumber(Configuration.getInt("dbPort"));

View Full Code Here

Examples of org.postgresql.ds.PGPoolingDataSource

    /**
     * DataSrouce ベースのアクセスをする場合に DataSource の初期化
     */
    private void initializeDataSource() {
        // postgres 接続プール処理データソース
        datasource = new PGPoolingDataSource();
        datasource.setDataSourceName("postgresql");
        datasource.setServerName(getHost());
        datasource.setDatabaseName(database);
        datasource.setUser(getUser());
        datasource.setPassword(getPasswd());

View Full Code Here

Examples of org.postgresql.ds.PGPoolingDataSource


   PGPoolingDataSource source;


   public PostgreSqlDataSourceImpl(PluginProperties properties)
   {
      source = new PGPoolingDataSource();


      source.setDataSourceName(properties.getParamString(PostgreSqlDataSourceImpl.DATASOURCE_NAME));
      source.setServerName(properties.getParamString(PostgreSqlDataSourceImpl.DATASOURCE_DB_HOST));
      source.setDatabaseName(properties.getParamString(PostgreSqlDataSourceImpl.DATASOURCE_DB_NAME));
      source.setUser(properties.getParamString(PostgreSqlDataSourceImpl.DATASOURCE_USER_LOGIN));

View Full Code Here

Examples of org.postgresql.ds.PGPoolingDataSource

        ic.createSubcontext("java:/comp/env/jdbc");
        
        ic.createSubcontext("mail");
       
        // DataSource dla postgresa
        PGPoolingDataSource dataSource = new PGPoolingDataSource();
        
        dataSource.setDataSourceName("aperte-workflow-ds");
        dataSource.setServerName("localhost");
        dataSource.setDatabaseName(DATABASE_NAME);
        dataSource.setUser(USER_NAME);
        dataSource.setPassword(USER_PASSWORD);
        
        
        ic.bind("java:/comp/env/jdbc/aperte-workflow-ds", dataSource);
        
    final String userName = "axa-mail";

View Full Code Here

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.