Examples of com.mchange.v2.c3p0.DataSources

com.mchange.v2.c3p0.WrapperConnectionPoolDataSource

A simple factory class for creating DataSources. Generally, users will call DataSources.unpooledDataSource() to get a basic DataSource, and then get a pooled version by calling DataSources.pooledDataSource().

Most users will not need to worry about configuration details. If you want to use a PreparedStatement cache, be sure to call the version of DataSources.pooledDataSource() that accepts a statement_cache_size parameter, and set that to be a number (much) greater than zero. (For maximum performance, you would set this to be several times the number kinds of PreparedStatements you expect your application to use.)

For those interested in detailed configuration, note that c3p0 pools can be configured by explicit method calls on PoolConfig objects, by defining System properties, or by defining a c3p0.properties file in your resource path. See {@link com.mchange.v2.c3p0.PoolConfig}for details.

//                     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

      usage();
  */
  
  try
      {
    DriverManagerDataSource dmds = new DriverManagerDataSource();
    //dmds.setJdbcUrl( jdbcUrl );
    //dmds.setUser( username );
    //dmds.setPassword( password );
    try { drop( dmds ); }
    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

    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

   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.DataSources

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.