Examples of DboFactory

Examples of org.jooq.util.ase.sys.DboFactory

75
76
77
78
79
80
81
    private static final JooqLogger log = JooqLogger.getLogger(ASEDatabase.class);

    @Override
    public Factory create() {
        return new DboFactory(getConnection());
    }
View Full Code Here

Examples of org.jooq.util.maven.example.ase.DboFactory

62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
    @Test
    public void testInstanceModel() throws Exception {
        Class.forName("net.sourceforge.jtds.jdbc.Driver");
        Connection connection = DriverManager.getConnection("jdbc:jtds:sybase://lukas-hp:5000/TEST", "sa", "");
        DboFactory create = new DboFactory(connection);

        TBook b = T_BOOK.as("b");
        TAuthor a = T_AUTHOR.as("a");
        TBookStore s = T_BOOK_STORE.as("s");
        TBookToBookStore t = T_BOOK_TO_BOOK_STORE.as("t");

        Result<Record> result =
        create.select(a.FIRST_NAME, a.LAST_NAME, countDistinct(s.NAME))
              .from(a)
              .join(b).on(b.AUTHOR_ID.equal(a.ID))
              .join(t).on(t.BOOK_ID.equal(b.ID))
              .join(s).on(t.BOOK_STORE_NAME.equal(s.NAME))
              .groupBy(a.FIRST_NAME, a.LAST_NAME)
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.