DBMDWrapper (Apache Derby V10.10 Internals)

java.lang.Object
- org.apache.derby.impl.tools.optional.DBMDWrapper

All Implemented Interfaces:: OptionalTool

public class DBMDWrapper
extends java.lang.Object
implements OptionalTool

OptionalTool to create wrapper functions which allow you to invoke DatabaseMetaData methods via SQL. The wrapper functions slightly change the signature of the metadata methods as follows:

Arguments of type int[] and String[] have been eliminated--they are automatically wildcarded.
The method getRowIdLifetime() has been commented out--Derby does not support object types.
The method getSchemas() has been commented out--it can be uncommented when the registration logic is made smarter to handle the dropping of different overloads.
The method supportsConvert() has been commented out because Derby only allows one function by a given name and the supportsConvert( int, int ) overload is more general.

Methods which return ResultSet are mapped to table functions. You can join the metadata table functions like this:

 -- list all of the columns in the connected Derby database
 select t.table_schem, t.table_name, c.column_name, c.type_name
 from table( getTables( null, null, null ) ) t,
         table( getColumns( null, null, null, null ) ) c
 where c.table_schem = t.table_schem
 and c.table_name = t.table_name
 and t.table_type = 'TABLE'
 ;
 
 
 -- now list metadata in a foreign database
 call setDatabaseURL( 'com.mysql.jdbc.Driver', 'jdbc:mysql://localhost/world?user=root&password=' );
 
 select t.table_schem, t.table_name, c.column_name, c.type_name
 from table( getTables( 'WORLD', null, null ) ) t,
         table( getColumns( 'WORLD', null, null, null) ) c
 where c.table_name = t.table_name
 and t.table_type = 'TABLE'
 ;
 
 -- release the foreign connection
 call setDatabaseURL( '', '' );

Field Summary

Fields
Modifier and Type Field and Description

private static int DEFAULT_PRECISION

Fields
Modifier and Type	Field and Description
`private static int`	`DEFAULT_PRECISION`

Constructor Summary

Constructors
Constructor and Description

DBMDWrapper()
0-arg constructor to satisfy the OptionalTool contract

Constructors
Constructor and Description
`DBMDWrapper()` 0-arg constructor to satisfy the OptionalTool contract

Method Summary

