Serialized Form
schemas
Collection<E> schemas
- The collection of schema objects that belong to this catalogue.
name
String name
- The name of the category.
queries
Map<K,V> queries
- The named queries associated with this category.
name
String name
- The name of the column.
type
int type
- The
Types value for the data type of the column.
content
Object content
- The object that represents the contents of the column.
type
int type
- The data type for the column as values defined in
Types.
typeName
String typeName
- The database specific name of the column type.
defaultValue
String defaultValue
- The default value for this column.
size
int size
- The size or precision of the column.
nullable
String nullable
- Defines whether the column takes
null values or not.
table
TableTypeMetaData table
- A reference to the table/view in which this column belongs.
host
String host
- The fully qualified hostname of the database server to connect to.
database
String database
- The name of the database to connect to.
port
int port
- The port to connect to.
userName
String userName
- The database user to connect as.
password
byte[] password
- The password for the database user to connect as.
host
String host
- The fully qualified hostname of the database server to connect to.
database
String database
- The name of the database to connect to.
port
int port
- The port to connect to.
userName
String userName
- The database user to connect as.
databaseType
String databaseType
- The name to use to identify the database engine.
urlPattern
String urlPattern
- The JDBC connection url pattern to use. The URL pattern contains
encoded values for variables such as
$HOST$ etc.
driver
String driver
- The fully qualified name of the JDBC driver class.
databases
TreeMap<K,V> databases
- A map used to quickly look up
DatabaseType instances by their
DatabaseType.name.
savedConnections
Map<K,V> savedConnections
- A map that stores saved
ConnectionData identified by a
unique name.
name
String name
- The name of the database engine represented by this instance.
urlPattern
String urlPattern
- The encoded JDBC url pattern to use to build a connection url to the
database.
driver
String driver
- The fully qualified name of the JDBC driver class.
version
String version
- The product version as reported by the vendor.
defaultTransaction
DBMSMetaData.Transaction defaultTransaction
- The default transaction isolation level used by the database.
jdbcMetaData
JDBCMetaData jdbcMetaData
- Metadata about the JDBC driver used to access the database
limitsMetaData
LimitsMetaData limitsMetaData
- Metadata about maximum limitsMetaData enforced by the database.
catalogues
Collection<E> catalogues
- Collection of catalogues available in the database.
schemas
Collection<E> schemas
- Collection of schemas available in the database.
referencedSchema
String referencedSchema
- The schema in which the table whose column this foreign key references
exists.
referencedTable
String referencedTable
- The table whose column this foreign key references.
columnMappings
Map<K,V> columnMappings
- The columns that comprise this foreign key and the referenced columns.
The map is defined as <ColumnMetaData,String> with the
key indicating the column on the table and the
value indicating the referenced column on ForeignKeyMetaData.referencedTable.
updateRule
ForeignKeyMetaData.Rule updateRule
- The
UPDATE_RULE for this key.
deleteRule
ForeignKeyMetaData.Rule deleteRule
- The
DELETE_RULE for this key.
deferrability
ForeignKeyMetaData.Deferrability deferrability
- The
DEFERRABILITY of this key.
unique
boolean unique
- A flag indicating whether this index represents unique values or not.
type
IndexMetaData.Type type
- A field indicating the type of the index.
sortSequence
IndexMetaData.SortSequence sortSequence
- A field indicating the sort order used by the index.
cardinality
int cardinality
- The cardinality for the index. When
IndexMetaData.type is IndexMetaData.Type.Statistic, then this is the number of rows in the table;
otherwise, it is the number of unique values in the index.
pages
int pages
- The number of pages used for the index. When
IndexMetaData.type is IndexMetaData.Type.Statistic, then this is the number of pages used for the table;
otherwise, it is the number of pages used for the index.
version
String version
- The version number of the driver.
columns
Collection<E> columns
- The name of the column(s) on which the key is defined.
- See Also:
TableTypeMetaData.getColumn(java.lang.String)
keySequence
int keySequence
- A sequence number that indicates the sequence number with a key
table
TableMetaData table
- A reference to the table in which this key belongs.
characterLength
int characterLength
- The maximum number of characters this database allows for a character
literal.
columnNameLength
int columnNameLength
- The maximum number of characters this database allows for a column
name.
columnsInGroupBy
int columnsInGroupBy
- The maximum number of columns this database allows in a
GROUP
BY clause.
columnsInIndex
int columnsInIndex
- The maximum number of columns this database allows in an index.
columnsInOrderBy
int columnsInOrderBy
- The maximum number of columns this database allows in an
ORDER
BY clause.
columnsInSelect
int columnsInSelect
- The maximum number of columns this database allows in a
SELECT
list.
columnsInTable
int columnsInTable
- The maximum number of columns this database allows in a table.
connections
int connections
- The maximum number of concurrent connections to this database that
are possible.
cursorNameLength
int cursorNameLength
- The maximum number of characters that this database allows in a
cursor name.
indexLength
int indexLength
- The maximum number of bytes this database allows for an index,
including all of the parts of the index.
procedureNameLength
int procedureNameLength
- The maximum number of characters that this database allows in a
procedure name.
rowSize
int rowSize
- The maximum number of bytes this database allows in a single row.
schemaNameLength
int schemaNameLength
- The maximum number of characters that this database allows in a
schema name.
statementLength
int statementLength
- The maximum number of characters this database allows in an
SQL
statement.
statements
int statements
- The maximum number of active statements to this database that can be
open at the same time.
tableNameLength
int tableNameLength
- The maximum number of characters this database allows in a table name.
tablesInSelect
int tablesInSelect
- The maximum number of tables this database allows in a
SELECT
statement.
userNameLength
int userNameLength
- The maximum number of characters this database allows in a user name.
name
String name
- The name of the object.
comment
String comment
- The comments associated with the table.
catalogue
CatalogueMetaData catalogue
- A reference to the parent catalogue to which this object belongs.
root
RootMetaData root
- A reference to the parent catalogue/schema to which this object belongs.
dataType
String dataType
- The data type returned by the procedure.
userDefinedType
String userDefinedType
- The name of the user defined type if
ProcedureMetaData.dataType is a user
defined type.
body
String body
- The SQL content of the procedure.
definition
String definition
- The definition of the procedure. This usually includes
ProcedureMetaData.body within it
categories
TreeMap<K,V> categories
- A map used to quickly look up
Query instances by their
Category.name.
dbmsMetaData
DBMSMetaData dbmsMetaData
- A reference to the meta data object for the database.
tables
Collection<E> tables
- The collection of
TableMetaData objects that represent all the
tables available in this schema.
views
Collection<E> views
- The collection of
ViewMetaData objects that represent all the
views available in this schema.
triggers
Collection<E> triggers
- The collection of
TriggerMetaData objects that represent all
the triggers available in this schema.
procedures
Collection<E> procedures
- The collection of
ProcedureMetaData objects that represent all
the procedures available in this schema.
sequences
Collection<E> sequences
- The collection of
SequenceMetaData objects that represent all
the sequences available in this schema.
columns
List<E> columns
- The collection of
Column instances contained in this row.
totalRows
int totalRows
- The total number of rows available in the
ResultSet
out of which this object was generated. Note that the Rows.rows collection will usually not contain the same number (usually
less) of rows as the total number available.
- Since:
- Version 1.2
rows
List<E> rows
- The collection of
Row instances contained in result set.
catalogue
CatalogueMetaData catalogue
- The
CatalogueMetaData that represents the catalog
in which the schema exists.
dataType
String dataType
- The data type for the sequence.
minimum
String minimum
- The minimum value of the sequence.
maximum
String maximum
- The maximum value of the sequence.
increment
int increment
- The value by which the sequence is incremented.
cyclePolicy
String cyclePolicy
- The cycle policy for the sequence after hitting maximum value
primaryKey
PrimaryKeyMetaData primaryKey
- The collection of primary key columns for this table.
foreignKeys
Collection<E> foreignKeys
- The collection of foreign key columns for this table.
indices
Collection<E> indices
- The collection of foreign key columns for this table.
triggers
Collection<E> triggers
- The collection of triggers for this table.
columns
Collection<E> columns
- The collection of columns that belong to this table.
numberOfRows
int numberOfRows
- The total number of records in the object.
- Since:
- Version 1.3
table
String table
- The table on which the trigger operates.
tableCatalogue
String tableCatalogue
- The catalogue to which the table on which the tigger operates belongs.
This may be different from the catalogue in which the trigger exists.
tableSchema
String tableSchema
- The schema to which the table on which the tigger operates belongs.
This may be different from the schema in which the trigger exists.
event
TriggerMetaData.Event event
- The event that fires the trigger.
statement
String statement
- The statement that is executed by the trigger.
orientation
TriggerMetaData.Orientation orientation
- Identifies whether the trigger fires once for each processed row or
once for each statement.
timing
TriggerMetaData.Timing timing
- The time the trigger fires.
root
RootMetaData root
- A reference to the catalogue/schema in which this trigger exists.
tableMetaData
TableMetaData tableMetaData
- A reference to the table on which this trigger executes. This will
be populated only if the
TriggerMetaData.table on which the trigger executes
belongs to the same schema.
definition
String definition
- The query expression defining the view (null if the view is not owned
by a currently enabled role)
checkOption
String checkOption
- The
check_option column in the
information_schema.views view.
updatable
boolean updatable
- A flag used to indicate whether the view supports
UPDATE
and DELETE statements.
insertable
boolean insertable
- A flag used to indicate whether the view supports
INSERT
statements.
|
Package com.sptci.rwt.webui |
tabbedPane
TabbedPane tabbedPane
- The tabbed pane used to display the results of query execution.
statement
String statement
- The SQL statement that is to be displayed in
ExecutorView.query when it
is initialised.
controller
MainController controller
- The main controller for the application.
column
Column column
- The container used to display all the components.
databaseType
SelectField databaseType
- The component used to display configured database engines.
host
TextField host
- The component used to specify the hostname of the database server.
port
consultas.echo2consultas.LiveTextField port
- The port on wich the database listens for connections.
database
TextField database
- The name of the database to connect to.
userName
TextField userName
- The component used to enter the user name to login as.
password
PasswordField password
- The component used to enter the password to logon with.
databaseType
String databaseType
- The database type under which the connection is saved.
name
String name
- The name of the saved connection.
category
String category
- The category under which the query is saved.
name
String name
- The name of the saved query.
query
TextArea query
- The component used to enter the SQL statement to execute.
maxResults
consultas.echo2consultas.LiveTextField maxResults
- The component used to specify the maximum number of rows of data
to retrieve for
select statements.
maxColumnLength
consultas.echo2consultas.LiveTextField maxColumnLength
- The component used to specify the maximum number of characters to
display in a table column.
- Since:
- Version 1.3
results
Column results
- The component used to display the results after executing a statement.
controller
MainController controller
- Parent Controller.
connectionManager
ConnectionManager connectionManager
- The connection manager to use to interact with the database.
history
Map<K,V> history
- The cache of previously executed statements in this view.
view
ExecutorView view
- The executor view to which this component is bound.
controller
MainController controller
- Parent Controller.
connections
Connections connections
- The object that represents saved connections.
queries
Queries queries
- The object that represents saved queries.
controller
MainController controller
- The controller for this view component.
menuComponent
MenuComponent menuComponent
- The component used to display the menu for the application.
tree
MetaDataTree tree
- The component used to display the database object hierarchy.
left
Component left
- container used to hold the metadata objects (tree).
right
Component right
- The container used to hold all the information displayed in the
detail view area (right side).
controller
MainController controller
- The controller used to interact with the application.
controller
MainController controller
- The controller used to interact with the application.
controller
MainController controller
- The main application controller to use for this component.
savedConnections
Menu savedConnections
- The menu used to store saved JDBC connections.
savedQueries
Menu savedQueries
- The menu used to store saved SQL statements.
controller
MainController controller
- The controller for interacting with the application.
rows
List<E> rows
- The list used as the backing store for this model.
- Since:
- Version 1.2
query
String query
- The SQL statement that is to be executed to fetch the results.
maxRows
int maxRows
- The maximum number of records to fetch from the database.
maxColumnLength
int maxColumnLength
- The maximum number of characters to display in a column.
- Since:
- Version 1.3
manager
ConnectionManager manager
- The connection manager to use to fetch database connections.
name
TextField name
- The component used to enter the name for the connection.
controller
MainController controller
- The controller to use to interact with the rest of the application.
databaseType
DatabaseType databaseType
- The type of database to connect to.
name
String name
- The name of the saved connection.
statement
String statement
- The query that is to be executed.
category
ComboBox category
- The component used to display available categories.
name
TextField name
- The component used to enter the name for the query.
controller
MainController controller
- The controller to use to interact with the rest of the application.
orderBy
String orderBy
- The name of the column to use in a SQL order by clause.
|
Package com.sptci.rwt.webui.model |
metaData
CatalogueMetaData metaData
- The meta data object whose details are to be displayed.
metaData
ColumnMetaData metaData
- The meta data object whose details are to be displayed.
metaData
DBMSMetaData metaData
- The meta data object whose details are to be displayed.
metaData
ForeignKeyMetaData metaData
- The meta data object whose details are to be displayed.
metaData
IndexMetaData metaData
- The meta data object whose details are to be displayed.
metaData
JDBCMetaData metaData
- The meta data object whose details are to be displayed.
metaData
LimitsMetaData metaData
- The meta data object whose details are to be displayed.
metaData
PrimaryKeyMetaData metaData
- The meta data object whose details are to be displayed.
metaData
ProcedureMetaData metaData
- The meta data object whose details are to be displayed.
metaData
SchemaMetaData metaData
- The meta data object whose details are to be displayed.
metaData
SequenceMetaData metaData
- The meta data object whose details are to be displayed.
metaData
TableTypeMetaData metaData
- The metadata object for the table whose data is to be displayed.
metaData
TableTypeMetaData metaData
- The meta data object whose data is being displayed.
model
SortableRowTableModel model
- The
TableModel used to build the
Table in which the data is displayed.
metaData
TableMetaData metaData
- The meta data object whose details are to be displayed.
metaData
TriggerMetaData metaData
- The meta data object whose details are to be displayed.
metaData
ViewMetaData metaData
- The meta data object whose details are to be displayed.
|
Package com.sptci.rwt.webui.style |
|
Package com.sptci.rwt.webui.tree |
metadata
MetaData metadata
- The
MetaData object associated with this node.