Java Code Examples for java.sql.ResultSet#setFetchDirection()

The following examples show how to use java.sql.ResultSet#setFetchDirection() . These examples are extracted from open source projects. You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
@Override
public void optimizeResultSet(ResultSet resultSet,
		OperationType operationType) {

	switch (operationType){
	case READ:
		try {
			resultSet.setFetchDirection(ResultSet.FETCH_FORWARD);
			// SQLite driver MUST HAVE fetch size set to 0 - otherwise it limits number of results returned
			resultSet.setFetchSize(0);
		} catch(SQLException ex) {
			//TODO: for now, do nothing
		}
	}

}
 
Example 2
@Override
public void optimizeResultSet(ResultSet resultSet,
		OperationType operationType) {

	switch (operationType){
	case READ:
		try {
			resultSet.setFetchDirection(ResultSet.FETCH_FORWARD);
			// SQLite driver MUST HAVE fetch size set to 0 - otherwise it limits number of results returned
			resultSet.setFetchSize(0);
		} catch(SQLException ex) {
			//TODO: for now, do nothing
		}
	}

}
 
Example 3
@Override
public final void setFetchDirection(final int direction) throws SQLException {
    Collection<SQLException> exceptions = new LinkedList<>();
    for (ResultSet each : resultSets) {
        try {
            each.setFetchDirection(direction);
        } catch (final SQLException ex) {
            exceptions.add(ex);
        }
    }
    throwSQLExceptionIfNecessary(exceptions);
}
 
Example 4
Source Project: Openfire   File: DbConnectionManager.java    License: Apache License 2.0 5 votes vote down vote up
/**
 * Scrolls forward in a result set the specified number of rows. If the JDBC driver
 * supports the feature, the cursor will be moved directly. Otherwise, we scroll
 * through results one by one manually by calling {@code rs.next()}.
 *
 * @param rs the ResultSet object to scroll.
 * @param rowNumber the row number to scroll forward to.
 * @throws SQLException if an error occurs.
 */
public static void scrollResultSet(ResultSet rs, int rowNumber) throws SQLException {
    // If the driver supports scrollable result sets, use that feature.
    if (isScrollResultsSupported()) {
        if (rowNumber > 0) {
            // We will attempt to do a relative fetch. This may fail in SQL Server if
            // <resultset-navigation-strategy> is set to absolute. It would need to be
            // set to looping to work correctly.
            // If so, manually scroll to the correct row.
            try {
                rs.setFetchDirection(ResultSet.FETCH_FORWARD);
                rs.relative(rowNumber);
            }
            catch (SQLException e) {
                // TODO change "Error ..." to "Disabling ..."
                Log.error("Error in JDBC method rs.relative(rowNumber).", e);
                //Log.error("Disabling JDBC method rs.relative(rowNumber).", e);
                //scrollResultsSupported = false;
                for (int i = 0; i < rowNumber; i++) {
                    rs.next();
                }
            }
        }
    }
    // Otherwise, manually scroll to the correct row.
    else {
        for (int i = 0; i < rowNumber; i++) {
            rs.next();
        }
    }
}
 
Example 5
@Override
public void optimizeResultSet(ResultSet resultSet, OperationType operationType) {
	switch (operationType){
	case READ:
		try {
			resultSet.setFetchDirection(ResultSet.FETCH_FORWARD);
			resultSet.setFetchSize(DEFAULT_FETCH_SIZE);
		} catch(SQLException ex) {
			//TODO: for now, do nothing
		}
	}
}
 
Example 6
@Override
public void optimizeResultSet(ResultSet res,OperationType operType){
	if (operType == OperationType.READ) {
		try {
			res.setFetchDirection(ResultSet.FETCH_FORWARD);
		}catch(SQLException ex){
			//TODO: for now, do nothing
		}
	}
}
 
Example 7
@NoWarning("SQL_BAD_RESULTSET_ACCESS")
void notBug2(ResultSet any) throws SQLException {
    any.setFetchDirection(0);
}