Re: Issue while using transactions in sql apache ignite console grid gain

[akurbanov]

Hello,

Can confirm that this is not working because multistatement execution is not
yet supported by the console/visor.

I've tested your case a little with JDBC and it works just fine for the
statements you have shared with snippet like this:

        try (Connection conn =
DriverManager.getConnection("jdbc:ignite:thin://127.0.0.1/")) {
            try (Statement stmt = conn.createStatement()) {
                stmt.execute("BEGIN;");

                stmt.execute("INSERT INTO TempTable (id, name, LastName,
age) VALUES (1111, 'Avhy',\n" +
                        "'Ghale', 32);");

                stmt.execute("ROLLBACK;");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }

Best regards,
Anton



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/