java.lang.AutoCloseable, java.sql.ResultSet, java.sql.Wrapper, AwareVTIpublic 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, waitupdateObject, updateObject, updateObject, updateObjectabsolute, 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, wasNullRoleClosureIterator 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.SQLExceptionResultSet.next()public void close()
ResultSet.close()public java.sql.ResultSetMetaData getMetaData()
getMetaData in interface java.sql.ResultSetgetMetaData in class VTITemplateResultSet.getMetaData()public java.lang.String getString(int columnIndex)
throws java.sql.SQLException
getString in interface java.sql.ResultSetgetString in class VTITemplatejava.sql.SQLExceptionResultSet.getString(int)Apache Derby V10.14 Internals - Copyright © 2004,2018 The Apache Software Foundation. All Rights Reserved.