当前位置: 首页>>代码示例>>Java>>正文

Java MysqlConnectionPoolDataSource.getPooledConnection方法代码示例

本文整理汇总了Java中com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource.getPooledConnection方法的典型用法代码示例。如果您正苦于以下问题：Java MysqlConnectionPoolDataSource.getPooledConnection方法的具体用法？Java MysqlConnectionPoolDataSource.getPooledConnection怎么用？Java MysqlConnectionPoolDataSource.getPooledConnection使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource的用法示例。


在下文中一共展示了MysqlConnectionPoolDataSource.getPooledConnection方法的9个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Java代码示例。

示例1: testBug62452

import com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource; //导入方法依赖的package包/类
/**
 * Tests fix for BUG#62452 - NPE thrown in JDBC4MySQLPooledException when statement is closed.
 * 
 * @throws Exception
 */
public void testBug62452() throws Exception {
    PooledConnection con = null;

    MysqlConnectionPoolDataSource pds = new MysqlConnectionPoolDataSource();
    pds.setUrl(dbUrl);
    con = pds.getPooledConnection();
    assertTrue(con instanceof JDBC4MysqlPooledConnection);
    testBug62452WithConnection(con);

    MysqlXADataSource xads = new MysqlXADataSource();
    xads.setUrl(dbUrl);

    xads.setPinGlobalTxToPhysicalConnection(false);
    con = xads.getXAConnection();
    assertTrue(con instanceof JDBC4MysqlXAConnection);
    testBug62452WithConnection(con);

    xads.setPinGlobalTxToPhysicalConnection(true);
    con = xads.getXAConnection();
    assertTrue(con instanceof JDBC4SuspendableXAConnection);
    testBug62452WithConnection(con);

}
开发者ID:bragex，项目名称:the-vigilantes，代码行数:29，代码来源:ConnectionRegressionTest.java

示例2: testBug62452

import com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource; //导入方法依赖的package包/类
/**
 * Tests fix for BUG#62452 - NPE thrown in JDBC4MySQLPooledException when statement is closed.
 * 
 * @throws Exception
 */
public void testBug62452() throws Exception {
    PooledConnection con = null;

    MysqlConnectionPoolDataSource pds = new MysqlConnectionPoolDataSource();
    pds.setUrl(dbUrl);
    con = pds.getPooledConnection();
    assertTrue(con instanceof JDBC4MysqlPooledConnection);
    testBug62452WithConnection(con);
    
    MysqlXADataSource xads = new MysqlXADataSource();
    xads.setUrl(dbUrl);

    xads.setPinGlobalTxToPhysicalConnection(false);
    con = xads.getXAConnection();
    assertTrue(con instanceof JDBC4MysqlXAConnection);
    testBug62452WithConnection(con);

    xads.setPinGlobalTxToPhysicalConnection(true);
    con = xads.getXAConnection();
    assertTrue(con instanceof JDBC4SuspendableXAConnection);
    testBug62452WithConnection(con);

}
开发者ID:zerobane，项目名称:cloudera-cli-scripts，代码行数:29，代码来源:ConnectionRegressionTest.java

示例3: testBug4808

import com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource; //导入方法依赖的package包/类
/**
 * Tests fix for BUG#4808- Calling .close() twice on a PooledConnection
 * causes NPE.
 * 
 * @throws Exception
 *             if an error occurs.
 */
public void testBug4808() throws Exception {
    MysqlConnectionPoolDataSource ds = new MysqlConnectionPoolDataSource();
    ds.setURL(BaseTestCase.dbUrl);
    PooledConnection closeMeTwice = ds.getPooledConnection();
    closeMeTwice.close();
    closeMeTwice.close();

}
开发者ID:bragex，项目名称:the-vigilantes，代码行数:16，代码来源:DataSourceRegressionTest.java

示例4: testBug32101

import com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource; //导入方法依赖的package包/类
/**
 * Tests fix for BUG#32101 - When using a connection from our ConnectionPoolDataSource,
 * some Connection.prepareStatement() methods would return null instead of
 * a prepared statement.
 * 
 * @throws Exception
 */
