Xojo Developer Conference
25/27th April 2018 in Denver.
MBS Xojo Conference
6/7th September 2018 in Munich, Germany.

Platforms to show: All Mac Windows Linux Cross-Platform

Next items

JavaDatabaseMetaDataMBS.allProceduresAreCallable as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves whether the current user can call all the procedures returned by the method getProcedures.
Notes: Returns true if so; false otherwise

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.allTablesAreSelectable as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves whether the current user can use all the tables returned by the method getTables in a SELECT statement.
Notes: Returns true if so; false otherwise

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.attributeNoNulls as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Indicates that NULL values might not be allowed.
Notes: A possible value for the column NULLABLE in the ResultSet object returned by the method getAttributes.

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.attributeNullable as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Indicates that NULL values are definitely allowed.
Notes: A possible value for the column NULLABLE in the ResultSet object returned by the method getAttributes.

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.attributeNullableUnknown as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Indicates that whether NULL values are allowed is not known.
Notes: A possible value for the column NULLABLE in the ResultSet object returned by the method getAttributes.

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.bestRowNotPseudo as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Indicates that the best row identifier is NOT a pseudo column.
Notes: A possible value for the column PSEUDO_COLUMN in the ResultSet object returned by the method getBestRowIdentifier.

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.bestRowPseudo as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Indicates that the best row identifier is a pseudo column.
Notes: A possible value for the column PSEUDO_COLUMN in the ResultSet object returned by the method getBestRowIdentifier.

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.bestRowSession as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Indicates that the scope of the best row identifier is the remainder of the current session.
Notes: A possible value for the column SCOPE in the ResultSet object returned by the method getBestRowIdentifier.

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.bestRowTemporary as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Indicates that the scope of the best row identifier is very temporary, lasting only while the row is being used.
Notes: A possible value for the column SCOPE in the ResultSet object returned by the method getBestRowIdentifier.

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.bestRowTransaction as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Indicates that the scope of the best row identifier is the remainder of the current transaction.
Notes: A possible value for the column SCOPE in the ResultSet object returned by the method getBestRowIdentifier.

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.bestRowUnknown as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Indicates that the best row identifier may or may not be a pseudo column.
Notes: A possible value for the column PSEUDO_COLUMN in the ResultSet object returned by the method getBestRowIdentifier.

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.columnNoNulls as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Indicates that the column might not allow NULL values.
Notes: A possible value for the column NULLABLE in the ResultSet returned by the method getColumns.

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.columnNullable as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Indicates that the column definitely allows NULL values.
Notes: A possible value for the column NULLABLE in the ResultSet returned by the method getColumns.

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.columnNullableUnknown as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Indicates that the nullability of columns is unknown.
Notes: A possible value for the column NULLABLE in the ResultSet returned by the method getColumns.

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.Constructor
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 15.1 Yes Yes Yes Yes No
Function: The private constructor.

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.dataDefinitionCausesTransactionCommit as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves whether a data definition statement within a transaction forces the transaction to commit.

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.dataDefinitionIgnoredInTransactions as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves whether this database ignores a data definition statement within a transaction.

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.deletesAreDetected(type as Integer) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves whether or not a visible row delete can be detected by calling the method ResultSet.rowDeleted.
Notes:
If the method deletesAreDetected returns false, it means that deleted rows are removed from the result set.

Parameters:
type - the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE

Returns:
true if deletes are detected by the given result set type; false otherwise

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.doesMaxRowSizeIncludeBlobs as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves whether the return value for the method getMaxRowSize includes the SQL data types LONGVARCHAR and LONGVARBINARY.
Notes: Returns true if so; false otherwise.

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.getAttributes(catalog as string, schemaPattern as string, typeNamePattern as string, attributeNamePattern as string) as JavaResultSetMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 9.1 Yes Yes Yes Yes No
Function: Retrieves a description of the given attribute of the given type for a user-defined type (UDT) that is available in the given schema and catalog.
Notes:
Descriptions are returned only for attributes of UDTs matching the catalog, schema, type, and attribute name criteria. They are ordered by TYPE_SCHEM, TYPE_NAME and ORDINAL_POSITION. This description does not contain inherited attributes.

The ResultSet object that is returned has the following columns:

