Class ContainedRoles

java.lang.Object

org.apache.derby.vti.VTITemplate

org.apache.derby.diag.ContainedRoles

All Implemented Interfaces:

AutoCloseable, ResultSet, Wrapper, AwareVTI

public class ContainedRoles
extends VTITemplate

Contained roles shows all roles contained in the given identifier, or if the second argument, if given, is not 0, the inverse relation; all roles who contain the given role identifier.

To use it, query it as follows:

 SELECT * FROM TABLE(SUSCS_DIAG.CONTAINED_ROLES('FOO')) t; 

 SELECT * FROM TABLE(CONTAINED_ROLES('FOO', 1)) t; 

The following columns will be returned:

• ROLEID -- VARCHAR(128) NOT NULL

Nested Class Summary

Nested classes/interfaces inherited from class VTITemplate

VTITemplate.ColumnDescriptor

Field Summary

Fields

Modifier and Type	Field	Description
private static final ResultColumnDescriptor[]	columnInfo
(package private) boolean	initialized
(package private) boolean	inverse
private static final ResultSetMetaData	metadata
(package private) String	nextRole
(package private) RoleClosureIterator	rci
(package private) String	role

Fields inherited from interface ResultSet

CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE

Constructor Summary

Constructors

Constructor	Description
ContainedRoles(String roleid)	Constructor.
ContainedRoles(String roleid, int inverse)	Constructor.

Method Summary

Modifier and Type	Method	Description
void	close()
ResultSetMetaData	getMetaData()
String	getString(int columnIndex)
boolean	next()

Methods inherited from class VTITemplate

absolute, afterLast, beforeFirst, cancelRowUpdates, clearWarnings, deleteRow, findColumn, first, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getConcurrency, getContext, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getFetchDirection, getFetchSize, getFloat, getFloat, getHoldability, getInt, getInt, getLong, getLong, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getObject, getObject, getRef, getRef, getReturnTableSignature, getRow, getRowId, getRowId, getShort, getShort, getSQLXML, getSQLXML, getStatement, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, insertRow, isAfterLast, isBeforeFirst, isClosed, isFirst, isLast, isWrapperFor, last, moveToCurrentRow, moveToInsertRow, notImplemented, previous, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setContext, setFetchDirection, setFetchSize, unwrap, updateArray, updateArray, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateClob, updateClob, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateRef, updateRef, updateRow, updateRowId, updateRowId, updateShort, updateShort, updateSQLXML, updateSQLXML, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp, wasNull

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface ResultSet

updateObject, updateObject, updateObject, updateObject

Field Details

rci

RoleClosureIterator rci

nextRole

String nextRole

initialized

boolean initialized

role

String role

inverse

boolean inverse

columnInfo

private static final ResultColumnDescriptor[] columnInfo

metadata

private static final ResultSetMetaData metadata

Constructor Details

ContainedRoles

public ContainedRoles(String roleid,
 int inverse)
               throws SQLException

Constructor.

Parameters:

roleid - The role identifier for which we want to find the set of contained roles (inclusive). The identifier is expected to be in SQL form (not case normal form).

inverse - If != 0, use the inverse relation: find those roles which all contain roleid (inclusive).

Throws:

SQLException - This is a public API, so the internal exception is wrapped in SQLException.

ContainedRoles

public ContainedRoles(String roleid)
               throws SQLException

Constructor.

Parameters:

roleid - The role identifier for which we want to find the set of contained roles (inclusive). The identifier is expected to be in SQL form (not case normal form).

Throws:

SQLException - This is a public API, so the internal exception is wrapped in SQLException.

Method Details

next

public boolean next()
             throws SQLException

Throws:

SQLException

See Also:

• ResultSet.next()

close

public void close()

See Also:

• ResultSet.close()

getMetaData

public ResultSetMetaData getMetaData()

Specified by:

getMetaData in interface ResultSet

Overrides:

getMetaData in class VTITemplate

See Also:

• ResultSet.getMetaData()

getString

public String getString(int columnIndex)
                 throws SQLException

Specified by:

getString in interface ResultSet

Overrides:

getString in class VTITemplate

Throws:

SQLException

See Also:

• ResultSet.getString(int)