List of usage examples for io.vertx.sqlclient Transaction commit
void commit();
From source file:examples.SqlClientExamples.java
License:Apache License
public void usingCursors01(SqlConnection connection) { connection.prepare("SELECT * FROM users WHERE first_name LIKE $1", ar1 -> { if (ar1.succeeded()) { PreparedQuery pq = ar1.result(); // Cursors require to run within a transaction Transaction tx = connection.begin(); // Create a cursor Cursor cursor = pq.cursor(Tuple.of("julien")); // Read 50 rows cursor.read(50, ar2 -> {//from w ww.jav a 2 s. c o m if (ar2.succeeded()) { RowSet<Row> rows = ar2.result(); // Check for more ? if (cursor.hasMore()) { // Repeat the process... } else { // No more rows - commit the transaction tx.commit(); } } }); } }); }
From source file:examples.SqlClientExamples.java
License:Apache License
public void usingCursors03(SqlConnection connection) { connection.prepare("SELECT * FROM users WHERE first_name LIKE $1", ar1 -> { if (ar1.succeeded()) { PreparedQuery pq = ar1.result(); // Streams require to run within a transaction Transaction tx = connection.begin(); // Fetch 50 rows at a time RowStream<Row> stream = pq.createStream(50, Tuple.of("julien")); // Use the stream stream.exceptionHandler(err -> { System.out.println("Error: " + err.getMessage()); });/*w w w .ja v a2 s . co m*/ stream.endHandler(v -> { tx.commit(); System.out.println("End of stream"); }); stream.handler(row -> { System.out.println("User: " + row.getString("last_name")); }); } }); }