TYPE_CAT String => type catalog (may be null)
TYPE_SCHEM String => type schema (may be null)
TYPE_NAME String => type name
ATTR_NAME String => attribute name
DATA_TYPE int => attribute type SQL type from java.sql.Types
ATTR_TYPE_NAME String => Data source dependent type name. For a UDT, the type name is fully qualified. For a REF, the type name is fully qualified and represents the target type of the reference type.
ATTR_SIZE int => column size. For char or date types this is the maximum number of characters; for numeric or decimal types this is precision.
DECIMAL_DIGITS int => the number of fractional digits
NUM_PREC_RADIX int => Radix (typically either 10 or 2)
NULLABLE int => whether NULL is allowed
attributeNoNulls - might not allow NULL values
attributeNullable - definitely allows NULL values
attributeNullableUnknown - nullability unknown
REMARKS String => comment describing column (may be null)
ATTR_DEF String => default value (may be null)
SQL_DATA_TYPE int => unused
SQL_DATETIME_SUB int => unused
CHAR_OCTET_LENGTH int => for char types the maximum number of bytes in the column
ORDINAL_POSITION int=> index of column in table (starting at 1)
IS_NULLABLE String => "false" means column definitely does not allow NULL values; "true" means the column might allow NULL values. An empty string means unknown.
SCOPE_CATALOG String => catalog of table that is the scope of a reference attribute (null if DATA_TYPE isn't REF)
SCOPE_SCHEMA String => schema of table that is the scope of a reference attribute (null if DATA_TYPE isn't REF)
SCOPE_TABLE String => table name that is the scope of a reference attribute (null if the DATA_TYPE isn't REF)
SOURCE_DATA_TYPE short => source type of a distinct type or user-generated Ref type,SQL type from java.sql.Types (null if DATA_TYPE isn't DISTINCT or user-generated REF)
Parameters:
catalog - a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search
schemaPattern - a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search
typeNamePattern - a type name pattern; must match the type name as it is stored in the database
attributeNamePattern - an attribute name pattern; must match the attribute name as it is declared in the database

Returns:
a ResultSet object in which each row is an attribute description

Throws:
SQLException - if a database access error occurs

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.getCatalogs as JavaResultSetMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 9.1 Yes Yes Yes Yes No
Function: Retrieves the catalog names available in this database. The results are ordered by catalog name.
Notes:
The catalog column is:

TABLE_CAT String => catalog name

Returns:
a ResultSet object in which each row has a single String column that is a catalog name

Throws:
SQLException - if a database access error occurs

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.getCatalogSeparator as string
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the String that this database uses as the separator between a catalog and table name.

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.getCatalogTerm as string
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the database vendor's preferred term for "catalog".

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.getColumnPrivileges(catalog as string, schema as string, table as string, columnNamePattern as string) as JavaResultSetMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 9.1 Yes Yes Yes Yes No
Function: Retrieves a description of the access rights for a table's columns.
Notes:
Only privileges matching the column name criteria are returned. They are ordered by COLUMN_NAME and PRIVILEGE.

Each privilige description has the following columns:

TABLE_CAT String => table catalog (may be null)
TABLE_SCHEM String => table schema (may be null)
TABLE_NAME String => table name
COLUMN_NAME String => column name
GRANTOR => grantor of access (may be null)
GRANTEE String => grantee of access
PRIVILEGE String => name of access (SELECT, INSERT, UPDATE, REFRENCES, ...)
IS_GRANTABLE String => "true" if grantee is permitted to grant to others; "false" if not; null if unknown
Parameters:
catalog - a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search
schema - a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search
table - a table name; must match the table name as it is stored in the database
columnNamePattern - a column name pattern; must match the column name as it is stored in the database

Returns:
ResultSet - each row is a column privilege description

Throws:
SQLException - if a database access error occurs

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.getColumns(catalog as string, schemaPattern as string, tableNamePattern as string, columnNamePattern as string) as JavaResultSetMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 9.1 Yes Yes Yes Yes No
Function: Retrieves a description of table columns available in the specified catalog.
Notes:
Only column descriptions matching the catalog, schema, table and column name criteria are returned. They are ordered by TABLE_SCHEM, TABLE_NAME, and ORDINAL_POSITION.

Each column description has the following columns:

TABLE_CAT String => table catalog (may be null)
TABLE_SCHEM String => table schema (may be null)
TABLE_NAME String => table name
COLUMN_NAME String => column name
DATA_TYPE int => SQL type from java.sql.Types
TYPE_NAME String => Data source dependent type name, for a UDT the type name is fully qualified
COLUMN_SIZE int => column size. For char or date types this is the maximum number of characters, for numeric or decimal types this is precision.
BUFFER_LENGTH is not used.
DECIMAL_DIGITS int => the number of fractional digits
NUM_PREC_RADIX int => Radix (typically either 10 or 2)
NULLABLE int => is NULL allowed.
columnNoNulls - might not allow NULL values
columnNullable - definitely allows NULL values
columnNullableUnknown - nullability unknown
REMARKS String => comment describing column (may be null)
COLUMN_DEF String => default value (may be null)
SQL_DATA_TYPE int => unused
SQL_DATETIME_SUB int => unused
CHAR_OCTET_LENGTH int => for char types the maximum number of bytes in the column
ORDINAL_POSITION int=> index of column in table (starting at 1)
IS_NULLABLE String => "false" means column definitely does not allow NULL values; "true" means the column might allow NULL values. An empty string means nobody knows.
SCOPE_CATLOG String => catalog of table that is the scope of a reference attribute (null if DATA_TYPE isn't REF)
SCOPE_SCHEMA String => schema of table that is the scope of a reference attribute (null if the DATA_TYPE isn't REF)
SCOPE_TABLE String => table name that this the scope of a reference attribure (null if the DATA_TYPE isn't REF)
SOURCE_DATA_TYPE short => source type of a distinct type or user-generated Ref type, SQL type from java.sql.Types (null if DATA_TYPE isn't DISTINCT or user-generated REF)
Parameters:
catalog - a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search
schemaPattern - a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search
tableNamePattern - a table name pattern; must match the table name as it is stored in the database
columnNamePattern - a column name pattern; must match the column name as it is stored in the database

Returns:
ResultSet - each row is a column description

Throws:
SQLException - if a database access error occurs

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.getConnection as JavaConnectionMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 9.1 Yes Yes Yes Yes No
Function: Retrieves the connection that produced this metadata object.

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.getCrossReference(primaryCatalog as string, primarySchema as string, primaryTable as string, foreignCatalog as string, foreignSchema as string, foreignTable as string) as JavaResultSetMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 9.1 Yes Yes Yes Yes No
Function: Retrieves a description of the foreign key columns in the given foreign key table that reference the primary key columns of the given primary key table (describe how one table imports another's key).
Notes:
This should normally return a single foreign key/primary key pair because most tables import a foreign key from a table only once. They are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ.
Each foreign key column description has the following columns:

PKTABLE_CAT String => primary key table catalog (may be null)
PKTABLE_SCHEM String => primary key table schema (may be null)
PKTABLE_NAME String => primary key table name
PKCOLUMN_NAME String => primary key column name
FKTABLE_CAT String => foreign key table catalog (may be null) being exported (may be null)
FKTABLE_SCHEM String => foreign key table schema (may be null) being exported (may be null)
FKTABLE_NAME String => foreign key table name being exported
FKCOLUMN_NAME String => foreign key column name being exported
KEY_SEQ short => sequence number within foreign key
UPDATE_RULE short => What happens to foreign key when primary is updated:
importedNoAction - do not allow update of primary key if it has been imported
importedKeyCascade - change imported key to agree with primary key update
importedKeySetNull - change imported key to NULL if its primary key has been updated
importedKeySetDefault - change imported key to default values if its primary key has been updated
importedKeyRestrict - same as importedKeyNoAction (for ODBC 2.x compatibility)
DELETE_RULE short => What happens to the foreign key when primary is deleted.
importedKeyNoAction - do not allow delete of primary key if it has been imported
importedKeyCascade - delete rows that import a deleted key
importedKeySetNull - change imported key to NULL if its primary key has been deleted
importedKeyRestrict - same as importedKeyNoAction (for ODBC 2.x compatibility)
importedKeySetDefault - change imported key to default if its primary key has been deleted
FK_NAME String => foreign key name (may be null)
PK_NAME String => primary key name (may be null)
DEFERRABILITY short => can the evaluation of foreign key constraints be deferred until commit
importedKeyInitiallyDeferred - see SQL92 for definition
importedKeyInitiallyImmediate - see SQL92 for definition
importedKeyNotDeferrable - see SQL92 for definition
Parameters:
primaryCatalog - a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means drop catalog name from the selection criteria
primarySchema - a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means drop schema name from the selection criteria
primaryTable - the name of the table that exports the key; must match the table name as it is stored in the database
foreignCatalog - a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means drop catalog name from the selection criteria
foreignSchema - a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means drop schema name from the selection criteria
foreignTable - the name of the table that imports the key; must match the table name as it is stored in the database
Returns:
ResultSet - each row is a foreign key column description
Throws:
SQLException - if a database access error occurs

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.getDatabaseMajorVersion as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the major version number of the underlying database.

Feedback, Comments & Corrections

JavaDatabaseMetaDataMBS.getDatabaseMinorVersion as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the minor version number of the underlying database.

Feedback, Comments & Corrections

Next items

The items on this page are in the following plugins: MBS Java Plugin.




Links
MBS Xojo Plugins