Methods
Modifier and Type	Method and Description
`static boolean`	`allProceduresAreCallable()`
`static boolean`	`allTablesAreSelectable()`
`private void`	`appendArgs(java.lang.StringBuffer buffer, java.lang.reflect.Method method)` Append function arguments to an evolving ddl text buffer.
`private void`	`appendReturnType(java.lang.StringBuffer buffer, java.sql.Connection conn, java.lang.reflect.Method method)` Append return type to an evolving ddl text buffer
`private void`	`appendTableFunctionSignature(java.lang.StringBuffer buffer, java.sql.Connection conn, java.lang.reflect.Method method)` Append the signature of a table function to an evolving ddl text buffer
`static boolean`	`autoCommitFailureClosesAllResultSets()`
`static boolean`	`dataDefinitionCausesTransactionCommit()`
`static boolean`	`dataDefinitionIgnoredInTransactions()`
`static boolean`	`deletesAreDetected(int type)`
`static boolean`	`doesMaxRowSizeIncludeBlobs()`
`private static void`	`executeDDL(java.sql.Connection conn, java.lang.String text)` Execute a DDL statement.
`static java.sql.ResultSet`	`getAttributes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, java.lang.String attributeNamePattern)`
`static java.sql.ResultSet`	`getBestRowIdentifier(java.lang.String catalog, java.lang.String schema, java.lang.String table, int scope, boolean nullable)`
`static java.sql.ResultSet`	`getCatalogs()`
`static java.lang.String`	`getCatalogSeparator()`
`static java.lang.String`	`getCatalogTerm()`
`static java.sql.ResultSet`	`getClientInfoProperties()`
`static java.sql.ResultSet`	`getColumnPrivileges(java.lang.String catalog, java.lang.String schema, java.lang.String table, java.lang.String columnNamePattern)`
`static java.sql.ResultSet`	`getColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String columnNamePattern)`
`static java.sql.ResultSet`	`getCrossReference(java.lang.String parentCatalog, java.lang.String parentSchema, java.lang.String parentTable, java.lang.String foreignCatalog, java.lang.String foreignSchema, java.lang.String foreignTable)`
`static int`	`getDatabaseMajorVersion()`
`static int`	`getDatabaseMinorVersion()`
`static java.lang.String`	`getDatabaseProductName()`
`static java.lang.String`	`getDatabaseProductVersion()`
`private static java.sql.DatabaseMetaData`	`getDBMD()` Get the current session's database metadata.
`private static java.sql.Connection`	`getDefaultConnection()` Get the default connection, called from inside the database engine.
`static int`	`getDefaultTransactionIsolation()`
`static int`	`getDriverMajorVersion()`
`static int`	`getDriverMinorVersion()`
`static java.lang.String`	`getDriverName()`
`static java.lang.String`	`getDriverVersion()`
`private java.lang.Object`	`getDummyValue(java.lang.Class type)` Get a dummy value for an argument to a DBMD method.
`static java.sql.ResultSet`	`getExportedKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table)`
`static java.lang.String`	`getExtraNameCharacters()`
`static java.sql.ResultSet`	`getFunctionColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String functionNamePattern, java.lang.String columnNamePattern)`
`static java.sql.ResultSet`	`getFunctions(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String functionNamePattern)`
`static java.lang.String`	`getIdentifierQuoteString()`
`static java.sql.ResultSet`	`getImportedKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table)`
`static java.sql.ResultSet`	`getIndexInfo(java.lang.String catalog, java.lang.String schema, java.lang.String table, boolean unique, boolean approximate)`
`static int`	`getJDBCMajorVersion()`
`static int`	`getJDBCMinorVersion()`
`static int`	`getMaxBinaryLiteralLength()`
`static int`	`getMaxCatalogNameLength()`
`static int`	`getMaxCharLiteralLength()`
`static int`	`getMaxColumnNameLength()`
`static int`	`getMaxColumnsInGroupBy()`
`static int`	`getMaxColumnsInIndex()`
`static int`	`getMaxColumnsInOrderBy()`
`static int`	`getMaxColumnsInSelect()`
`static int`	`getMaxColumnsInTable()`
`static int`	`getMaxConnections()`
`static int`	`getMaxCursorNameLength()`
`static int`	`getMaxIndexLength()`
`static int`	`getMaxProcedureNameLength()`
`static int`	`getMaxRowSize()`
`static int`	`getMaxSchemaNameLength()`
`static int`	`getMaxStatementLength()`
`static int`	`getMaxStatements()`
`static int`	`getMaxTableNameLength()`
`static int`	`getMaxTablesInSelect()`
`static int`	`getMaxUserNameLength()`
`static java.lang.String`	`getNumericFunctions()`
`static java.sql.ResultSet`	`getPrimaryKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table)`
`static java.sql.ResultSet`	`getProcedureColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedureNamePattern, java.lang.String columnNamePattern)`
`static java.sql.ResultSet`	`getProcedures(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedureNamePattern)`
`static java.lang.String`	`getProcedureTerm()`
`static int`	`getResultSetHoldability()`
`static java.sql.ResultSet`	`getSchemas(java.lang.String catalog, java.lang.String schemaPattern)`
`static java.lang.String`	`getSchemaTerm()`
`static java.lang.String`	`getSearchStringEscape()`
`static java.lang.String`	`getSQLKeywords()`
`static int`	`getSQLStateType()`
`static java.lang.String`	`getStringFunctions()`
`static java.sql.ResultSet`	`getSuperTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern)`
`static java.sql.ResultSet`	`getSuperTypes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern)`
`static java.lang.String`	`getSystemFunctions()`
`static java.sql.ResultSet`	`getTablePrivileges(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern)`
`static java.sql.ResultSet`	`getTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern)`
`static java.sql.ResultSet`	`getTableTypes()`
`static java.lang.String`	`getTimeDateFunctions()`
`static java.sql.ResultSet`	`getTypeInfo()`
`static java.sql.ResultSet`	`getUDTs(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern)`
`static java.lang.String`	`getURL()`
`static java.lang.String`	`getUserName()`
`static java.sql.ResultSet`	`getVersionColumns(java.lang.String catalog, java.lang.String schema, java.lang.String table)`
`static boolean`	`insertsAreDetected(int type)`
`static boolean`	`isCatalogAtStart()`
`static boolean`	`isReadOnly()`
`private boolean`	`isSet(int allModifiers, int requestedModifier)` Return true if the requested modifer is set
`private boolean`	`isTableFunction(java.lang.reflect.Method method)` Return true if the method describes a table function.
`void`	`loadTool(java.lang.String... configurationParameters)` Load the tool, giving it optional configuration parameters
`static boolean`	`locatorsUpdateCopy()`
`private java.lang.String`	`mapJavaToSQLType(java.lang.Class javaType)` Get the SQL type which corresponds to a Java type.
`static boolean`	`nullPlusNonNullIsNull()`
`static boolean`	`nullsAreSortedAtEnd()`
`static boolean`	`nullsAreSortedAtStart()`
`static boolean`	`nullsAreSortedHigh()`
`static boolean`	`nullsAreSortedLow()`
`static boolean`	`othersDeletesAreVisible(int type)`
`static boolean`	`othersInsertsAreVisible(int type)`
`static boolean`	`othersUpdatesAreVisible(int type)`
`static boolean`	`ownDeletesAreVisible(int type)`
`static boolean`	`ownInsertsAreVisible(int type)`
`static boolean`	`ownUpdatesAreVisible(int type)`
`private static java.sql.PreparedStatement`	`prepareStatement(java.sql.Connection conn, java.lang.String text)` Prepare a statement and print out the text.
`private void`	`register(boolean register)` Workhorse to register or unregister all public static methods as Derby routines.
`private void`	`registerFunction(java.sql.Connection conn, java.lang.reflect.Method method)` Register the method as a Derby function.
`static boolean`	`storesLowerCaseIdentifiers()`
`static boolean`	`storesLowerCaseQuotedIdentifiers()`
`static boolean`	`storesMixedCaseIdentifiers()`
`static boolean`	`storesMixedCaseQuotedIdentifiers()`
`static boolean`	`storesUpperCaseIdentifiers()`
`static boolean`	`storesUpperCaseQuotedIdentifiers()`
`private void`	`stringifyJDBCType(java.lang.StringBuffer buffer, java.sql.ResultSetMetaData rsmd, int columnNumber)` Append the name of a SQL type to an evolving ddl text buffer
`static boolean`	`supportsAlterTableWithAddColumn()`
`static boolean`	`supportsAlterTableWithDropColumn()`
`static boolean`	`supportsANSI92EntryLevelSQL()`
`static boolean`	`supportsANSI92FullSQL()`
`static boolean`	`supportsANSI92IntermediateSQL()`
`static boolean`	`supportsBatchUpdates()`
`static boolean`	`supportsCatalogsInDataManipulation()`
`static boolean`	`supportsCatalogsInIndexDefinitions()`
`static boolean`	`supportsCatalogsInPrivilegeDefinitions()`
`static boolean`	`supportsCatalogsInProcedureCalls()`
`static boolean`	`supportsCatalogsInTableDefinitions()`
`static boolean`	`supportsColumnAliasing()`
`static boolean`	`supportsConvert(int fromType, int toType)`
`static boolean`	`supportsCoreSQLGrammar()`
`static boolean`	`supportsCorrelatedSubqueries()`
`static boolean`	`supportsDataDefinitionAndDataManipulationTransactions()`
`static boolean`	`supportsDataManipulationTransactionsOnly()`
`static boolean`	`supportsDifferentTableCorrelationNames()`
`static boolean`	`supportsExpressionsInOrderBy()`
`static boolean`	`supportsExtendedSQLGrammar()`
`static boolean`	`supportsFullOuterJoins()`
`static boolean`	`supportsGetGeneratedKeys()`
`static boolean`	`supportsGroupBy()`
`static boolean`	`supportsGroupByBeyondSelect()`
`static boolean`	`supportsGroupByUnrelated()`
`static boolean`	`supportsIntegrityEnhancementFacility()`
`static boolean`	`supportsLikeEscapeClause()`
`static boolean`	`supportsLimitedOuterJoins()`
`static boolean`	`supportsMinimumSQLGrammar()`
`static boolean`	`supportsMixedCaseIdentifiers()`
`static boolean`	`supportsMixedCaseQuotedIdentifiers()`
`static boolean`	`supportsMultipleOpenResults()`
`static boolean`	`supportsMultipleResultSets()`
`static boolean`	`supportsMultipleTransactions()`
`static boolean`	`supportsNamedParameters()`
`static boolean`	`supportsNonNullableColumns()`
`static boolean`	`supportsOpenCursorsAcrossCommit()`
`static boolean`	`supportsOpenCursorsAcrossRollback()`
`static boolean`	`supportsOpenStatementsAcrossCommit()`
`static boolean`	`supportsOpenStatementsAcrossRollback()`
`static boolean`	`supportsOrderByUnrelated()`
`static boolean`	`supportsOuterJoins()`
`static boolean`	`supportsPositionedDelete()`
`static boolean`	`supportsPositionedUpdate()`
`static boolean`	`supportsResultSetConcurrency(int type, int concurrency)`
`static boolean`	`supportsResultSetHoldability(int holdability)`
`static boolean`	`supportsResultSetType(int type)`
`static boolean`	`supportsSavepoints()`
`static boolean`	`supportsSchemasInDataManipulation()`
`static boolean`	`supportsSchemasInIndexDefinitions()`
`static boolean`	`supportsSchemasInPrivilegeDefinitions()`
`static boolean`	`supportsSchemasInProcedureCalls()`
`static boolean`	`supportsSchemasInTableDefinitions()`
`static boolean`	`supportsSelectForUpdate()`
`static boolean`	`supportsStatementPooling()`
`static boolean`	`supportsStoredFunctionsUsingCallSyntax()`
`static boolean`	`supportsStoredProcedures()`
`static boolean`	`supportsSubqueriesInComparisons()`
`static boolean`	`supportsSubqueriesInExists()`
`static boolean`	`supportsSubqueriesInIns()`
`static boolean`	`supportsSubqueriesInQuantifieds()`
`static boolean`	`supportsTableCorrelationNames()`
`static boolean`	`supportsTransactionIsolationLevel(int level)`
`static boolean`	`supportsTransactions()`
`static boolean`	`supportsUnion()`
`static boolean`	`supportsUnionAll()`
`void`	`unloadTool(java.lang.String... configurationParameters)` Unload the tool, giving it optional configuration parameters
`private void`	`unregisterFunction(java.sql.Connection conn, java.lang.reflect.Method method)` Drop the function with this method name.
`static boolean`	`updatesAreDetected(int type)`
`static boolean`	`usesLocalFilePerTable()`
`static boolean`	`usesLocalFiles()`
`private static java.sql.SQLException`	`wrap(java.lang.Throwable t)` Wrap an exception in a SQLException.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail
- DEFAULT_PRECISION
```
private static final int DEFAULT_PRECISION
```
  See Also:
  Constant Field Values

