Examples of org.jooq.ExecuteContext.statement()

org.jooq.ExecuteContext.statement()
The {@link PreparedStatement} that is being executed or nullif the statement is unknown or if there was no statement.
This can be any of the following:
- A java.sql.PreparedStatement from your JDBC driver when a jOOQ Query is being executed as {@link StatementType#PREPARED_STATEMENT}
- A java.sql.Statement from your JDBC driver wrapped in a java.sql.PreparedStatement when your jOOQ Query is being executed as {@link StatementType#STATIC_STATEMENT}
- A java.sql.CallableStatement when you are executing a jOOQ Routine

            // [#1520] TODO: Should the number of bind values be checked, here?
            ctx.sql(create.render(query));
            listener.renderEnd(ctx);


            listener.prepareStart(ctx);
            ctx.statement(connection.prepareStatement(ctx.sql()));
            listener.prepareEnd(ctx);


            for (Object[] bindValues : allBindValues) {
                listener.bindStart(ctx);

View Full Code Here

                //                 plain SQL. In that case, infer the bind value type directly from the bind value
                List<Field<?>> params = (paramTypes.length > 0)
                    ? fields(bindValues, paramTypes)
                    : fields(bindValues);


                visitAll(new DefaultBindContext(configuration, ctx.statement()), params);


                listener.bindEnd(ctx);
                ctx.statement().addBatch();
            }

View Full Code Here

                    : fields(bindValues);


                visitAll(new DefaultBindContext(configuration, ctx.statement()), params);


                listener.bindEnd(ctx);
                ctx.statement().addBatch();
            }


            listener.executeStart(ctx);
            int[] result = ctx.statement().executeBatch();

View Full Code Here

                listener.bindEnd(ctx);
                ctx.statement().addBatch();
            }


            listener.executeStart(ctx);
            int[] result = ctx.statement().executeBatch();


            int[] batchRows = ctx.batchRows();
            for (int i = 0; i < batchRows.length && i < result.length; i++)
                batchRows[i] = result[i];

View Full Code Here

        ExecuteContext ctx = new DefaultExecuteContext(configuration, queries);
        ExecuteListener listener = new ExecuteListeners(ctx);
        Connection connection = ctx.connection();


        try {
            ctx.statement(new SettingsEnabledPreparedStatement(connection));


            String[] batchSQL = ctx.batchSQL();
            for (int i = 0; i < queries.length; i++) {
                listener.renderStart(ctx);
                batchSQL[i] = DSL.using(configuration).renderInlined(queries[i]);

View Full Code Here

            }


            for (String sql : batchSQL) {
                ctx.sql(sql);
                listener.prepareStart(ctx);
                ctx.statement().addBatch(sql);
                listener.prepareEnd(ctx);
                ctx.sql(null);
            }


            listener.executeStart(ctx);

View Full Code Here

                ctx.sql(null);
            }


            listener.executeStart(ctx);


            int[] result = ctx.statement().executeBatch();
            int[] batchRows = ctx.batchRows();
            for (int i = 0; i < batchRows.length && i < result.length; i++)
                batchRows[i] = result[i];


            listener.executeEnd(ctx);

View Full Code Here

            listener.renderStart(ctx);
            ctx.sql(create(configuration).render(this));
            listener.renderEnd(ctx);


            listener.prepareStart(ctx);
            ctx.statement(connection.prepareCall(ctx.sql()));
            listener.prepareEnd(ctx);


            listener.bindStart(ctx);
            create(configuration).bind(this, ctx.statement());
            registerOutParameters(configuration, (CallableStatement) ctx.statement());

View Full Code Here

            listener.prepareStart(ctx);
            ctx.statement(connection.prepareCall(ctx.sql()));
            listener.prepareEnd(ctx);


            listener.bindStart(ctx);
            create(configuration).bind(this, ctx.statement());
            registerOutParameters(configuration, (CallableStatement) ctx.statement());
            listener.bindEnd(ctx);


            // Postgres requires two separate queries running in the same
            // transaction to be executed when fetching refcursor types

View Full Code Here

            ctx.statement(connection.prepareCall(ctx.sql()));
            listener.prepareEnd(ctx);


            listener.bindStart(ctx);
            create(configuration).bind(this, ctx.statement());
            registerOutParameters(configuration, (CallableStatement) ctx.statement());
            listener.bindEnd(ctx);


            // Postgres requires two separate queries running in the same
            // transaction to be executed when fetching refcursor types
            boolean autoCommit = connection.getAutoCommit();

View Full Code Here

0 1 2

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.