Examples of org.h2.tools.Server.stop()

org.h2.tools.Server.stop()
Stops the server.

        stat.execute("insert into t1 values(1, 'a'), (2, 'b'), (3, 'c')");
        rs = stat.executeQuery("select count(*) from t1");
        rs.next();
        assertEquals(3, rs.getInt(1));


        n2.stop();
        DeleteDbFiles.main("-dir", getBaseDir() + "/node2", "-quiet");


        stat.execute("insert into t1 values(4, 'd'), (5, 'e')");
        rs = stat.executeQuery("select count(*) from t1");
        rs.next();

View Full Code Here

        rs = stat.executeQuery("select count(*) from t1");
        rs.next();
        assertEquals(5, rs.getInt(1));


        n1.stop();
        n2.stop();
        deleteFiles();
    }


    private void testRollback() throws SQLException {
        if (config.memory || config.networked || config.cipher != null) {

View Full Code Here

        rs = stat.executeQuery("select * from test order by id");
        assertFalse(rs.next());
        conn.close();


        n1.stop();
        n2.stop();
        deleteFiles();
    }


    private void testCase() throws SQLException {
        if (config.memory || config.networked || config.cipher != null) {

View Full Code Here

        assertTrue(rs.next());
        assertFalse(rs.next());
        conn.close();


        // stop server 2, and test if only one server is available
        n2.stop();


        conn = DriverManager.getConnection(urlCluster, user, password);
        stat = conn.createStatement();
        rs = stat.executeQuery("select * from test");
        assertTrue(rs.next());

View Full Code Here

        // delete the rows, but don't commit
        connApp.setAutoCommit(false);
        connApp.createStatement().execute("delete from test");


        // stop server 2, and test if only one server is available
        n2.stop();


        // rollback the transaction
        connApp.createStatement().executeQuery("select count(*) from test");
        connApp.rollback();
        check(connApp, len, "''");

View Full Code Here

        // test non-admin cluster connection if only one server runs
        connApp2 = DriverManager.getConnection(urlCluster + ";AUTO_RECONNECT=TRUE", user2, password2);
        check(connApp2, len, "''");
        connApp2.close();


        n2.stop();
        deleteFiles();
    }


    private void testStartStopCluster() throws SQLException {
        if (config.memory || config.networked || config.cipher != null) {

View Full Code Here

        conn = DriverManager.getConnection("jdbc:h2:tcp://" + serverList + "/test", user, password);
        check(conn, len, "'"+serverList+"'");
        conn.close();


        // stop server 2, and test if only one server is available
        n2.stop();
        conn = DriverManager.getConnection("jdbc:h2:tcp://" + serverList + "/test", user, password);
        check(conn, len, "''");
        conn.close();
        conn = DriverManager.getConnection("jdbc:h2:tcp://" + serverList + "/test", user, password);
        check(conn, len, "''");

View Full Code Here


        n1.stop();


        stat.execute("CREATE TABLE A(ID INT)");
        conn.close();
        n2.stop();


        n1 = org.h2.tools.Server.createTcpServer("-tcpPort", "" + port1, "-baseDir", getBaseDir() + "/node1").start();
        conn = DriverManager.getConnection("jdbc:h2:tcp://localhost:"+port1+"/test;CLUSTER=''", user, password);
        check(conn, len, "''");
        conn.close();

View Full Code Here

        n2 = org.h2.tools.Server.createTcpServer("-tcpPort", "" + port2, "-baseDir", getBaseDir() + "/node2").start();
        conn = DriverManager.getConnection("jdbc:h2:tcp://localhost:" + port2 + "/test;CLUSTER=''", user, password);
        check(conn, len, "''");
        conn.createStatement().execute("SELECT * FROM A");
        conn.close();
        n2.stop();
        deleteFiles();
    }


    private void deleteFiles() throws SQLException {
        DeleteDbFiles.main("-dir", getBaseDir() + "/node1", "-quiet");

View Full Code Here

    private void testOldClientNewServer() throws Exception {
        Server server = org.h2.tools.Server.createTcpServer("-tcpPort", "9001");
        server.start();
        assertThrows(ErrorCode.DRIVER_VERSION_ERROR_2, driver).
                connect("jdbc:h2:tcp://localhost:9001/mem:test", null);
        server.stop();


        Class<?> serverClass = cl.loadClass("org.h2.tools.Server");
        Method m;
        m = serverClass.getMethod("createTcpServer", String[].class);
        Object serverOld = m.invoke(null, new Object[]{new String[]{"-tcpPort", "9001"}});

View Full Code Here

0 1 2

TOP

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.