Constructor Detail
- DBMDWrapper
```
public DBMDWrapper()
```
  0-arg constructor to satisfy the OptionalTool contract

Method Detail

loadTool
```
public void loadTool(java.lang.String... configurationParameters)
              throws java.sql.SQLException
```
Description copied from interface: OptionalTool

Load the tool, giving it optional configuration parameters

Specified by:

loadTool in interface OptionalTool

Throws:

java.sql.SQLException

unloadTool
```
public void unloadTool(java.lang.String... configurationParameters)
                throws java.sql.SQLException
```
Description copied from interface: OptionalTool

Unload the tool, giving it optional configuration parameters

Specified by:

unloadTool in interface OptionalTool

Throws:

java.sql.SQLException

register
```
private void register(boolean register)
               throws java.sql.SQLException
```
Workhorse to register or unregister all public static methods as Derby routines.

Throws:

java.sql.SQLException

allProceduresAreCallable

public static boolean allProceduresAreCallable()
                                        throws java.sql.SQLException

Throws:: java.sql.SQLException

allTablesAreSelectable

public static boolean allTablesAreSelectable()
                                      throws java.sql.SQLException

Throws:: java.sql.SQLException

autoCommitFailureClosesAllResultSets

public static boolean autoCommitFailureClosesAllResultSets()
                                                    throws java.sql.SQLException