public void testBug32101() throws Exception {
    MysqlConnectionPoolDataSource ds = new MysqlConnectionPoolDataSource();
    ds.setURL(BaseTestCase.dbUrl);
    PooledConnection pc = ds.getPooledConnection();
    assertNotNull(pc.getConnection().prepareStatement("SELECT 1"));
    assertNotNull(pc.getConnection().prepareStatement("SELECT 1", Statement.RETURN_GENERATED_KEYS));
    assertNotNull(pc.getConnection().prepareStatement("SELECT 1", new int[0]));
    assertNotNull(pc.getConnection().prepareStatement("SELECT 1", new String[0]));
    assertNotNull(pc.getConnection().prepareStatement("SELECT 1", ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY));
    assertNotNull(
            pc.getConnection().prepareStatement("SELECT 1", ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY, ResultSet.HOLD_CURSORS_OVER_COMMIT));
}
开发者ID:bragex，项目名称:the-vigilantes，代码行数:20，代码来源:DataSourceRegressionTest.java

示例5: testBug32101

import com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource; //导入方法依赖的package包/类
/**
 * Tests fix for BUG#32101 - When using a connection from our ConnectionPoolDataSource,
 * some Connection.prepareStatement() methods would return null instead of
 * a prepared statement.
 * 
 * @throws Exception
 */
public void testBug32101() throws Exception {
    MysqlConnectionPoolDataSource ds = new MysqlConnectionPoolDataSource();
    ds.setURL(BaseTestCase.dbUrl);
    PooledConnection pc = ds.getPooledConnection();
    assertNotNull(pc.getConnection().prepareStatement("SELECT 1"));
    assertNotNull(pc.getConnection().prepareStatement("SELECT 1", Statement.RETURN_GENERATED_KEYS));
    assertNotNull(pc.getConnection().prepareStatement("SELECT 1", new int[0]));
    assertNotNull(pc.getConnection().prepareStatement("SELECT 1", new String[0]));
    assertNotNull(pc.getConnection().prepareStatement("SELECT 1", ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY));
    assertNotNull(pc.getConnection().prepareStatement("SELECT 1", ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY,
            ResultSet.HOLD_CURSORS_OVER_COMMIT));
}
开发者ID:mniepert，项目名称:TPKB，代码行数:20，代码来源:DataSourceRegressionTest.java

示例6: testBug4808

import com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource; //导入方法依赖的package包/类
/**
 * Tests fix for BUG#4808- Calling .close() twice on a PooledConnection
 * causes NPE.
 * 
 * @throws Exception
 *             if an error occurs.
 */
public void testBug4808() throws Exception {
	MysqlConnectionPoolDataSource ds = new MysqlConnectionPoolDataSource();
	ds.setURL(BaseTestCase.dbUrl);
	PooledConnection closeMeTwice = ds.getPooledConnection();
	closeMeTwice.close();
	closeMeTwice.close();

}
开发者ID:hinsenchan，项目名称:fil_project_mgmt_app_v2，代码行数:16，代码来源:DataSourceRegressionTest.java

示例7: testBug32101

import com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource; //导入方法依赖的package包/类
/**
 * Tests fix for BUG#32101 - When using a connection from our ConnectionPoolDataSource,
    * some Connection.prepareStatement() methods would return null instead of
    * a prepared statement.
    * 
 * @throws Exception
 */
public void testBug32101() throws Exception {
	MysqlConnectionPoolDataSource ds = new MysqlConnectionPoolDataSource();
	ds.setURL(BaseTestCase.dbUrl);
	PooledConnection pc = ds.getPooledConnection();
	assertNotNull(pc.getConnection().prepareStatement("SELECT 1"));
	assertNotNull(pc.getConnection().prepareStatement("SELECT 1", Statement.RETURN_GENERATED_KEYS));
	assertNotNull(pc.getConnection().prepareStatement("SELECT 1", new int[0]));
	assertNotNull(pc.getConnection().prepareStatement("SELECT 1", new String[0]));
	assertNotNull(pc.getConnection().prepareStatement("SELECT 1", ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY));
	assertNotNull(pc.getConnection().prepareStatement("SELECT 1", ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY, ResultSet.HOLD_CURSORS_OVER_COMMIT));
}
开发者ID:hinsenchan，项目名称:fil_project_mgmt_app_v2，代码行数:19，代码来源:DataSourceRegressionTest.java

示例8: testChangeUserAndCharsets

import com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource; //导入方法依赖的package包/类
/**
 * Tests whether Connection.changeUser() (and thus pooled connections)
 * restore character set information correctly.
 * 
 * @throws Exception
 *             if the test fails.
 */
