public class ContainedRoles extends VTITemplate
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:
Modifier and Type | Field and Description |
---|---|
private static ResultColumnDescriptor[] |
columnInfo |
(package private) boolean |
initialized |
(package private) boolean |
inverse |
private static java.sql.ResultSetMetaData |
metadata |
(package private) java.lang.String |
nextRole |
(package private) RoleClosureIterator |
rci |
(package private) java.lang.String |
role |
Constructor and Description |
---|
ContainedRoles(java.lang.String roleid)
Constructor.
|
ContainedRoles(java.lang.String roleid,
int inverse)
Constructor.
|
Modifier and Type | Method and Description |
---|---|
void |
close() |
java.sql.ResultSetMetaData |
getMetaData() |
java.lang.String |
getString(int columnIndex) |
boolean |
next() |
getBigDecimal, getBigDecimal, getBoolean, getByte, getBytes, getDate, getDouble, getFloat, getInt, getLong, getObject, getShort, getString, getTime, getTimestamp
absolute, afterLast, beforeFirst, cancelRowUpdates, clearWarnings, deleteRow, findColumn, first, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getByte, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getConcurrency, getCursorName, getDate, getDate, getDate, getDouble, getFetchDirection, getFetchSize, getFloat, getInt, getLong, getObject, getObject, getObject, getRef, getRef, getRow, getShort, getStatement, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, insertRow, isAfterLast, isBeforeFirst, isFirst, isLast, last, moveToCurrentRow, moveToInsertRow, notImplemented, previous, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setFetchDirection, setFetchSize, updateArray, updateArray, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateRef, updateRef, updateRow, updateShort, updateShort, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp, wasNull
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
getHoldability, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getRowId, getRowId, getSQLXML, getSQLXML, isClosed, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateRowId, updateRowId, updateSQLXML, updateSQLXML
RoleClosureIterator rci
java.lang.String nextRole
boolean initialized
java.lang.String role
boolean inverse
private static final ResultColumnDescriptor[] columnInfo
private static final java.sql.ResultSetMetaData metadata
public ContainedRoles(java.lang.String roleid, int inverse) throws java.sql.SQLException
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).java.sql.SQLException
- This is a public API, so the internal exception is
wrapped in SQLException.public ContainedRoles(java.lang.String roleid) throws java.sql.SQLException
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).java.sql.SQLException
- This is a public API, so the internal exception is
wrapped in SQLException.public boolean next() throws java.sql.SQLException
next
in interface java.sql.ResultSet
next
in class VTITemplate
java.sql.SQLException
ResultSet.next()
public void close()
close
in interface java.lang.AutoCloseable
close
in interface java.sql.ResultSet
close
in class VTITemplate
ResultSet.close()
public java.sql.ResultSetMetaData getMetaData()
getMetaData
in interface java.sql.ResultSet
getMetaData
in class VTITemplateBase
ResultSet.getMetaData()
public java.lang.String getString(int columnIndex) throws java.sql.SQLException
getString
in interface java.sql.ResultSet
getString
in class VTITemplateBase
java.sql.SQLException
ResultSet.getString(int)
Apache Derby V10.10 Internals - Copyright © 2004,2014 The Apache Software Foundation. All Rights Reserved.