Throws:: java.sql.SQLException

dataDefinitionCausesTransactionCommit

public static boolean dataDefinitionCausesTransactionCommit()
                                                     throws java.sql.SQLException

Throws:: java.sql.SQLException

dataDefinitionIgnoredInTransactions

public static boolean dataDefinitionIgnoredInTransactions()
                                                   throws java.sql.SQLException

Throws:: java.sql.SQLException

deletesAreDetected

public static boolean deletesAreDetected(int type)
                                  throws java.sql.SQLException

Throws:: java.sql.SQLException

doesMaxRowSizeIncludeBlobs

public static boolean doesMaxRowSizeIncludeBlobs()
                                          throws java.sql.SQLException

Throws:: java.sql.SQLException

getAttributes

public static java.sql.ResultSet getAttributes(java.lang.String catalog,
                               java.lang.String schemaPattern,
                               java.lang.String typeNamePattern,
                               java.lang.String attributeNamePattern)
                                        throws java.sql.SQLException

Throws:: java.sql.SQLException

getBestRowIdentifier

public static java.sql.ResultSet getBestRowIdentifier(java.lang.String catalog,
                                      java.lang.String schema,
                                      java.lang.String table,
                                      int scope,
                                      boolean nullable)
                                               throws java.sql.SQLException

Throws:: java.sql.SQLException

getCatalogs

public static java.sql.ResultSet getCatalogs()
                                      throws java.sql.SQLException

Throws:: java.sql.SQLException

getCatalogSeparator

public static java.lang.String getCatalogSeparator()
                                            throws java.sql.SQLException

Throws:: java.sql.SQLException

getCatalogTerm

public static java.lang.String getCatalogTerm()
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

getClientInfoProperties

public static java.sql.ResultSet getClientInfoProperties()
                                                  throws java.sql.SQLException

Throws:: java.sql.SQLException

getColumnPrivileges

public static java.sql.ResultSet getColumnPrivileges(java.lang.String catalog,
                                     java.lang.String schema,
                                     java.lang.String table,
                                     java.lang.String columnNamePattern)
                                              throws java.sql.SQLException

Throws:: java.sql.SQLException

getColumns

public static java.sql.ResultSet getColumns(java.lang.String catalog,
                            java.lang.String schemaPattern,
                            java.lang.String tableNamePattern,
                            java.lang.String columnNamePattern)
                                     throws java.sql.SQLException

Throws:: java.sql.SQLException

getCrossReference

public static java.sql.ResultSet getCrossReference(java.lang.String parentCatalog,
                                   java.lang.String parentSchema,
                                   java.lang.String parentTable,
                                   java.lang.String foreignCatalog,
                                   java.lang.String foreignSchema,
                                   java.lang.String foreignTable)
                                            throws java.sql.SQLException

Throws:: java.sql.SQLException

getDatabaseMajorVersion

public static int getDatabaseMajorVersion()
                                   throws java.sql.SQLException

Throws:: java.sql.SQLException

getDatabaseMinorVersion

public static int getDatabaseMinorVersion()
                                   throws java.sql.SQLException

Throws:: java.sql.SQLException

getDatabaseProductName

public static java.lang.String getDatabaseProductName()
                                               throws java.sql.SQLException

Throws:: java.sql.SQLException

getDatabaseProductVersion

public static java.lang.String getDatabaseProductVersion()
                                                  throws java.sql.SQLException

Throws:: java.sql.SQLException

getDefaultTransactionIsolation

public static int getDefaultTransactionIsolation()
                                          throws java.sql.SQLException

Throws:: java.sql.SQLException

getDriverMajorVersion

public static int getDriverMajorVersion()
                                 throws java.sql.SQLException

Throws:: java.sql.SQLException

getDriverMinorVersion

public static int getDriverMinorVersion()
                                 throws java.sql.SQLException

Throws:: java.sql.SQLException

getDriverName

public static java.lang.String getDriverName()
                                      throws java.sql.SQLException

Throws:: java.sql.SQLException

getDriverVersion

public static java.lang.String getDriverVersion()
                                         throws java.sql.SQLException

Throws:: java.sql.SQLException

getExportedKeys

public static java.sql.ResultSet getExportedKeys(java.lang.String catalog,
                                 java.lang.String schema,
                                 java.lang.String table)
                                          throws java.sql.SQLException

Throws:: java.sql.SQLException

getExtraNameCharacters

public static java.lang.String getExtraNameCharacters()
                                               throws java.sql.SQLException

Throws:: java.sql.SQLException

getFunctionColumns

public static java.sql.ResultSet getFunctionColumns(java.lang.String catalog,
                                    java.lang.String schemaPattern,
                                    java.lang.String functionNamePattern,
                                    java.lang.String columnNamePattern)
                                             throws java.sql.SQLException