public void testChangeUserAndCharsets() throws Exception {
    if (versionMeetsMinimum(4, 1)) {
        MysqlConnectionPoolDataSource ds = new MysqlConnectionPoolDataSource();
        ds.setURL(BaseTestCase.dbUrl);
        ds.setCharacterEncoding("utf-8");
        PooledConnection pooledConnection = ds.getPooledConnection();

        Connection connToMySQL = pooledConnection.getConnection();
        this.rs = connToMySQL.createStatement().executeQuery("SELECT @@character_set_results");
        assertTrue(this.rs.next());

        String toCheck = null;

        if (versionMeetsMinimum(4, 1, 15)) {
            if (versionMeetsMinimum(5, 0)) {
                if (versionMeetsMinimum(5, 0, 13)) {
                    toCheck = null;
                } else {
                    toCheck = "NULL";
                }
            } else {
                toCheck = null;
            }
        } else {
            toCheck = "NULL";
        }

        assertEquals(toCheck, this.rs.getString(1));

        this.rs = connToMySQL.createStatement().executeQuery("SHOW SESSION VARIABLES LIKE 'character_set_client'");
        assertTrue(this.rs.next());

        //Cause of utf8mb4
        assertEquals(0, this.rs.getString(2).indexOf("utf8"));

        connToMySQL.close();

        connToMySQL = pooledConnection.getConnection();
        this.rs = connToMySQL.createStatement().executeQuery("SELECT @@character_set_results");
        assertTrue(this.rs.next());
        assertEquals(toCheck, this.rs.getString(1));

        this.rs = connToMySQL.createStatement().executeQuery("SHOW SESSION VARIABLES LIKE 'character_set_client'");
        assertTrue(this.rs.next());

        //Cause of utf8mb4
        assertEquals(0, this.rs.getString(2).indexOf("utf8"));

        pooledConnection.getConnection().close();
    }
}
开发者ID:bragex，项目名称:the-vigilantes，代码行数:59，代码来源:DataSourceTest.java

示例9: testChangeUserAndCharsets

import com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource; //导入方法依赖的package包/类
/**
 * Tests whether Connection.changeUser() (and thus pooled connections)
 * restore character set information correctly.
 * 
 * @throws Exception
 *             if the test fails.
 */
public void testChangeUserAndCharsets() throws Exception {
	if (versionMeetsMinimum(4, 1)) {
		MysqlConnectionPoolDataSource ds = new MysqlConnectionPoolDataSource();
		ds.setURL(BaseTestCase.dbUrl);
		ds.setCharacterEncoding("utf-8");
		PooledConnection pooledConnection = ds.getPooledConnection();

		Connection connToMySQL = pooledConnection.getConnection();
		this.rs = connToMySQL.createStatement().executeQuery(
				"SELECT @@character_set_results");
		assertTrue(this.rs.next());
		
		String toCheck = null;
		
		if (versionMeetsMinimum(4, 1, 15)) {
			if (versionMeetsMinimum(5, 0)) {
				if (versionMeetsMinimum(5, 0, 13)) {
					toCheck = null;
				} else {
					toCheck = "NULL";
				}
			} else {
				toCheck = null;
			}
		} else {
			toCheck = "NULL";
		}
		
		assertEquals(toCheck, this.rs.getString(1));

		this.rs = connToMySQL.createStatement().executeQuery(
				"SHOW SESSION VARIABLES LIKE 'character_set_client'");
		assertTrue(this.rs.next());
		
		//Cause of utf8mb4
		assertEquals(0, this.rs.getString(2).indexOf("utf8"));

		connToMySQL.close();

		connToMySQL = pooledConnection.getConnection();
		this.rs = connToMySQL.createStatement().executeQuery(
				"SELECT @@character_set_results");
		assertTrue(this.rs.next());
		assertEquals(toCheck, this.rs.getString(1));

		this.rs = connToMySQL.createStatement().executeQuery(
				"SHOW SESSION VARIABLES LIKE 'character_set_client'");
		assertTrue(this.rs.next());

		//Cause of utf8mb4
		assertEquals(0, this.rs.getString(2).indexOf("utf8"));

		pooledConnection.getConnection().close();
	}
}
开发者ID:hinsenchan，项目名称:fil_project_mgmt_app_v2，代码行数:63，代码来源:DataSourceTest.java


注：本文中的com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource.getPooledConnection方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。