|
Method
|
Description
|
Returns
|
|
allProceduresAreCallable()
|
Can all the procedures returned by getProcedures be called by the current user?
|
False
|
|
allTablesAreSelectable()
|
Can all the tables returned by getTable be SELECTed by the current user?
|
False
|
|
dataDefinitionCausesTransactionCommit()
|
Does a data definition statement within a transaction force the transaction to commit?
|
True
|
|
dataDefinitionIgnoredInTransactions()
|
Is a data definition statement within a transaction ignored?
|
False
|
|
doesMaxRowSizeIncludeBlobs()
|
Did getMaxRowSize( ) include LONGVARCHAR and LONGVARBINARY BLOBs?
|
False
|
|
getBestRowIdentifier (String, String, String, int, boolean)
|
Gets a description of a table's optimal set of columns that uniquely identifies a row.
|
(Result set)
|
|
getCatalogs()
|
Gets the catalog names available in this database.
|
(Result set)
|
|
getCatalogSeparator()
|
What is the separator between catalog and table names?
|
NoneNo catalogs
|
|
getCatalogTerm()
|
What is the database vendor's preferred term for catalog?
|
NoneNo catalogs
|
|
getColumnPrivileges (String, String, String, String)
|
Gets a description of the access rights for a table's columns.
|
(Result set)
|
|
getColumns(String, String, String, String)
|
Gets a description of table columns available in a catalog.
|
(Result set)
|
|
getCrossReference(String, String, String, String, String, String)
|
Gets a description of the foreign key columns in the foreign key table that reference the primary key columns of the primary key table (describes how one table imports another's key). This should normally return a single foreign key/primary key pair (most tables only import a foreign key from a table once). They are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ.
|
(Result set)
|
|
getDatabaseProductName()
|
What is the name of this database product?
|
OPENEDGE
|
|
getDatabaseProductVersion()
|
What is the version of this database product?
|
10.0A1B
|
|
getDefaultTransactionIsolation()
|
What is the database's default transaction isolation level? The values are defined in java.sql.Connection.
|
TRANSACTION_READ_COMMITTED
|
|
getDriverMajorVersion()
|
What is the version of this JDBC driver?
|
1
|
|
getDriverMinorVersion()
|
What is the minor version of this JDBC driver?
|
1000
|
|
getDriverName()
|
What is the name of this JDBC driver?
|
OpenEdge
|
|
getDriverVersion()
|
What is the version of this JDBC driver?
|
4.0.00 5805 (040318.014802)
|
|
getExportedKeys(String, String, String)
|
Gets a description of the foreign key columns that reference a table's primary key columns (the foreign keys exported by a table).
|
(Result set)
|
|
getExtraNameCharacters()
|
Gets all the extra characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _).
|
"_", "%"
|
|
getIdentifierQuoteString ()
|
What is the string used to quote SQL identifiers? This returns a space " " if identifier quoting is not supported.
|
" "
|
|
getImportedKeys(String, String, String)
|
Gets a description of the primary key columns that reference a table's foreign key columns (the primary keys imported by a table).
|
(Result set)
|
|
getIndexInfo (String, String, String, boolean, boolean)
|
Gets a description of a table's indices and statistics.
|
(Result set)
|
|
getMaxBinaryLiteralLength()
|
How many hex characters can you have in an inline binary literal?
|
31983
|
|
getMaxCatalogNameLength()
|
What is the maximum length of a catalog name?
|
NoneNo catalogs
|
|
getMaxCharLiteralLength()
|
What is the maximum length for a character literal?
|
31983
|
|
getMaxColumnNameLength()
|
What is the limit on column name length?
|
32
|
|
getMaxColumnsInGroupBy()
|
What is the maximum number of columns in a GROUP BY clause?
|
499
|
|
getMaxColumnsInIndex()
|
What is the maximum number of columns allowed in an index?
|
16
|
|
getMaxColumnsInOrderBy()
|
What is the maximum number of columns in an ORDER BY clause?
|
0
|
|
getMaxColumnsInSelect()
|
What is the maximum number of columns in a SELECT list?
|
500
|
|
getMaxColumnsInTable()
|
What is the maximum number of columns in a table?
|
500
|
|
getMaxConnections()
|
How many active connections can we have at a time to this database?
|
0
|
|
getMaxCursorNameLength()
|
What is the maximum cursor name length?
|
18
|
|
getMaxIndexLength()
|
What is the maximum length of an index (in bytes)?
|
113
|
|
getMaxProcedureNameLength()
|
What is the maximum length of a procedure name?
|
32
|
|
getMaxRowSize()
|
What is the maximum length of a single row?
|
31,995 bytes
|
|
getMaxSchemaNameLength()
|
What is the maximum length allowed for a schema name?
|
32
|
|
getMaxStatementLength()
|
What is the maximum length of an SQL statement?
|
131,000
|
|
getMaxStatements()
|
How many active statements can we have open at one time to this database?
|
100
|
|
getMaxTableNameLength()
|
What is the maximum length of a table name?
|
32
|
|
getMaxTablesInSelect()
|
What is the maximum number of tables in a SELECT?
|
250
|
|
getMaxUserNameLength()
|
What is the maximum length of a user name?
|
32
|
|
getNumericFunctions()
|
Gets a comma‑separated list of math functions.
|
ABS, ACOS, ASIN, ATAN, ATAN2, CEILING, COS, DEGREES, EXP, FLOOR, LOG10, MOD, PI, POWER, RADIANS, RAND, ROUND, SIGN,SIN, SQRT, TAN
|
|
getPrimaryKeys(String, String, String)
|
Gets a description of a table's primary key columns.
|
(Result set)
|
|
getProcedureColumns (String, String, String, String)
|
Get a description of a catalog's stored procedure parameters and result columns.
|
(Result set)
|
|
getProcedures(String, String, String)
|
Gets a description of stored procedures available in a catalog.
|
(Result set)
|
|
getProcedureTerm()
|
What is the database vendor's preferred term for procedure?
|
procedure
|
|
getSchemas()
|
Gets the schema names available in this database.
|
(Result set)
|
|
getSchemaTerm()
|
What is the database vendor's preferred term for schema?
|
Owner
|
|
getSearchStringEscape()
|
This is the string that can be used to escape ‘_' or ‘%' in the string pattern style catalog search parameters.
|
\
|
|
getSQLKeywords()
|
Gets a comma‑separated list of all a database's SQL keywords that are NOT also SQL keywords.
|
See OpenEdgeSQL Reserved Words for a complete list of reserved words.
|
|
getStringFunctions()
|
Gets a comma‑separated list of string functions.
|
ASCII, CHAR, CONCAT, DIFFERENCE, INSERT, LCASE, LEFT, LENGTH, LOCATE, LOCATE-2, LTRIM, REPEAT, REPLACE, RIGHT, RTRIM, SPACE, SUBSTRING, UCASE
|
|
getSystemFunctions()
|
Gets a comma‑separated list of system functions.
|
USERNAME, IFNULL, DBNAME
|
|
getTablePrivileges(String, String, String)
|
Gets a description of the access rights for each table available in a catalog.
|
(Result set)
|
|
getTables(String, String, String, String [])
|
Gets a description of tables available in a catalog.
|
(Result set)
|
|
getTableTypes()
|
Gets the table types available in this database.
|
(Result set)
|
|
getTimeDateFunctions()
|
Gets a comma‑separated list of time and date functions.
|
CURDATE, CURTIME, DAYNAME, DAYOFMONTH, DAYOFWEEK, DAYOFYEAR, MONTH, QUARTER, WEEK, YEAR, HOUR, MINUTE, SECOND, MONTHNAME, NOW, TIMESTAMPADD, TIMESTAMPDIFF
|
|
getTypeInfo()
|
Gets a description of all the standard SQL types supported by this database.
|
(Result set)
|
|
getURL()
|
What is the URL for this database?
|
(The URL)
|
|
getUserName()
|
What is our user name as known to the database?
|
(User name)
|
|
getVersionColumns(String, String, String)
|
Gets a description of a table's columns that are automatically updated when any value in a row is updated.
|
(Result set)
|
|
isCatalogAtStart()
|
Does a catalog appear at the start of a qualified table name? Otherwise it appears at the end.
|
False
|
|
isReadOnly()
|
Is the database in read‑only mode?
|
False
|
|
nullPlusNonNullIsNull()
|
Are concatenations between NULL and non‑NULL values NULL? A JDBC‑compliant driver always returns true.
|
True
|
|
nullsAreSortedAtEnd()
|
Are NULL values sorted at the end regardless of sort order?
|
False
|
|
nullsAreSortedAtStart()
|
Are NULL values sorted at the start regardless of sort order?
|
False
|
|
nullsAreSortedHigh()
|
Are NULL values sorted high?
|
True
|
|
nullsAreSortedLow()
|
Are NULL values sorted low?
|
False
|
|
storesLowerCaseIdentifiers()
|
Does the database treat mixed-case, unquoted SQL identifiers as case insensitive and store them in lowercase?
|
False
|
|
storesLowerCaseQuotedIdentifiers()
|
Does the database treat mixed-case, quoted SQL identifiers as case insensitive and store them in lowercase?
|
False
|
|
storesMixedCaseIdentifiers()
|
Does the database treat mixed-case, unquoted SQL identifiers as case insensitive and store them in mixed case?
|
False
|
|
storesMixedCaseQuotedIdentifiers()
|
Does the database treat mixed-case, quoted SQL identifiers as case insensitive and store them in mixed case?
|
True
|
|
storesUpperCaseIdentifiers()
|
Does the database treat mixed-case, unquoted SQL identifiers as case insensitive and store them in uppercase?
|
True
|
|
storesUpperCaseQuotedIdentifiers()
|
Does the database treat mixed-case, quoted SQL identifiers as case insensitive and store them in uppercase?
|
False
|
|
supportsAlterTableWithAddColumn()
|
Is ALTER TABLE with add column supported?
|
False
|
|
supportsAlterTableWithDropColumn()
|
Is ALTER TABLE with drop column supported?
|
False
|
|
supportsANSI92EntryLevelSQL()
|
Is the ANSI92 entry level SQL grammar supported? All JDBC‑compliant drivers must return true.
|
True
|
|
supportsANSI92FullSQL()
|
Is the ANSI92 full SQL grammar supported?
|
False
|
|
supportsANSI92IntermediateSQL()
|
Is the ANSI92 intermediate SQL grammar supported?
|
False
|
|
supportsCatalogsInDataManipulation()
|
Can a catalog name be used in a data manipulation statement?
|
False
|
|
supportsCatalogsInIndexDefinitions()
|
Can a catalog name be used in an index definition statement?
|
False
|
|
supportsCatalogsInPrivilegeDefinitions()
|
Can a catalog name be used in a privilege definition statement?
|
False
|
|
supportsCatalogsInProcedureCalls()
|
Can a catalog name be used in a procedure call statement?
|
False
|
|
supportsCatalogsInTableDefinitions()
|
Can a catalog name be used in a table definition statement?
|
False
|
|
supportsColumnAliasing()
|
Is column aliasing supported? If so, the SQL AS clause can be used to provide names for computed columns or to provide alias names for columns as required.
|
True
|
|
supportsConvert()
|
Is the CONVERT function between SQL types supported?
|
True
|
|
supportsConvert(int, int)
|
Is CONVERT between the given SQL types supported?
|
True
|
|
supportsCoreSQLGrammar()
|
Is the ODBC Core SQL grammar supported?
|
True
|
|
supportsCorrelatedSubqueries()
|
Are correlated subqueries supported? A JDBC‑compliant driver always returns true.
|
True
|
|
supportsDataDefinitionAndData ManipulationTransactions ()
|
Are both data definition and data manipulation statements within a transaction supported?
|
True
|
|
supportsDataManipulationTransactions Only()
|
Are only data manipulation statements within a transaction supported?
|
False
|
|
supportsDifferentTableCorrelationNames()
|
If table correlation names are supported, are they restricted to be different from the names of the tables?
|
True
|
|
supportsExpressionsInOrderBy()
|
Are expressions in ORDER BY lists supported?
|
True
|
|
supportsExtendedSQLGrammar()
|
Is the ODBC Extended SQL grammar supported?
|
True
|
|
supportsFullOuterJoins()
|
Are full nested outer joins supported?
|
False
|
|
supportsGroupBy()
|
Is some form of GROUP BY clause supported?
|
True
|
|
supportsGroupByBeyondSelect()
|
Can a GROUP BY clause add columns not in the SELECT provided it specifies all the columns in the SELECT?
|
True
|
|
supportsGroupByUnrelated()
|
Can a GROUP BY clause use columns not in the SELECT?
|
False
|
|
supportsIntegrityEnhancementFacility()
|
Is the SQL Integrity Enhancement Facility supported?
|
True
|
|
supportsLikeEscapeClause()
|
Is the escape character in LIKE clauses supported? A JDBC‑compliant driver always returns true.
|
True
|
|
supportsLimitedOuterJoins()
|
Is there limited support for outer joins? (This will be true if supportFullOuterJoins is true.)
|
False
|
|
supportsMinimumSQLGrammar()
|
Is the ODBC Minimum SQL grammar supported? All JDBC‑compliant drivers must return true.
|
True
|
|
supportsMixedCaseIdentifiers()
|
Does the database treat mixed-case, unquoted SQL identifiers as case sensitive and as a result store them in mixed case? A JDBC‑compliant driver will always return false.
|
False
|
|
supportsMixedCaseQuotedIdentifiers()
|
Does the database treat mixed-case, quoted SQL identifiers as case sensitive and as a result store them in mixed case? A JDBC‑compliant driver will always return true.
|
True
|
|
supportsMultipleResultSets()
|
Are multiple ResultSets from a single execute supported?
|
False
|
|
supportsMultipleTransactions()
|
Can multiple transactions be open at once (on different connections)?
|
True
|
|
supportsNonNullableColumns()
|
Can columns be defined as non‑nullable? A JDBC‑compliant driver always returns true.
|
True
|
|
supportsOpenCursorsAcrossCommit()
|
Can cursors remain open across commits?
|
True
|
|
supportsOpenCursorsAcrossRollback()
|
Can cursors remain open across rollbacks?
|
True
|
|
supportsOpenStatementsAcrossCommit()
|
Can statements remain open across commits?
|
True
|
|
supportsOpenStatementsAcrossRollback()
|
Can statements remain open across rollbacks?
|
True
|
|
supportsOrderByUnrelated()
|
Can an ORDER BY clause use columns not in the SELECT?
|
False
|
|
supportsOuterJoins()
|
Is some form of outer join supported?
|
True
|
|
supportsPositionedDelete()
|
Is positioned DELETE supported?
|
True
|
|
supportsPositionedUpdate()
|
Is positioned UPDATE supported?
|
True
|
|
supportsResultSetType
|
Retrieves whether this database supports the given result set type. The type may be one of the following:
 TYPE_SCROLL_SENSITIVE