Throws:: java.sql.SQLException

getFunctions

public static java.sql.ResultSet getFunctions(java.lang.String catalog,
                              java.lang.String schemaPattern,
                              java.lang.String functionNamePattern)
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

getIdentifierQuoteString

public static java.lang.String getIdentifierQuoteString()
                                                 throws java.sql.SQLException

Throws:: java.sql.SQLException

getImportedKeys

public static java.sql.ResultSet getImportedKeys(java.lang.String catalog,
                                 java.lang.String schema,
                                 java.lang.String table)
                                          throws java.sql.SQLException

Throws:: java.sql.SQLException

getIndexInfo

public static java.sql.ResultSet getIndexInfo(java.lang.String catalog,
                              java.lang.String schema,
                              java.lang.String table,
                              boolean unique,
                              boolean approximate)
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

getJDBCMajorVersion

public static int getJDBCMajorVersion()
                               throws java.sql.SQLException

Throws:: java.sql.SQLException

getJDBCMinorVersion

public static int getJDBCMinorVersion()
                               throws java.sql.SQLException

Throws:: java.sql.SQLException

getMaxBinaryLiteralLength

public static int getMaxBinaryLiteralLength()
                                     throws java.sql.SQLException

Throws:: java.sql.SQLException

getMaxCatalogNameLength

public static int getMaxCatalogNameLength()
                                   throws java.sql.SQLException

Throws:: java.sql.SQLException

getMaxCharLiteralLength

public static int getMaxCharLiteralLength()
                                   throws java.sql.SQLException

Throws:: java.sql.SQLException

getMaxColumnNameLength

public static int getMaxColumnNameLength()
                                  throws java.sql.SQLException

Throws:: java.sql.SQLException

getMaxColumnsInGroupBy

public static int getMaxColumnsInGroupBy()
                                  throws java.sql.SQLException

Throws:: java.sql.SQLException

getMaxColumnsInIndex

public static int getMaxColumnsInIndex()
                                throws java.sql.SQLException

Throws:: java.sql.SQLException

getMaxColumnsInOrderBy

public static int getMaxColumnsInOrderBy()
                                  throws java.sql.SQLException

Throws:: java.sql.SQLException

getMaxColumnsInSelect

public static int getMaxColumnsInSelect()
                                 throws java.sql.SQLException

Throws:: java.sql.SQLException

getMaxColumnsInTable

public static int getMaxColumnsInTable()
                                throws java.sql.SQLException

Throws:: java.sql.SQLException

getMaxConnections

public static int getMaxConnections()
                             throws java.sql.SQLException

Throws:: java.sql.SQLException

getMaxCursorNameLength

public static int getMaxCursorNameLength()
                                  throws java.sql.SQLException

Throws:: java.sql.SQLException

getMaxIndexLength

public static int getMaxIndexLength()
                             throws java.sql.SQLException

Throws:: java.sql.SQLException

getMaxProcedureNameLength

public static int getMaxProcedureNameLength()
                                     throws java.sql.SQLException

Throws:: java.sql.SQLException

getMaxRowSize

public static int getMaxRowSize()
                         throws java.sql.SQLException

Throws:: java.sql.SQLException

getMaxSchemaNameLength

public static int getMaxSchemaNameLength()
                                  throws java.sql.SQLException

Throws:: java.sql.SQLException

getMaxStatementLength

public static int getMaxStatementLength()
                                 throws java.sql.SQLException

Throws:: java.sql.SQLException

getMaxStatements

public static int getMaxStatements()
                            throws java.sql.SQLException

Throws:: java.sql.SQLException

getMaxTableNameLength

public static int getMaxTableNameLength()
                                 throws java.sql.SQLException

Throws:: java.sql.SQLException

getMaxTablesInSelect

public static int getMaxTablesInSelect()
                                throws java.sql.SQLException

Throws:: java.sql.SQLException

getMaxUserNameLength

public static int getMaxUserNameLength()
                                throws java.sql.SQLException

Throws:: java.sql.SQLException

getNumericFunctions

public static java.lang.String getNumericFunctions()
                                            throws java.sql.SQLException

Throws:: java.sql.SQLException

getPrimaryKeys

public static java.sql.ResultSet getPrimaryKeys(java.lang.String catalog,
                                java.lang.String schema,
                                java.lang.String table)
                                         throws java.sql.SQLException

Throws:: java.sql.SQLException

getProcedureColumns

public static java.sql.ResultSet getProcedureColumns(java.lang.String catalog,
                                     java.lang.String schemaPattern,
                                     java.lang.String procedureNamePattern,
                                     java.lang.String columnNamePattern)
                                              throws java.sql.SQLException

Throws:: java.sql.SQLException

getProcedures

public static java.sql.ResultSet getProcedures(java.lang.String catalog,
                               java.lang.String schemaPattern,
                               java.lang.String procedureNamePattern)
                                        throws java.sql.SQLException

Throws:: java.sql.SQLException

getProcedureTerm

public static java.lang.String getProcedureTerm()
                                         throws java.sql.SQLException

Throws:: java.sql.SQLException

getResultSetHoldability

public static int getResultSetHoldability()
                                   throws java.sql.SQLException

Throws:: java.sql.SQLException

getSchemas

public static java.sql.ResultSet getSchemas(java.lang.String catalog,
                            java.lang.String schemaPattern)
                                     throws java.sql.SQLException

