Examples of org.jooq.DSLContext.batch()

org.jooq.DSLContext.batch()
Create a batch statement to execute a set of queries in batch mode (without bind values).
This essentially runs the following logic:
```
 Statement s = connection.createStatement(); for (Query query : queries) { s.addBatch(query.getSQL(true)); } s.execute(); 
```
@see Statement#executeBatch()

    @Test
    public void testBatchSingle() {
        DSLContext e = DSL.using(new MockConnection(new BatchSingle()), SQLDialect.H2);


        int[] result =
        e.batch(
            e.query("insert into x values(1)"),
            e.query("insert into x values(2)")
        ).execute();


        assertEquals(2, result.length);

View Full Code Here

        DSLContext e = DSL.using(new MockConnection(new BatchMultiple()), SQLDialect.H2);


        Query query = e.query("insert into x values(?, ?)", null, null);


        int[] result =
        e.batch(query)
         .bind(1, 2)
         .bind(3, 4)
         .execute();


        assertEquals(2, result.length);

View Full Code Here

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.