Examples of org.jooq.DSLContext.fetch()

org.jooq.DSLContext.fetch()
Execute a {@link ResultQuery} in the context of this DSLContext and returnresults. @param query The query to execute @return The result @throws DataAccessException if something went wrong executing the query @see ResultQuery#fetch()

    }


    @Test
    public void testEmptyResult() {
        DSLContext e = DSL.using(new MockConnection(new EmptyResult()), SQLDialect.H2);
        Result<Record> result = e.fetch("select ?, ? from dual", 1, 2);


        assertEquals(0, result.size());
        assertEquals(3, result.fields().length);
        for (int i = 0; i < 3; i++) {
            assertEquals(TABLE1.field(i).getName(), result.field(i).getName());

View Full Code Here

    }


    @Test
    public void testSingleResult() {
        DSLContext e = DSL.using(new MockConnection(new SingleResult()), SQLDialect.H2);
        Result<Record> result = e.fetch("select ?, ? from dual", 1, 2);


        assertEquals(1, result.size());
        assertEquals(3, result.fields().length);


        for (int i = 0; i < 3; i++) {

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.