Throws:: java.sql.SQLException

getSchemaTerm

public static java.lang.String getSchemaTerm()
                                      throws java.sql.SQLException

Throws:: java.sql.SQLException

getSearchStringEscape

public static java.lang.String getSearchStringEscape()
                                              throws java.sql.SQLException

Throws:: java.sql.SQLException

getSQLKeywords

public static java.lang.String getSQLKeywords()
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

getSQLStateType

public static int getSQLStateType()
                           throws java.sql.SQLException

Throws:: java.sql.SQLException

getStringFunctions

public static java.lang.String getStringFunctions()
                                           throws java.sql.SQLException

Throws:: java.sql.SQLException

getSuperTables

public static java.sql.ResultSet getSuperTables(java.lang.String catalog,
                                java.lang.String schemaPattern,
                                java.lang.String tableNamePattern)
                                         throws java.sql.SQLException

Throws:: java.sql.SQLException

getSuperTypes

public static java.sql.ResultSet getSuperTypes(java.lang.String catalog,
                               java.lang.String schemaPattern,
                               java.lang.String typeNamePattern)
                                        throws java.sql.SQLException

Throws:: java.sql.SQLException

getSystemFunctions

public static java.lang.String getSystemFunctions()
                                           throws java.sql.SQLException

Throws:: java.sql.SQLException

getTablePrivileges

public static java.sql.ResultSet getTablePrivileges(java.lang.String catalog,
                                    java.lang.String schemaPattern,
                                    java.lang.String tableNamePattern)
                                             throws java.sql.SQLException

Throws:: java.sql.SQLException

getTables

public static java.sql.ResultSet getTables(java.lang.String catalog,
                           java.lang.String schemaPattern,
                           java.lang.String tableNamePattern)
                                    throws java.sql.SQLException

Throws:: java.sql.SQLException

getTableTypes

public static java.sql.ResultSet getTableTypes()
                                        throws java.sql.SQLException

Throws:: java.sql.SQLException

getTimeDateFunctions

public static java.lang.String getTimeDateFunctions()
                                             throws java.sql.SQLException

Throws:: java.sql.SQLException

getTypeInfo

public static java.sql.ResultSet getTypeInfo()
                                      throws java.sql.SQLException

Throws:: java.sql.SQLException

getUDTs

public static java.sql.ResultSet getUDTs(java.lang.String catalog,
                         java.lang.String schemaPattern,
                         java.lang.String typeNamePattern)
                                  throws java.sql.SQLException

Throws:: java.sql.SQLException

getURL

public static java.lang.String getURL()
                               throws java.sql.SQLException

Throws:: java.sql.SQLException

getUserName

public static java.lang.String getUserName()
                                    throws java.sql.SQLException

Throws:: java.sql.SQLException

getVersionColumns

public static java.sql.ResultSet getVersionColumns(java.lang.String catalog,
                                   java.lang.String schema,
                                   java.lang.String table)
                                            throws java.sql.SQLException

Throws:: java.sql.SQLException

insertsAreDetected

public static boolean insertsAreDetected(int type)
                                  throws java.sql.SQLException

Throws:: java.sql.SQLException

isCatalogAtStart

public static boolean isCatalogAtStart()
                                throws java.sql.SQLException

Throws:: java.sql.SQLException

isReadOnly

public static boolean isReadOnly()
                          throws java.sql.SQLException

Throws:: java.sql.SQLException

locatorsUpdateCopy

public static boolean locatorsUpdateCopy()
                                  throws java.sql.SQLException

Throws:: java.sql.SQLException

nullPlusNonNullIsNull

public static boolean nullPlusNonNullIsNull()
                                     throws java.sql.SQLException

Throws:: java.sql.SQLException

nullsAreSortedAtEnd

public static boolean nullsAreSortedAtEnd()
                                   throws java.sql.SQLException

Throws:: java.sql.SQLException

nullsAreSortedAtStart

public static boolean nullsAreSortedAtStart()
                                     throws java.sql.SQLException

Throws:: java.sql.SQLException

nullsAreSortedHigh

public static boolean nullsAreSortedHigh()
                                  throws java.sql.SQLException

Throws:: java.sql.SQLException

nullsAreSortedLow

public static boolean nullsAreSortedLow()
                                 throws java.sql.SQLException

Throws:: java.sql.SQLException

othersDeletesAreVisible

public static boolean othersDeletesAreVisible(int type)
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

othersInsertsAreVisible

public static boolean othersInsertsAreVisible(int type)
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

othersUpdatesAreVisible

public static boolean othersUpdatesAreVisible(int type)
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

ownDeletesAreVisible

public static boolean ownDeletesAreVisible(int type)
                                    throws java.sql.SQLException

Throws:: java.sql.SQLException

ownInsertsAreVisible

public static boolean ownInsertsAreVisible(int type)
                                    throws java.sql.SQLException

Throws:: java.sql.SQLException

ownUpdatesAreVisible

public static boolean ownUpdatesAreVisible(int type)
                                    throws java.sql.SQLException

Throws:: java.sql.SQLException

storesLowerCaseIdentifiers

public static boolean storesLowerCaseIdentifiers()
                                          throws java.sql.SQLException

Throws:: java.sql.SQLException

storesLowerCaseQuotedIdentifiers

public static boolean storesLowerCaseQuotedIdentifiers()
                                                throws java.sql.SQLException

