Java FabricMySQLDataSource.getConnection方法代码示例

import com.mysql.fabric.jdbc.FabricMySQLDataSource; //导入方法依赖的package包/类
/**
 * Test that we can connect with the data source, given a server group name
 */
public void testConnectionDataSource() throws Exception {
    if (!this.isSetForFabricTest) {
        return;
    }
    FabricMySQLDataSource ds = getNewDefaultDataSource();
    ds.setFabricServerGroup("fabric_test1_global");
    Connection c = ds.getConnection(this.username, this.password);
    // same as above
    ResultSet rs = c.createStatement().executeQuery("select user()");
    rs.next();
    String userFromDb = rs.getString(1).split("@")[0];
    assertEquals(this.username, userFromDb);
    rs.close();
    c.close();
}
 

import com.mysql.fabric.jdbc.FabricMySQLDataSource; //导入方法依赖的package包/类
public void testBug21876798() throws Exception {
    if (!this.isSetForFabricTest) {
        return;
    }

    FabricMySQLDataSource ds = getNewDefaultDataSource();
    ds.setRewriteBatchedStatements(true);

    this.conn = (FabricMySQLConnection) ds.getConnection(this.username, this.password);
    this.conn.setServerGroupName("ha_config1_group");

    this.conn.createStatement().executeUpdate("drop table if exists bug21876798");
    this.conn.createStatement().executeUpdate("create table bug21876798(x varchar(100))");
    PreparedStatement ps = this.conn.prepareStatement("update bug21876798 set x = ?");
    ps.setString(1, "abc");
    ps.addBatch();
    ps.setString(1, "def");
    ps.addBatch();
    ps.setString(1, "def");
    ps.addBatch();
    ps.setString(1, "def");
    ps.addBatch();
    ps.setString(1, "def");
    ps.addBatch();
    // this would throw a ClassCastException
    ps.executeBatch();
}
 

import com.mysql.fabric.jdbc.FabricMySQLDataSource; //导入方法依赖的package包/类
/**
 * Test Bug#82094 - ConcurrentModificationException on Fabric connections after topology changes.
 * 
 * This test requires a Fabric instance running with a HA group (ha_config1_group) containing three servers, one promoted to master and failure detection
 * turned on.
 * Note that removing one or the other secondary server is a distinct case and only one of them causes the reported failure. This is so because of the order
 * the elements on the slave servers HashSet, from the ReplicationConnectionGroup object, are iterated. So, we remove one at a time in this test to make
 * sure we cover both cases.
 */
public void testBug82094() throws Exception {
    if (!this.isSetForFabricTest) {
        return;
    }

    FabricMySQLDataSource ds = getNewDefaultDataSource();
    ds.setFabricServerGroup("ha_config1_group");
    this.conn = (FabricMySQLConnection) ds.getConnection(this.username, this.password);
    this.conn.createStatement().close(); // Make sure there is an internal ReplicationConnection.

    FabricConnection fabricConn = new FabricConnection(this.fabricUrl, this.fabricUsername, this.fabricPassword);

    for (Server server : fabricConn.getServerGroup("ha_config1_group").getServers()) {
        if (server.isSlave()) {
            try {
                this.conn.transactionCompleted();

                // Remove Secondary server.
                fabricConn.getClient().removeServerFromGroup(server.getGroupName(), server.getHostname(), server.getPort());
                // Make sure the TTL expires before moving on.
                fabricConn.refreshState();
                while (!fabricConn.isStateExpired()) {
                    Thread.sleep(1000);
                }

                this.conn.transactionCompleted();
            } finally {
                // Add Secondary server back.
                fabricConn.getClient().addServerToGroup(server.getGroupName(), server.getHostname(), server.getPort());
                // Make sure the TTL expires before moving on.
                fabricConn.refreshState();
                while (!fabricConn.isStateExpired()) {
                    Thread.sleep(1000);
                }
            }
        }
    }
    this.conn.close();
}
 

import com.mysql.fabric.jdbc.FabricMySQLDataSource; //导入方法依赖的package包/类
/**
 * Test that we can connect with the data source, given a server group name
 */
public void testConnectionDataSource() throws Exception {
	FabricMySQLDataSource ds = getNewDefaultDataSource();
	ds.setFabricServerGroup("fabric_test1_global");
	Connection c = ds.getConnection(this.username, this.password);
	// same as above
	ResultSet rs = c.createStatement().executeQuery("select user()");
	rs.next();
	String userFromDb = rs.getString(1).split("@")[0];
	assertEquals(this.username, userFromDb);
	rs.close();
	c.close();
}
 

import com.mysql.fabric.jdbc.FabricMySQLDataSource; //导入方法依赖的package包/类
/**
 * Test that we can connect with the data source, given a server group name
 */
public void testConnectionDataSource() throws Exception {
    FabricMySQLDataSource ds = getNewDefaultDataSource();
    ds.setFabricServerGroup("fabric_test1_global");
    Connection c = ds.getConnection(this.username, this.password);
    // same as above
    ResultSet rs = c.createStatement().executeQuery("select user()");
    rs.next();
    String userFromDb = rs.getString(1).split("@")[0];
    assertEquals(this.username, userFromDb);
    rs.close();
    c.close();
}