Examples of org.jitterbit.integration.server.db.lookup.DbExecute.execute()

org.jitterbit.integration.server.db.lookup.DbExecute.execute()

Executes the given SQL statement and returns the resulting result set as a list of Strings arrays.

The maxNumberOfRows argument limits the number of rows to return. If the result set contains more rows they are ignored. @param sql the SQL statement to execute @param maxNumberOfRows the maximum number of rows to return. If < 1 all rows will be returned @return a DbExecuteResult object representing the result of executing thestatement @throws SQLException if an error occurs when running the statement

    protected DbExecuteResult doWork(JdbcSession session) throws EngineSessionException, ServerAccessException,
                    ServerDbException {
        try {
            DbExecute exec = session.getDbExecute(entityId, connParams);
            exec.setAutoCommit(autoCommit);
            return exec.execute(sql, maxNumberOfRows);
        } catch (SQLException e) {
            throw new EngineSessionException(e);
        }
    }

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.