TYPE_SCROLL_INSENSITIVE
TYPE_FORWARD_ONLY
|
True
|
|
supportsSchemasInDataManipulation()
|
Can a schema name be used in a data manipulation statement?
|
True
|
|
supportsSchemasInIndexDefinitions()
|
Can a schema name be used in an index definition statement?
|
True
|
|
supportsSchemasInPrivilegeDefinitions()
|
Can a schema name be used in a privilege definition statement?
|
True
|
|
supportsSchemasInProcedureCalls()
|
Can a schema name be used in a procedure call statement?
|
True
|
|
supportsSchemasInTableDefinitions()
|
Can a schema name be used in a table definition statement?
|
True
|
|
supportsSelectForUpdate()
|
Is SELECT for UPDATE supported?
|
True
|
|
supportsStoredProcedures()
|
Are stored procedure calls using the stored procedure escape syntax supported?
|
True
|
|
supportsSubqueriesInComparisons()
|
Are subqueries in comparison expressions supported? A JDBC‑compliant driver always returns true.
|
True
|
|
supportsSubqueriesInExists()
|
Are subqueries in EXISTS expressions supported? A JDBC‑compliant driver always returns true.
|
True
|
|
supportsSubqueriesInIns()
|
Are subqueries in IN statements supported? A JDBC‑compliant driver always returns true.
|
True
|
|
supportsSubqueriesInQuantifieds()
|
Are subqueries in quantified expressions supported? A JDBC‑compliant driver always returns true.
|
True
|
|
supportsTableCorrelationNames()
|
Are table correlation names supported? A JDBC‑compliant driver always returns true.
|
True
|
|
supportsTransactionIsolationLevel(int)
|
Does the database support the given transaction isolation level?
|
True (for all four transaction levels)
|
|
supportsTransactions ()
|
Are transactions supported? If not, commit is a no‑op and the isolation level is TRANSACTION_NONE.
|
True
|
|
supportsUnion()
|
Is SQL UNION supported?
|
True
|
|
supportsUnionAll()
|
Is SQL UNION ALL supported?
|
True
|
|
usesLocalFilePerTable()
|
Does the database use a file for each table?
|
False
|
|
usesLocalFiles()
|
Does the database store tables in a local file?
|
False
|
|
Connection con = DriverManager.getConnection ( url, prop);
. . . // Get the DatabaseMetaData object and display // some information about the connection DatabaseMetaData dma = con.getMetaData (); o.println("\nConnected to " + dma.getURL()); o.println("Driver " + dma.getDriverName()); o.println("Version " + dma.getDriverVersion()); |