Throws:: java.sql.SQLException

storesMixedCaseIdentifiers

public static boolean storesMixedCaseIdentifiers()
                                          throws java.sql.SQLException

Throws:: java.sql.SQLException

storesMixedCaseQuotedIdentifiers

public static boolean storesMixedCaseQuotedIdentifiers()
                                                throws java.sql.SQLException

Throws:: java.sql.SQLException

storesUpperCaseIdentifiers

public static boolean storesUpperCaseIdentifiers()
                                          throws java.sql.SQLException

Throws:: java.sql.SQLException

storesUpperCaseQuotedIdentifiers

public static boolean storesUpperCaseQuotedIdentifiers()
                                                throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsAlterTableWithAddColumn

public static boolean supportsAlterTableWithAddColumn()
                                               throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsAlterTableWithDropColumn

public static boolean supportsAlterTableWithDropColumn()
                                                throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsANSI92EntryLevelSQL

public static boolean supportsANSI92EntryLevelSQL()
                                           throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsANSI92FullSQL

public static boolean supportsANSI92FullSQL()
                                     throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsANSI92IntermediateSQL

public static boolean supportsANSI92IntermediateSQL()
                                             throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsBatchUpdates

public static boolean supportsBatchUpdates()
                                    throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsCatalogsInDataManipulation

public static boolean supportsCatalogsInDataManipulation()
                                                  throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsCatalogsInIndexDefinitions

public static boolean supportsCatalogsInIndexDefinitions()
                                                  throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsCatalogsInPrivilegeDefinitions

public static boolean supportsCatalogsInPrivilegeDefinitions()
                                                      throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsCatalogsInProcedureCalls

public static boolean supportsCatalogsInProcedureCalls()
                                                throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsCatalogsInTableDefinitions

public static boolean supportsCatalogsInTableDefinitions()
                                                  throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsColumnAliasing

public static boolean supportsColumnAliasing()
                                      throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsConvert

public static boolean supportsConvert(int fromType,
                      int toType)
                               throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsCoreSQLGrammar

public static boolean supportsCoreSQLGrammar()
                                      throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsCorrelatedSubqueries

public static boolean supportsCorrelatedSubqueries()
                                            throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsDataDefinitionAndDataManipulationTransactions

public static boolean supportsDataDefinitionAndDataManipulationTransactions()
                                                                     throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsDataManipulationTransactionsOnly

public static boolean supportsDataManipulationTransactionsOnly()
                                                        throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsDifferentTableCorrelationNames

public static boolean supportsDifferentTableCorrelationNames()
                                                      throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsExpressionsInOrderBy

public static boolean supportsExpressionsInOrderBy()
                                            throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsExtendedSQLGrammar

public static boolean supportsExtendedSQLGrammar()
                                          throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsFullOuterJoins

public static boolean supportsFullOuterJoins()
                                      throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsGetGeneratedKeys

public static boolean supportsGetGeneratedKeys()
                                        throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsGroupBy

public static boolean supportsGroupBy()
                               throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsGroupByBeyondSelect

public static boolean supportsGroupByBeyondSelect()
                                           throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsGroupByUnrelated

public static boolean supportsGroupByUnrelated()
                                        throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsIntegrityEnhancementFacility

public static boolean supportsIntegrityEnhancementFacility()
                                                    throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsLikeEscapeClause

public static boolean supportsLikeEscapeClause()
                                        throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsLimitedOuterJoins

public static boolean supportsLimitedOuterJoins()
                                         throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsMinimumSQLGrammar

public static boolean supportsMinimumSQLGrammar()
                                         throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsMixedCaseIdentifiers

public static boolean supportsMixedCaseIdentifiers()
                                            throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsMixedCaseQuotedIdentifiers

public static boolean supportsMixedCaseQuotedIdentifiers()
                                                  throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsMultipleOpenResults

public static boolean supportsMultipleOpenResults()
                                           throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsMultipleResultSets

public static boolean supportsMultipleResultSets()
                                          throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsMultipleTransactions

public static boolean supportsMultipleTransactions()
                                            throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsNamedParameters

public static boolean supportsNamedParameters()
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsNonNullableColumns

public static boolean supportsNonNullableColumns()
                                          throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsOpenCursorsAcrossCommit

public static boolean supportsOpenCursorsAcrossCommit()
                                               throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsOpenCursorsAcrossRollback

public static boolean supportsOpenCursorsAcrossRollback()
                                                 throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsOpenStatementsAcrossCommit

public static boolean supportsOpenStatementsAcrossCommit()
                                                  throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsOpenStatementsAcrossRollback

public static boolean supportsOpenStatementsAcrossRollback()
                                                    throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsOrderByUnrelated

public static boolean supportsOrderByUnrelated()
                                        throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsOuterJoins

public static boolean supportsOuterJoins()
                                  throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsPositionedDelete

public static boolean supportsPositionedDelete()
                                        throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsPositionedUpdate

public static boolean supportsPositionedUpdate()
                                        throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsResultSetConcurrency

public static boolean supportsResultSetConcurrency(int type,
                                   int concurrency)
                                            throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsResultSetHoldability

public static boolean supportsResultSetHoldability(int holdability)
                                            throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsResultSetType

public static boolean supportsResultSetType(int type)
                                     throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsSavepoints

