Connection connection = DriverManager.getConnection(

                                                          "jdbc:mariadb://localhost:3310/test?createDatabaseIfNotExist=true",

                                                          "root", "");

      connection.createStatement().executeQuery("drop table if exists testtable ");

      connection.createStatement().executeQuery("create table testtable(s1 varchar(20))");

      for (int r = 0; r < 20; r++)

      {

         connection.createStatement().executeUpdate("insert into testtable values('V" + r + "')");

      }

      Statement stmt = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,

                                                  ResultSet.CONCUR_READ_ONLY);

      stmt.setFetchSize(10);

      ResultSet rs = stmt.executeQuery("select * from testtable");

      int count = 0;

      while (rs.next())

      {

         System.out.println(rs.getString(1));

         count++;

      }

      System.out.println("COUNT:" + count);

  if (resultSetScrollType == TYPE_FORWARD_ONLY) resultSet.clear();

   rowPointer = 0;