java.lang.AutoCloseable
, java.sql.ResultSet
, java.sql.Wrapper
, AwareVTI
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:
VTITemplate.ColumnDescriptor
Modifier and Type | Field | 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 | Description |
---|---|
ContainedRoles(java.lang.String roleid) |
Constructor.
|
ContainedRoles(java.lang.String roleid,
int inverse) |
Constructor.
|
Modifier and Type | Method | Description |
---|---|---|
void |
close() |
|
java.sql.ResultSetMetaData |
getMetaData() |
|
java.lang.String |
getString(int columnIndex) |
|
boolean |
next() |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
updateObject, updateObject, updateObject, updateObject
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
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
java.sql.SQLException
ResultSet.next()
public void close()
ResultSet.close()
public java.sql.ResultSetMetaData getMetaData()
getMetaData
in interface java.sql.ResultSet
getMetaData
in class VTITemplate
ResultSet.getMetaData()
public java.lang.String getString(int columnIndex) throws java.sql.SQLException
getString
in interface java.sql.ResultSet
getString
in class VTITemplate
java.sql.SQLException
ResultSet.getString(int)
Apache Derby V10.14 Internals - Copyright © 2004,2018 The Apache Software Foundation. All Rights Reserved.