Examples of org.jooq.DSLContext.query()

org.jooq.DSLContext.query()
Create a new query holding plain SQL. There must not be any binding variables contained in the SQL.
Example:
```
 String sql = "SET SCHEMA 'abc'";
```
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses! @param sql The SQL @return A query wrapping the plain SQL

    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);
        assertEquals(0, result[0]);

View Full Code Here

        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);
        assertEquals(0, result[0]);
        assertEquals(1, result[1]);

View Full Code Here


    @Test
    public void testBatchMultiple() {
        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)

View Full Code Here


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


        Query query = e.query("insert into x values(1)");


        try {
            query.execute();
            fail();
        }

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.