Examples of com.mchange.v2.c3p0.PoolConfig

com.mchange.v2.c3p0.WrapperConnectionPoolDataSource
Encapsulates all the configuration information required by a c3p0 pooled DataSource.

Newly constructed PoolConfig objects are preset with default values, which you can define yourself (see below), or you can rely on c3p0's built-in defaults. Just create a PoolConfig object, and change only the properties you care about. Then pass it to the {@link com.mchange.v2.c3p0.DataSources#pooledDataSource(javax.sql.DataSource,com.mchange.v2.c3p0.PoolConfig)}method, and you're off!

For those interested in the details, configuration properties can be specified in several ways:
1. Any property can be set explicitly by calling the corresponding method on a PoolConfig object.
2. Any property will default to a value defined by a System Property, using the property name shown the table below.
3. Any property not set in either of the above ways will default to a value found in a user-supplied Java properties file, which may be placed in the resource path of the ClassLoader that loaded the c3p0 libraries under the name /c3p0.properties.
4. Any property not set in any of the above ways will be defined according c3p0's built-in defaults.
Please see c3p0's main documentation for a description of all available parameters.
@deprecated as of c3p0-0.9.1. To manipulate config programmaticall, please use ComboPooledDataSource

//                     0,
//                     100 );


    //ds_unpooled = DataSources.unpooledDataSource(jdbc_url, username, password);
    //ds_pooled = DataSources.pooledDataSource( ds_unpooled );
      ds_unpooled = new DriverManagerDataSource();


       //DataSource ds_unpooled_screwy = C3P0TestUtils.unreliableCommitDataSource( ds_unpooled );
       //ds_pooled = DataSources.pooledDataSource( ds_unpooled_screwy );


//     PoolConfig pc = new PoolConfig();

View Full Code Here

    System.err.println("DriverManagerDataSource:");
    doTest( dmds );
    
    WrapperConnectionPoolDataSource wcpds = new WrapperConnectionPoolDataSource();
    wcpds.setNestedDataSource( dmds );
    PoolBackedDataSource pbds = new PoolBackedDataSource();
    pbds.setConnectionPoolDataSource( wcpds );
    
    System.err.println("PoolBackedDataSource:");
    doTest( pbds );
        
        ComboPooledDataSource cpds = new ComboPooledDataSource();

View Full Code Here

    System.err.println("DriverManagerDataSource:");
    doTest( dmds );
    
    WrapperConnectionPoolDataSource wcpds = new WrapperConnectionPoolDataSource();
    wcpds.setNestedDataSource( dmds );
    PoolBackedDataSource pbds = new PoolBackedDataSource();
    pbds.setConnectionPoolDataSource( wcpds );
    
    System.err.println("PoolBackedDataSource:");
    doTest( pbds );
      }
  catch ( Exception e )

View Full Code Here

    System.err.println("DriverManagerDataSource:");
    doTest( dmds );
    
    WrapperConnectionPoolDataSource wcpds = new WrapperConnectionPoolDataSource();
    wcpds.setNestedDataSource( dmds );
    PoolBackedDataSource pbds = new PoolBackedDataSource();
    pbds.setConnectionPoolDataSource( wcpds );
    
    System.err.println("PoolBackedDataSource:");
    doTest( pbds );
        
        ComboPooledDataSource cpds = new ComboPooledDataSource();

View Full Code Here

      int maxIdleTime = PropertiesHelper.getInt(Environment.C3P0_TIMEOUT, props, 0);
      int maxStatements = PropertiesHelper.getInt(Environment.C3P0_MAX_STATEMENTS, props, 0);
      int acquireIncrement = PropertiesHelper.getInt(Environment.C3P0_ACQUIRE_INCREMENT, props, 1);
      int idleTestPeriod = PropertiesHelper.getInt(Environment.C3P0_IDLE_TEST_PERIOD, props, 0);


      PoolConfig pcfg = new PoolConfig();
      pcfg.setInitialPoolSize(minPoolSize);
      pcfg.setMinPoolSize(minPoolSize);
      pcfg.setMaxPoolSize(maxPoolSize);
      pcfg.setAcquireIncrement(acquireIncrement);
      pcfg.setMaxIdleTime(maxIdleTime);
      pcfg.setMaxStatements(maxStatements);
      pcfg.setIdleConnectionTestPeriod(idleTestPeriod);


      /*DataSource unpooled = DataSources.unpooledDataSource(
        jdbcUrl, props.getProperty(Environment.USER), props.getProperty(Environment.PASS)
      );*/
      DataSource unpooled = DataSources.unpooledDataSource(jdbcUrl, connectionProps);

