在J2SE环境中的Hibernate JPA中使用OracleDataSource

private ObjectPool getNewConnectionPool(DataSource mySqlDataSource) {
    try {
        GenericObjectPool pool = new GenericObjectPool(null, 10); 
        pool.setTestOnBorrow(true);
        ConnectionFactory factory = new DataSourceConnectionFactory(mySqlDataSource);
        PoolableConnectionFactory poolableConnectionFactory = new PoolableConnectionFactory(factory, pool, null, \"SELECT 1 FROM DUAL\", false, true);
        Class.forName(\"org.apache.commons.dbcp.PoolingDriver\");
        PoolingDriver driver = (PoolingDriver) DriverManager.getDriver(\"jdbc:apache:commons:dbcp:\");
        driver.registerPool(\"myPool\", pool);
        return poolableConnectionFactory.getPool();
    } catch (Exception e) {
        throw new RuntimeException(\"Unable to initialize connetion pooling\", e);
    }
}

DataSource dataSource = new PoolingDataSource(getNewConnectionPool(mySqlDataSource));

Connection conn = DriverManager.getConnection(\"jdbc:apache:commons:dbcp:myPool\");

Map<String, Object> properties = new HashMap<String, Object>();
properties.put(\"javax.persistence.provider\", \"org.hibernate.ejb.HibernatePersistence\");
properties.put(\"javax.persistence.jdbc.url\", \"jdbc:apache:commons:dbcp:myPool\");
this.entityManagerFactory = Persistence.createEntityManagerFactory(\"myUnit\", properties);
this.entityManager = this.entityManagerFactory.createEntityManager();