Package com.mysql.jdbc

Examples of com.mysql.jdbc.ReplicationConnection.createStatement()

5034
5035
5036
5037
5038
5039
5040
5041
5042
5043
5044
    UnreliableSocketFactory.downHost("slave1");
    UnreliableSocketFactory.downHost("slave2");
   
    assertTrue(conn2.isMasterConnection());
    // should succeed, as we're still on master:
    conn2.createStatement().execute("/* ping */ SELECT 1");   
   
    UnreliableSocketFactory.dontDownHost("slave1");
    UnreliableSocketFactory.dontDownHost("slave2");
    UnreliableSocketFactory.downHost("master");
   
View Full Code Here
5041
5042
5043
5044
5045
5046
5047
5048
5049
5050
5051
    UnreliableSocketFactory.dontDownHost("slave1");
    UnreliableSocketFactory.dontDownHost("slave2");
    UnreliableSocketFactory.downHost("master");
   
    try {
      conn2.createStatement().execute("/* ping */ SELECT 1"); 
      fail("should have failed because master is offline");
    } catch (SQLException e) {
     
    }
   
View Full Code Here
5048
5049
5050
5051
5052
5053
5054
5055
5056
5057
5058
    } catch (SQLException e) {
     
    }
   
    UnreliableSocketFactory.dontDownHost("master");
    conn2.createStatement().execute("SELECT 1"); 
    // continue on slave2:
    conn2.setReadOnly(true);
   
    // should succeed, as slave2 is up:
    conn2.createStatement().execute("/* ping */ SELECT 1"); 
View Full Code Here
5053
5054
5055
5056
5057
5058
5059
5060
5061
5062
5063
    conn2.createStatement().execute("SELECT 1"); 
    // continue on slave2:
    conn2.setReadOnly(true);
   
    // should succeed, as slave2 is up:
    conn2.createStatement().execute("/* ping */ SELECT 1"); 
   
    UnreliableSocketFactory.downHost("slave2");
   
    try {
      conn2.createStatement().execute("/* ping */ SELECT 1"); 
View Full Code Here
5058
5059
5060
5061
5062
5063
5064
5065
5066
5067
5068
    conn2.createStatement().execute("/* ping */ SELECT 1"); 
   
    UnreliableSocketFactory.downHost("slave2");
   
    try {
      conn2.createStatement().execute("/* ping */ SELECT 1"); 
      fail("should have failed because slave2 is offline and the active chosen connection.");
    } catch (SQLException e) {}
     
   
    conn2.close();
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.