View Full Code Here

   public void testGetConnection() throws Exception
   {
      cf = new C3p0ConnectionFactory();
      cf.setConfig(config);
      cf.start();
      PooledDataSource internalDs = (PooledDataSource) cf.getDataSource();


      Connection c1 = cf.getConnection();
      Connection c2 = cf.getConnection();
      assertEquals("There should be two connections checked out", 2, internalDs.getNumBusyConnectionsDefaultUser());


      cf.close(c1);
      Thread.sleep(100);
      assertEquals("There should be one connection checked out", 1, internalDs.getNumBusyConnectionsDefaultUser());


      cf.close(c2);
      Thread.sleep(100);
      assertEquals("There should be no connections checked out", 0, internalDs.getNumBusyConnectionsDefaultUser());
   }

View Full Code Here

   public void testGetConnection() throws Exception
   {
      cf = new C3p0ConnectionFactory();
      cf.setConfig(config);
      cf.start();
      PooledDataSource internalDs = (PooledDataSource) cf.getDataSource();


      Connection c1 = cf.getConnection();
      Connection c2 = cf.getConnection();
      assertEquals("There should be two connections checked out", 2, internalDs.getNumBusyConnectionsDefaultUser());


      cf.close(c1);
      Thread.sleep(100);
      assertEquals("There should be one connection checked out", 1, internalDs.getNumBusyConnectionsDefaultUser());


      cf.close(c2);
      Thread.sleep(100);
      assertEquals("There should be no connections checked out", 0, internalDs.getNumBusyConnectionsDefaultUser());
   }

View Full Code Here

                ds = (DataSource) DatabaseConfig.getInstance().getPooledDataSource(connectionName);
            }


            // make sure it's a c3p0 PooledDataSource
            if (ds != null && (ds instanceof PooledDataSource)) {
                PooledDataSource pds = (PooledDataSource) ds;
                log.debug("displayDS for " + where + " -      num_connections: " + pds.getNumConnectionsDefaultUser());
                log.debug("displayDS for " + where + " - num_busy_connections: " + pds.getNumBusyConnectionsDefaultUser());
                log.debug("displayDS for " + where + " - num_idle_connections: " + pds.getNumIdleConnectionsDefaultUser());
            }
        } catch(Exception ex) {
            log.debug("displayDS for " + where + " - ERROR: " + ex.getMessage());
        }
    }

View Full Code Here

   public void testGetConnection() throws Exception
   {
      cf = new C3p0ConnectionFactory();
      cf.setConfig(config);
      cf.start();
      PooledDataSource internalDs = (PooledDataSource) cf.getDataSource();


      Connection c1 = cf.getConnection();
      Connection c2 = cf.getConnection();
      assertEquals("There should be two connections checked out", 2, internalDs.getNumBusyConnectionsDefaultUser());


      cf.close(c1);
      Thread.sleep(100);
      assertEquals("There should be one connection checked out", 1, internalDs.getNumBusyConnectionsDefaultUser());


      cf.close(c2);
      Thread.sleep(100);
      assertEquals("There should be no connections checked out", 0, internalDs.getNumBusyConnectionsDefaultUser());
   }

View Full Code Here

                    AbstractPoolBackedDataSource apbds = ((AbstractPoolBackedDataSource) pds);
                    apbds.setFactoryClassLocation( val );
                    ConnectionPoolDataSource checkDs1 = apbds.getConnectionPoolDataSource();
                    if (checkDs1 instanceof WrapperConnectionPoolDataSource)
                    {
                        WrapperConnectionPoolDataSource wcheckDs1 = (WrapperConnectionPoolDataSource) checkDs1;
                        wcheckDs1.setFactoryClassLocation( val );
                        DataSource checkDs2 = wcheckDs1.getNestedDataSource();
                        if (checkDs2 instanceof DriverManagerDataSource)
                            ((DriverManagerDataSource) checkDs2).setFactoryClassLocation( val );
                    }
                    return;
                }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of com.mchange.v2.c3p0.PoolConfig

br.com.caelum.vraptor.dash.hibernate.AuditController

br.com.objectos.way.relational.WayRelationalTest

com.alibaba.druid.pool.bonecp.TestLRU

com.alibaba.druid.pool.bonecp.TestPSCache

com.github.hakko.musiccabinet.dao.jdbc.JdbcDatabaseAdministrationDao

com.jfinal.plugin.c3p0.C3p0Plugin

com.jolbox.benchmark.BenchmarkTests

com.mchange.v1.identicator.IdHashMap

com.mchange.v1.identicator.IdWeakHashMap

com.mchange.v2.async.CarefulRunnableQueue

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.