Package org.jooq.util.oracle

Examples of org.jooq.util.oracle.OracleFactory

199
200
201
202
203
204
205
        }
    }

    @Override
    protected OracleFactory create(Settings settings) {
        return new OracleFactory(getConnection(), settings);
    }
View Full Code Here
809
810
811
812
813
814
815
    // -------------------------------------------------------------------------
    // Oracle-specific tests
    // -------------------------------------------------------------------------

    private OracleFactory ora() {
        return new OracleFactory(create().getConnection(), create().getSettings());
    }
View Full Code Here
49
50
51
52
53
54
55
    @Override
    protected OracleFactory create(Settings settings) {
        settings = (settings != null) ? settings : new Settings();
        settings.withStatementType(StatementType.STATIC_STATEMENT);
        settings.withRenderFormatted(true);
        return new OracleFactory(getConnection(), settings);
    }
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
     */
    public static void main(String[] args) throws Exception {
        Class.forName("oracle.jdbc.OracleDriver");
        Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "TEST", "TEST");

        OracleFactory ora = new OracleFactory(connection);
        ora.fetch("select * from t_book b join t_author a on b.author_id = a.id");

        // TODO [#1113] This doesn't work yet
//        System.out.println("Standalone call:");
//        System.out.println("----------------");
//        for (DbmsXplanTypeRecord record : DbmsXplan.displayCursor(ora, null, null, "ALLSTATS LAST").get()) {
//            System.out.println(record.getPlanTableOutput());
//        }

        // [#1114] Unnesting TABLE of OBJECT
        System.out.println("Unnested table:");
        System.out.println("---------------");
        for (String row : ora.select()
                             .from(table(DbmsXplan.displayCursor(null, null, "ALLSTATS LAST")))
                             .fetch(0, String.class)) {

            System.out.println(row);
        }
View Full Code Here
138
139
140
141
142
143
144
    @Before
    public void setUp() throws Exception {
        context = new Mockery();
        statement = context.mock(PreparedStatement.class);
        create = new OracleFactory((Connection) null);
    }
View Full Code Here
TOP

Related Classes of org.jooq.util.oracle.OracleFactory

  • org.jooq.examples.DBMS_XPLAN
  • org.jooq.test.jOOQOracleTest
  • org.jooq.test.jOOQOracleTestInline
  • org.jooq.test.jOOQTest
    • Copyright © 2018 www.massapicom. 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.