public static boolean supportsSavepoints()
                                  throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsSchemasInDataManipulation

public static boolean supportsSchemasInDataManipulation()
                                                 throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsSchemasInIndexDefinitions

public static boolean supportsSchemasInIndexDefinitions()
                                                 throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsSchemasInPrivilegeDefinitions

public static boolean supportsSchemasInPrivilegeDefinitions()
                                                     throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsSchemasInProcedureCalls

public static boolean supportsSchemasInProcedureCalls()
                                               throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsSchemasInTableDefinitions

public static boolean supportsSchemasInTableDefinitions()
                                                 throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsSelectForUpdate

public static boolean supportsSelectForUpdate()
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsStatementPooling

public static boolean supportsStatementPooling()
                                        throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsStoredFunctionsUsingCallSyntax

public static boolean supportsStoredFunctionsUsingCallSyntax()
                                                      throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsStoredProcedures

public static boolean supportsStoredProcedures()
                                        throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsSubqueriesInComparisons

public static boolean supportsSubqueriesInComparisons()
                                               throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsSubqueriesInExists

public static boolean supportsSubqueriesInExists()
                                          throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsSubqueriesInIns

public static boolean supportsSubqueriesInIns()
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsSubqueriesInQuantifieds

public static boolean supportsSubqueriesInQuantifieds()
                                               throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsTableCorrelationNames

public static boolean supportsTableCorrelationNames()
                                             throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsTransactionIsolationLevel

public static boolean supportsTransactionIsolationLevel(int level)
                                                 throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsTransactions

public static boolean supportsTransactions()
                                    throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsUnion

public static boolean supportsUnion()
                             throws java.sql.SQLException

Throws:: java.sql.SQLException

supportsUnionAll

public static boolean supportsUnionAll()
                                throws java.sql.SQLException

Throws:: java.sql.SQLException

updatesAreDetected

public static boolean updatesAreDetected(int type)
                                  throws java.sql.SQLException

Throws:: java.sql.SQLException

usesLocalFilePerTable

public static boolean usesLocalFilePerTable()
                                     throws java.sql.SQLException

Throws:: java.sql.SQLException

usesLocalFiles

public static boolean usesLocalFiles()
                              throws java.sql.SQLException

Throws:: java.sql.SQLException

isSet

private boolean isSet(int allModifiers,
            int requestedModifier)

Return true if the requested modifer is set

unregisterFunction

private void unregisterFunction(java.sql.Connection conn,
                      java.lang.reflect.Method method)
                         throws java.sql.SQLException

Drop the function with this method name.

Throws:: java.sql.SQLException

registerFunction

private void registerFunction(java.sql.Connection conn,
                    java.lang.reflect.Method method)
                       throws java.sql.SQLException

Throws:: java.sql.SQLException

isTableFunction
```
private boolean isTableFunction(java.lang.reflect.Method method)
```
Return true if the method describes a table function.

appendArgs

private void appendArgs(java.lang.StringBuffer buffer,
              java.lang.reflect.Method method)
                 throws java.sql.SQLException

Append function arguments to an evolving ddl text buffer.

Throws:: java.sql.SQLException

appendReturnType

private void appendReturnType(java.lang.StringBuffer buffer,
                    java.sql.Connection conn,
                    java.lang.reflect.Method method)
                       throws java.sql.SQLException

Append return type to an evolving ddl text buffer

Throws:: java.sql.SQLException

appendTableFunctionSignature

private void appendTableFunctionSignature(java.lang.StringBuffer buffer,
                                java.sql.Connection conn,
                                java.lang.reflect.Method method)
                                   throws java.sql.SQLException

Append the signature of a table function to an evolving ddl text buffer

Throws:: java.sql.SQLException

getDummyValue
```
private java.lang.Object getDummyValue(java.lang.Class type)
```
Get a dummy value for an argument to a DBMD method.

stringifyJDBCType

private void stringifyJDBCType(java.lang.StringBuffer buffer,
                     java.sql.ResultSetMetaData rsmd,
                     int columnNumber)
                        throws java.sql.SQLException

Append the name of a SQL type to an evolving ddl text buffer

Throws:: java.sql.SQLException

mapJavaToSQLType

private java.lang.String mapJavaToSQLType(java.lang.Class javaType)
                                   throws java.sql.SQLException

Get the SQL type which corresponds to a Java type.

Throws:: java.sql.SQLException

getDBMD

private static java.sql.DatabaseMetaData getDBMD()
                                          throws java.sql.SQLException

Get the current session's database metadata.

Throws:: java.sql.SQLException

getDefaultConnection

private static java.sql.Connection getDefaultConnection()
                                                 throws java.sql.SQLException

Get the default connection, called from inside the database engine.

Throws:: java.sql.SQLException

executeDDL

private static void executeDDL(java.sql.Connection conn,
              java.lang.String text)
                        throws java.sql.SQLException

Execute a DDL statement.

Throws:: java.sql.SQLException

prepareStatement

private static java.sql.PreparedStatement prepareStatement(java.sql.Connection conn,
                                          java.lang.String text)
                                                    throws java.sql.SQLException

Prepare a statement and print out the text.

Throws:: java.sql.SQLException

wrap

private static java.sql.SQLException wrap(java.lang.Throwable t)

Wrap an exception in a SQLException.

Class DBMDWrapper

Field Summary

Constructor Summary