try (Connection c = DriverManager.getConnection("jdbc:mariadb://localhost:4006/testj?user=boby&password=heyPassword")) {

            Statement stmt = c.createStatement();

            stmt.execute("DROP PROCEDURE IF EXISTS basic_proc");

            stmt.execute("CREATE PROCEDURE basic_proc (INOUT t2 INT) BEGIN \n"

                            + "set t2 = t2  + 1;\n"

                            + "END");

            c.createStatement().execute("SELECT 1");

            try (CallableStatement prep = c.prepareCall("{call basic_proc(?)}")) {

                prep.setInt(1, 2);

                prep.executeQuery();

                c.createStatement().execute("SELECT 1");

            }

        }