Java Doc for JdbcDatabaseMetaData.java in  » Database-DBMS » h2database » org » h2 » jdbc » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation 1.  6.0 JDK Core 2.  6.0 JDK Modules 3.  6.0 JDK Modules com.sun 4.  6.0 JDK Modules com.sun.java 5.  6.0 JDK Modules sun 6.  6.0 JDK Platform 7.  Ajax 8.  Apache Harmony Java SE 9.  Aspect oriented 10.  Authentication Authorization 11.  Blogger System 12.  Build 13.  Byte Code 14.  Cache 15.  Chart 16.  Chat 17.  Code Analyzer 18.  Collaboration 19.  Content Management System 20.  Database Client 21.  Database DBMS 22.  Database JDBC Connection Pool 23.  Database ORM 24.  Development 25.  EJB Server geronimo 26.  EJB Server GlassFish 27.  EJB Server JBoss 4.2.1 28.  EJB Server resin 3.1.5 29.  ERP CRM Financial 30.  ESB 31.  Forum 32.  GIS 33.  Graphic Library 34.  Groupware 35.  HTML Parser 36.  IDE 37.  IDE Eclipse 38.  IDE Netbeans 39.  Installer 40.  Internationalization Localization 41.  Inversion of Control 42.  Issue Tracking 43.  J2EE 44.  JBoss 45.  JMS 46.  JMX 47.  Library 48.  Mail Clients 49.  Net 50.  Parser 51.  PDF 52.  Portal 53.  Profiler 54.  Project Management 55.  Report 56.  RSS RDF 57.  Rule Engine 58.  Science 59.  Scripting 60.  Search Engine 61.  Security 62.  Sevlet Container 63.  Source Control 64.  Swing Library 65.  Template Engine 66.  Test Coverage 67.  Testing 68.  UML 69.  Web Crawler 70.  Web Framework 71.  Web Mail 72.  Web Server 73.  Web Services 74.  Web Services apache cxf 2.0.1 75.  Web Services AXIS2 76.  Wiki Engine 77.  Workflow Engines 78.  XML 79.  XML UI Java Java Tutorial Java Open Source Jar File Download Java Articles Java Products Java by API Photoshop Tutorials Maya Tutorials Flash Tutorials 3ds-Max Tutorials Illustrator Tutorials GIMP Tutorials C# / C Sharp C# / CSharp Tutorial C# / CSharp Open Source ASP.Net ASP.NET Tutorial JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial Ruby PHP Python Python Tutorial Python Open Source SQL Server / T-SQL SQL Server / T-SQL Tutorial Oracle PL / SQL Oracle PL/SQL Tutorial PostgreSQL SQL / MySQL MySQL Tutorial VB.Net VB.Net Tutorial Flash / Flex / ActionScript VBA / Excel / Access / Word XML XML Tutorial Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Excel 2007 Tutorial Microsoft Office Word 2007 Tutorial

Java Source Code / Java Documentation » Database DBMS » h2database » org.h2.jdbc   Source Cross Reference   Class Diagram   Java Document (Java Doc)   java.lang.Object    org.h2.message.TraceObject       org.h2.jdbc.JdbcDatabaseMetaData JdbcDatabaseMetaData public class JdbcDatabaseMetaData extends TraceObject implements DatabaseMetaData(Code) Represents the meta data for a database. Constructor Summary   JdbcDatabaseMetaData(JdbcConnection conn, Trace trace, int id)      Method Summary public  boolean allProceduresAreCallable()      Checks if all procedures callable. public  boolean allTablesAreSelectable()      Checks if it possible to query all tables returned by getTables. public  boolean autoCommitFailureClosesAllResultSets()      Returns whether an exception while auto commit is on closes all result sets. public  boolean dataDefinitionCausesTransactionCommit()      Returns whether CREATE/DROP commit an open transaction. public  boolean dataDefinitionIgnoredInTransactions()      Returns whether CREATE/DROP do not affect transactions. public  boolean deletesAreDetected(int type)      Returns whether deletes are detected. public  boolean doesMaxRowSizeIncludeBlobs()      Returns whether the maximum row size includes blobs. public  ResultSet getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern)      public  ResultSet getBestRowIdentifier(String catalog, String schema, String tableName, int scope, boolean nullable)      Gets the list of columns that best identifier a row in a table. public  String getCatalogSeparator()      Returns the catalog separator. public  String getCatalogTerm()      Returns the term for "catalog". public  ResultSet getCatalogs()      Gets the list of catalogs. public  ResultSet getClientInfoProperties()      [Not supported] Returns the client info properties. public  ResultSet getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern)      Gets the list of column privileges. public  ResultSet getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)      Gets the list of columns. public  Connection getConnection()      Returns the connection that created this object. public  ResultSet getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable)      Gets the list of foreign key columns that references a table, as well as the list of primary key columns that are references by a table. public  int getDatabaseMajorVersion()      Gets the major version of the database. public  int getDatabaseMinorVersion()      Gets the minor version of the database. public  String getDatabaseProductName()      Gets the database product name. public  String getDatabaseProductVersion()      Gets the product version of the database. public  int getDefaultTransactionIsolation()      Returns the default transaction isolation level. public  int getDriverMajorVersion()      Returns the major version of this driver. public  int getDriverMinorVersion()      Returns the minor version of this driver. public  String getDriverName()      Gets the name of the JDBC driver. public  String getDriverVersion()      Gets the version number of the driver in the format [MajorVersion].[MinorVersion]. public  ResultSet getExportedKeys(String catalog, String schema, String tableName)      Gets the list of foreign key columns that reference a table. public  String getExtraNameCharacters()      Returns the characters that are allowed for identifiers in addiction to A-Z, a-z, 0-9 and '_'. public  ResultSet getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern)      [Not supported] Gets the list of function columns. public  ResultSet getFunctions(String arg0, String arg1, String arg2)      [Not supported] Gets the list of functions. public  String getIdentifierQuoteString()      Returns the string used to quote identifiers. public  ResultSet getImportedKeys(String catalog, String schema, String tableName)      Gets the list of primary key columns that are referenced by a table. public  ResultSet getIndexInfo(String catalog, String schema, String tableName, boolean unique, boolean approximate)      Gets the list of indexes for this database. public  int getJDBCMajorVersion()      Gets the major version of the supported JDBC API. public  int getJDBCMinorVersion()      Gets the minor version of the supported JDBC API. public  int getMaxBinaryLiteralLength()      Returns the maximum length for hex values (characters). public  int getMaxCatalogNameLength()      Returns the maximum length for a catalog name. public  int getMaxCharLiteralLength()      Returns the maximum length for literals. public  int getMaxColumnNameLength()      Returns the maximum length for column names. public  int getMaxColumnsInGroupBy()      Returns the maximum number of columns in GROUP BY. public  int getMaxColumnsInIndex()      Returns the maximum number of columns in CREATE INDEX. public  int getMaxColumnsInOrderBy()      Returns the maximum number of columns in ORDER BY. public  int getMaxColumnsInSelect()      Returns the maximum number of columns in SELECT. public  int getMaxColumnsInTable()      Returns the maximum number of columns in CREATE TABLE. public  int getMaxConnections()      Returns the maximum number of open connection. public  int getMaxCursorNameLength()      Returns the maximum length for a cursor name. public  int getMaxIndexLength()      Returns the maximum length for an index (in bytes). public  int getMaxProcedureNameLength()      Returns the maximum length for a procedure name. public  int getMaxRowSize()      Returns the maximum size of a row (in bytes). public  int getMaxSchemaNameLength()      Returns the maximum length for a schema name. public  int getMaxStatementLength()      Returns the maximum length of a statement. public  int getMaxStatements()      Returns the maximum number of open statements. public  int getMaxTableNameLength()      Returns the maximum length for a table name. public  int getMaxTablesInSelect()      Returns the maximum number of tables in a SELECT. public  int getMaxUserNameLength()      Returns the maximum length for a user name. public  String getNumericFunctions()      Returns the list of numeric functions supported by this database. public  ResultSet getPrimaryKeys(String catalog, String schema, String tableName)      Gets the primary key columns for a table. public  ResultSet getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern)      Gets the list of procedure columns. public  String getProcedureTerm()      Returns the term for "procedure". public  ResultSet getProcedures(String catalog, String schemaPattern, String procedureNamePattern)      Gets the list of procedures. public  int getResultSetHoldability()      Gets the result set holdability. public  String getSQLKeywords()      Gets the comma-separated list of all SQL keywords that are not supported as table/column/index name, in addition to the SQL-92 keywords. public  int getSQLStateType()      Gets the SQL State type. public  String getSchemaTerm()      Returns the term for "schema". public  ResultSet getSchemas()      Gets the list of schemas. public  ResultSet getSchemas(String catalog, String schemaPattern)      [Not supported] Gets the list of schemas. public  String getSearchStringEscape()      Returns the default escape character for LIKE. public  String getStringFunctions()      Returns the list of string functions supported by this database. public  ResultSet getSuperTables(String catalog, String schemaPattern, String tableNamePattern)      Get the list of super tables of a table. public  ResultSet getSuperTypes(String catalog, String schemaPattern, String typeNamePattern)      public  String getSystemFunctions()      Returns the list of system functions supported by this database. public  ResultSet getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern)      Gets the list of table privileges. public  ResultSet getTableTypes()      Gets the list of table types. public  ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types)      Gets the list of tables in the database. public  String getTimeDateFunctions()      Returns the list of date and time functions supported by this database. public  ResultSet getTypeInfo()      Gets the list of data types. public  ResultSet getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types)      Gets the list of user defined data types. public  String getURL()      Returns the database URL for this connection. public  String getUserName()      Returns the user name as passed to DriverManager.getConnection(url, user, password). public  ResultSet getVersionColumns(String catalog, String schema, String tableName)      Get the list of columns that are update when any value is updated. public  boolean insertsAreDetected(int type)      Returns whether inserts are detected. public  boolean isCatalogAtStart()      Returns whether the catalog is at the beginning. public  boolean isReadOnly()      Returns the same as Connection.isReadOnly(). public  boolean locatorsUpdateCopy()      Does the database make a copy before updating. public  boolean nullPlusNonNullIsNull()      Returns whether NULL+1 is NULL or not. public  boolean nullsAreSortedAtEnd()      Checks is NULL values are sorted at the end (no matter if ASC or DESC is used). public  boolean nullsAreSortedAtStart()      Checks is NULL values are sorted at the beginning (no matter if ASC or DESC is used). public  boolean nullsAreSortedHigh()      Checks is NULL values are sorted high (bigger than any non-null values). public  boolean nullsAreSortedLow()      Checks is NULL values are sorted low (smaller than any non-null values). public  boolean othersDeletesAreVisible(int type)      Returns whether other deletes are visible. public  boolean othersInsertsAreVisible(int type)      Returns whether other inserts are visible. public  boolean othersUpdatesAreVisible(int type)      Returns whether other updates are visible. public  boolean ownDeletesAreVisible(int type)      Returns whether own deletes are visible. public  boolean ownInsertsAreVisible(int type)      Returns whether own inserts are visible. public  boolean ownUpdatesAreVisible(int type)      Returns whether own updates are visible. public  boolean storesLowerCaseIdentifiers()      Checks if for CREATE TABLE Test(ID INT), getTables returns test as the table name. public  boolean storesLowerCaseQuotedIdentifiers()      Checks if for CREATE TABLE "Test"(ID INT), getTables returns test as the table name. public  boolean storesMixedCaseIdentifiers()      Checks if for CREATE TABLE Test(ID INT), getTables returns Test as the table name. public  boolean storesMixedCaseQuotedIdentifiers()      Checks if for CREATE TABLE "Test"(ID INT), getTables returns Test as the table name. public  boolean storesUpperCaseIdentifiers()      Checks if for CREATE TABLE Test(ID INT), getTables returns TEST as the table name. public  boolean storesUpperCaseQuotedIdentifiers()      Checks if for CREATE TABLE "Test"(ID INT), getTables returns TEST as the table name. public  boolean supportsANSI92EntryLevelSQL()      Returns whether SQL-92 entry level grammar is supported. public  boolean supportsANSI92FullSQL()      Returns whether SQL-92 full level grammar is supported. public  boolean supportsANSI92IntermediateSQL()      Returns whether SQL-92 intermediate level grammar is supported. public  boolean supportsAlterTableWithAddColumn()      Returns whether alter table with add column is supported. public  boolean supportsAlterTableWithDropColumn()      Returns whether alter table with drop column is supported. public  boolean supportsBatchUpdates()      Returns whether batch updates are supported. public  boolean supportsCatalogsInDataManipulation()      Returns whether the catalog name in INSERT, UPDATE, DELETE is supported. public  boolean supportsCatalogsInIndexDefinitions()      Returns whether the catalog name in CREATE INDEX is supported. public  boolean supportsCatalogsInPrivilegeDefinitions()      Returns whether the catalog name in GRANT is supported. public  boolean supportsCatalogsInProcedureCalls()      Returns whether the catalog name in procedure calls is supported. public  boolean supportsCatalogsInTableDefinitions()      Returns whether the catalog name in CREATE TABLE is supported. public  boolean supportsColumnAliasing()      Returns whether column aliasing is supported. public  boolean supportsConvert()      Returns whether CONVERT is supported. public  boolean supportsConvert(int fromType, int toType)      Returns whether CONVERT is supported for one datatype to another. public  boolean supportsCoreSQLGrammar()      Returns whether ODBC Core SQL grammar is supported. public  boolean supportsCorrelatedSubqueries()      Returns whether correlated subqueries are supported. public  boolean supportsDataDefinitionAndDataManipulationTransactions()      Returns whether data manipulation and CREATE/DROP is supported in transactions. public  boolean supportsDataManipulationTransactionsOnly()      Returns whether only data manipulations are supported in transactions. public  boolean supportsDifferentTableCorrelationNames()      Returns whether table correlation names (table alias) are restricted to be different than table names. public  boolean supportsExpressionsInOrderBy()      Returns whether expression in ORDER BY are supported. public  boolean supportsExtendedSQLGrammar()      Returns whether ODBC Extended SQL grammar is supported. public  boolean supportsFullOuterJoins()      Returns whether full outer joins are supported. public  boolean supportsGetGeneratedKeys()      Does the database support getGeneratedKeys. public  boolean supportsGroupBy()      Returns whether GROUP BY is supported. public  boolean supportsGroupByBeyondSelect()      Checks whether a GROUP BY clause can use columns that are not in the SELECT clause, provided that it specifies all the columns in the SELECT clause. public  boolean supportsGroupByUnrelated()      Returns whether GROUP BY is supported if the column is not in the SELECT list. public  boolean supportsIntegrityEnhancementFacility()      Returns whether referential integrity is supported. public  boolean supportsLikeEscapeClause()      Returns whether LIKE... public  boolean supportsLimitedOuterJoins()      Returns whether limited outer joins are supported. public  boolean supportsMinimumSQLGrammar()      Returns whether ODBC Minimum SQL grammar is supported. public  boolean supportsMixedCaseIdentifiers()      Checks if for CREATE TABLE Test(ID INT), getTables returns Test as the table name. public  boolean supportsMixedCaseQuotedIdentifiers()      Checks if a table created with CREATE TABLE "Test"(ID INT) is a different table than a table created with CREATE TABLE TEST(ID INT). public  boolean supportsMultipleOpenResults()      Does the database support multiple open result sets. public  boolean supportsMultipleResultSets()      Returns whether multiple result sets are supported. public  boolean supportsMultipleTransactions()      Returns whether multiple transactions (on different connections) are supported. public  boolean supportsNamedParameters()      Does the database support named parameters. public  boolean supportsNonNullableColumns()      Returns whether columns with NOT NULL are supported. public  boolean supportsOpenCursorsAcrossCommit()      Returns whether open result sets across commits are supported. public  boolean supportsOpenCursorsAcrossRollback()      Returns whether open result sets across rollback are supported. public  boolean supportsOpenStatementsAcrossCommit()      Returns whether open statements across commit are supported. public  boolean supportsOpenStatementsAcrossRollback()      Returns whether open statements across rollback are supported. public  boolean supportsOrderByUnrelated()      Returns whether ORDER BY is supported if the column is not in the SELECT list. public  boolean supportsOuterJoins()      Returns whether outer joins are supported. public  boolean supportsPositionedDelete()      Returns whether positioned deletes are supported. public  boolean supportsPositionedUpdate()      Returns whether positioned updates are supported. public  boolean supportsResultSetConcurrency(int type, int concurrency)      Returns whether a specific result set concurrency is supported. public  boolean supportsResultSetHoldability(int holdability)      Does this database supports a result set holdability. public  boolean supportsResultSetType(int type)      Returns whether a specific result set type is supported. public  boolean supportsSavepoints()      Does the database support savepoints. public  boolean supportsSchemasInDataManipulation()      Returns whether the schema name in INSERT, UPDATE, DELETE is supported. public  boolean supportsSchemasInIndexDefinitions()      Returns whether the schema name in CREATE INDEX is supported. public  boolean supportsSchemasInPrivilegeDefinitions()      Returns whether the schema name in GRANT is supported. public  boolean supportsSchemasInProcedureCalls()      Returns whether the schema name in procedure calls is supported. public  boolean supportsSchemasInTableDefinitions()      Returns whether the schema name in CREATE TABLE is supported. public  boolean supportsSelectForUpdate()      Returns whether SELECT ... public  boolean supportsStatementPooling()      Does the database support statement pooling. public  boolean supportsStoredFunctionsUsingCallSyntax()      Returns whether the database supports calling functions using the call syntax. public  boolean supportsStoredProcedures()      Returns whether stored procedures are supported. public  boolean supportsSubqueriesInComparisons()      Returns whether subqueries (SELECT) in comparisons are supported. public  boolean supportsSubqueriesInExists()      Returns whether SELECT in EXISTS is supported. public  boolean supportsSubqueriesInIns()      Returns whether IN(SELECT...) is supported. public  boolean supportsSubqueriesInQuantifieds()      Returns whether subqueries in quantified expression are supported. public  boolean supportsTableCorrelationNames()      Returns whether table correlation names (table alias) are supported. public  boolean supportsTransactionIsolationLevel(int level)      Returns whether a specific transaction isolation level is supported. public  boolean supportsTransactions()      Returns whether transactions are supported. public  boolean supportsUnion()      Returns whether UNION SELECT is supported. public  boolean supportsUnionAll()      Returns whether UNION ALL SELECT is supported. public  String toString()      public  boolean updatesAreDetected(int type)      Returns whether updates are detected. public  boolean usesLocalFilePerTable()      Checks if this database use one file per table. public  boolean usesLocalFiles()      Checks if this database store data in local files. Constructor Detail JdbcDatabaseMetaData JdbcDatabaseMetaData(JdbcConnection conn, Trace trace, int id)(Code) Method Detail allProceduresAreCallable public boolean allProceduresAreCallable()(Code) Checks if all procedures callable. true allTablesAreSelectable public boolean allTablesAreSelectable()(Code) Checks if it possible to query all tables returned by getTables. true autoCommitFailureClosesAllResultSets public boolean autoCommitFailureClosesAllResultSets() throws SQLException(Code) Returns whether an exception while auto commit is on closes all result sets. false dataDefinitionCausesTransactionCommit public boolean dataDefinitionCausesTransactionCommit()(Code) Returns whether CREATE/DROP commit an open transaction. true dataDefinitionIgnoredInTransactions public boolean dataDefinitionIgnoredInTransactions()(Code) Returns whether CREATE/DROP do not affect transactions. false deletesAreDetected public boolean deletesAreDetected(int type)(Code) Returns whether deletes are detected. false doesMaxRowSizeIncludeBlobs public boolean doesMaxRowSizeIncludeBlobs()(Code) Returns whether the maximum row size includes blobs. false getAttributes public ResultSet getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern) throws SQLException(Code) [Not supported] getBestRowIdentifier public ResultSet getBestRowIdentifier(String catalog, String schema, String tableName, int scope, boolean nullable) throws SQLException(Code) Gets the list of columns that best identifier a row in a table. The list is ordered by SCOPE. 1 SCOPE (short) scope of result (always bestRowSession) 2 COLUMN_NAME (String) column name 3 DATA_TYPE (short) SQL data type, see also java.sql.Types 4 TYPE_NAME (String) type name 5 COLUMN_SIZE (int) precision 6 BUFFER_LENGTH (int) unused 7 DECIMAL_DIGITS (short) scale 8 PSEUDO_COLUMN (short) (always bestRowNotPseudo) Parameters:   catalog - null (to get all objects) or the catalog name Parameters:   schema - schema name (must be specified) Parameters:   tableName - table name (must be specified) Parameters:   scope - ignored Parameters:   nullable - ignored the primary key index throws:   SQLException - if the connection is closed getCatalogSeparator public String getCatalogSeparator()(Code) Returns the catalog separator. "." getCatalogTerm public String getCatalogTerm()(Code) Returns the term for "catalog". "catalog" getCatalogs public ResultSet getCatalogs() throws SQLException(Code) Gets the list of catalogs. The result set is sorted by TABLE_CAT. 1 TABLE_CAT (String) catalog name the catalog list throws:   SQLException - if the connection is closed getClientInfoProperties public ResultSet getClientInfoProperties() throws SQLException(Code) [Not supported] Returns the client info properties. getColumnPrivileges public ResultSet getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) throws SQLException(Code) Gets the list of column privileges. The result set is sorted by COLUMN_NAME and PRIVILEGE 1 TABLE_CAT (String) table catalog 2 TABLE_SCHEM (String) table schema 3 TABLE_NAME (String) table name 4 COLUMN_NAME (String) column name 5 GRANTOR (String) grantor of access 6 GRANTEE (String) grantee of access 7 PRIVILEGE (String) SELECT, INSERT, UPDATE, DELETE or REFERENCES (only one per row) 8 IS_GRANTABLE (String) YES means the grantee can grant access to others Parameters:   catalog - null (to get all objects) or the catalog name Parameters:   schema - null (to get all objects) or a schema name (uppercase forunquoted names) Parameters:   table - a table name (uppercase for unquoted names) Parameters:   columnNamePattern - null (to get all objects) or a column name(uppercase for unquoted names) the list of privileges throws:   SQLException - if the connection is closed getColumns public ResultSet getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SQLException(Code) Gets the list of columns. The result set is sorted by TABLE_SCHEM, TABLE_NAME, and ORDINAL_POSITION. 1 TABLE_CAT (String) table catalog 2 TABLE_SCHEM (String) table schema 3 TABLE_NAME (String) table name 4 COLUMN_NAME (String) column name 5 DATA_TYPE (short) data type (see java.sql.Types) 6 TYPE_NAME (String) data type name ("INTEGER", "VARCHAR",...) 7 COLUMN_SIZE (int) precision 8 BUFFER_LENGTH (int) unused 9 DECIMAL_DIGITS (int) scale (0 for INTEGER and VARCHAR) 10 NUM_PREC_RADIX (int) radix (always 10) 11 NULLABLE (int) nullable or not. columnNoNulls or columnNullable 12 REMARKS (String) comment (always empty) 13 COLUMN_DEF (String) default value 14 SQL_DATA_TYPE (int) unused 15 SQL_DATETIME_SUB (int) unused 16 CHAR_OCTET_LENGTH (int) unused 17 ORDINAL_POSITION (int) the column index (1,2,...) 18 IS_NULLABLE (String) "NO" or "YES" Parameters:   catalog - null (to get all objects) or the catalog name Parameters:   schemaPattern - null (to get all objects) or a schema name(uppercase for unquoted names) Parameters:   tableNamePattern - null (to get all objects) or a table name(uppercase for unquoted names) Parameters:   columnNamePattern - null (to get all objects) or a column name(uppercase for unquoted names) the list of columns throws:   SQLException - if the connection is closed getConnection public Connection getConnection()(Code) Returns the connection that created this object. the connection getCrossReference public ResultSet getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) throws SQLException(Code) Gets the list of foreign key columns that references a table, as well as the list of primary key columns that are references by a table. The result set is sorted by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, FK_NAME, KEY_SEQ. 1 PKTABLE_CAT (String) primary catalog 2 PKTABLE_SCHEM (String) primary schema 3 PKTABLE_NAME (String) primary table 4 PKCOLUMN_NAME (String) primary column 5 FKTABLE_CAT (String) foreign catalog 6 FKTABLE_SCHEM (String) foreign schema 7 FKTABLE_NAME (String) foreign table 8 FKCOLUMN_NAME (String) foreign column 9 KEY_SEQ (short) sequence number (1,2,...) 10 UPDATE_RULE (short) action on update (see DatabaseMetaData.importedKey...) 11 DELETE_RULE (short) action on delete (see DatabaseMetaData.importedKey...) 12 FK_NAME (String) foreign key name 13 PK_NAME (String) primary key name 14 DEFERRABILITY (short) deferrable or not (always importedKeyNotDeferrable) Parameters:   primaryCatalog - ignored Parameters:   primarySchema - the schema name of the primary table (must bespecified) Parameters:   primaryTable - the name of the primary table (must be specified) Parameters:   foreignCatalog - ignored Parameters:   foreignSchema - the schema name of the foreign table (must bespecified) Parameters:   foreignTable - the name of the foreign table (must be specified) the result set throws:   SQLException - if the connection is closed getDatabaseMajorVersion public int getDatabaseMajorVersion()(Code) Gets the major version of the database. the major version getDatabaseMinorVersion public int getDatabaseMinorVersion()(Code) Gets the minor version of the database. the minor version getDatabaseProductName public String getDatabaseProductName()(Code) Gets the database product name. the product name getDatabaseProductVersion public String getDatabaseProductVersion()(Code) Gets the product version of the database. the product version getDefaultTransactionIsolation public int getDefaultTransactionIsolation()(Code) Returns the default transaction isolation level. Connection.TRANSACTION_READ_COMMITTED getDriverMajorVersion public int getDriverMajorVersion()(Code) Returns the major version of this driver. the major version number getDriverMinorVersion public int getDriverMinorVersion()(Code) Returns the minor version of this driver. the minor version number getDriverName public String getDriverName()(Code) Gets the name of the JDBC driver. the driver name getDriverVersion public String getDriverVersion()(Code) Gets the version number of the driver in the format [MajorVersion].[MinorVersion]. the version number getExportedKeys public ResultSet getExportedKeys(String catalog, String schema, String tableName) throws SQLException(Code) Gets the list of foreign key columns that reference a table. The result set is sorted by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, FK_NAME, KEY_SEQ. 1 PKTABLE_CAT (String) primary catalog 2 PKTABLE_SCHEM (String) primary schema 3 PKTABLE_NAME (String) primary table 4 PKCOLUMN_NAME (String) primary column 5 FKTABLE_CAT (String) foreign catalog 6 FKTABLE_SCHEM (String) foreign schema 7 FKTABLE_NAME (String) foreign table 8 FKCOLUMN_NAME (String) foreign column 9 KEY_SEQ (short) sequence number (1,2,...) 10 UPDATE_RULE (short) action on update (see DatabaseMetaData.importedKey...) 11 DELETE_RULE (short) action on delete (see DatabaseMetaData.importedKey...) 12 FK_NAME (String) foreign key name 13 PK_NAME (String) primary key name 14 DEFERRABILITY (short) deferrable or not (always importedKeyNotDeferrable) Parameters:   catalog - null (to get all objects) or the catalog name Parameters:   schema - the schema name of the primary table Parameters:   tableName - the name of the primary table the result set throws:   SQLException - if the connection is closed getExtraNameCharacters public String getExtraNameCharacters()(Code) Returns the characters that are allowed for identifiers in addiction to A-Z, a-z, 0-9 and '_'. an empty String ("") getFunctionColumns public ResultSet getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern) throws SQLException(Code) [Not supported] Gets the list of function columns. getFunctions public ResultSet getFunctions(String arg0, String arg1, String arg2) throws SQLException(Code) [Not supported] Gets the list of functions. getIdentifierQuoteString public String getIdentifierQuoteString()(Code) Returns the string used to quote identifiers. a double quote getImportedKeys public ResultSet getImportedKeys(String catalog, String schema, String tableName) throws SQLException(Code) Gets the list of primary key columns that are referenced by a table. The result set is sorted by PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, FK_NAME, KEY_SEQ. 1 PKTABLE_CAT (String) primary catalog 2 PKTABLE_SCHEM (String) primary schema 3 PKTABLE_NAME (String) primary table 4 PKCOLUMN_NAME (String) primary column 5 FKTABLE_CAT (String) foreign catalog 6 FKTABLE_SCHEM (String) foreign schema 7 FKTABLE_NAME (String) foreign table 8 FKCOLUMN_NAME (String) foreign column 9 KEY_SEQ (short) sequence number (1, 2, ...) 10 UPDATE_RULE (short) action on update (see DatabaseMetaData.importedKey...) 11 DELETE_RULE (short) action on delete (see DatabaseMetaData.importedKey...) 12 FK_NAME (String) foreign key name 13 PK_NAME (String) primary key name 14 DEFERRABILITY (short) deferrable or not (always importedKeyNotDeferrable) Parameters:   catalog - null (to get all objects) or the catalog name Parameters:   schema - the schema name of the foreign table Parameters:   tableName - the name of the foreign table the result set throws:   SQLException - if the connection is closed getIndexInfo public ResultSet getIndexInfo(String catalog, String schema, String tableName, boolean unique, boolean approximate) throws SQLException(Code) Gets the list of indexes for this database. The primary key index (if there is one) is also listed, with the name PRIMARY_KEY. The result set is sorted by NON_UNIQUE ('false' first), TYPE, TABLE_SCHEM, INDEX_NAME, and ORDINAL_POSITION. 1 TABLE_CAT (String) table catalog 2 TABLE_SCHEM (String) table schema 3 TABLE_NAME (String) table name 4 NON_UNIQUE (boolean) 'false' for unique, 'true' for non-unique 5 INDEX_QUALIFIER (String) index catalog 6 INDEX_NAME (String) index name 7 TYPE (short) the index type (always tableIndexOther) 8 ORDINAL_POSITION (short) column index (1, 2, ...) 9 COLUMN_NAME (String) column name 10 ASC_OR_DESC (String) ascending or descending (always 'A') 11 CARDINALITY (int) numbers of unique values 12 PAGES (int) number of pages use (always 0) 13 FILTER_CONDITION (String) filter condition (always empty) 14 SORT_TYPE (int) the sort type bit map: 1=DESCENDING, 2=NULLS_FIRST, 4=NULLS_LAST Parameters:   catalog - null (to get all objects) or the catalog name Parameters:   schema - schema name (must be specified) Parameters:   tableName - table name (must be specified) Parameters:   unique - only unique indexes Parameters:   approximate - is ignored the list of indexes and columns throws:   SQLException - if the connection is closed getJDBCMajorVersion public int getJDBCMajorVersion() throws SQLException(Code) Gets the major version of the supported JDBC API. the major version getJDBCMinorVersion public int getJDBCMinorVersion() throws SQLException(Code) Gets the minor version of the supported JDBC API. the minor version getMaxBinaryLiteralLength public int getMaxBinaryLiteralLength()(Code) Returns the maximum length for hex values (characters). 0 for limit is unknown getMaxCatalogNameLength public int getMaxCatalogNameLength()(Code) Returns the maximum length for a catalog name. 0 for limit is unknown getMaxCharLiteralLength public int getMaxCharLiteralLength()(Code) Returns the maximum length for literals. 0 for limit is unknown getMaxColumnNameLength public int getMaxColumnNameLength()(Code) Returns the maximum length for column names. 0 for limit is unknown getMaxColumnsInGroupBy public int getMaxColumnsInGroupBy()(Code) Returns the maximum number of columns in GROUP BY. 0 for limit is unknown getMaxColumnsInIndex public int getMaxColumnsInIndex()(Code) Returns the maximum number of columns in CREATE INDEX. 0 for limit is unknown getMaxColumnsInOrderBy public int getMaxColumnsInOrderBy()(Code) Returns the maximum number of columns in ORDER BY. 0 for limit is unknown getMaxColumnsInSelect public int getMaxColumnsInSelect()(Code) Returns the maximum number of columns in SELECT. 0 for limit is unknown getMaxColumnsInTable public int getMaxColumnsInTable()(Code) Returns the maximum number of columns in CREATE TABLE. 0 for limit is unknown getMaxConnections public int getMaxConnections()(Code) Returns the maximum number of open connection. 0 for limit is unknown getMaxCursorNameLength public int getMaxCursorNameLength()(Code) Returns the maximum length for a cursor name. 0 for limit is unknown getMaxIndexLength public int getMaxIndexLength()(Code) Returns the maximum length for an index (in bytes). 0 for limit is unknown getMaxProcedureNameLength public int getMaxProcedureNameLength()(Code) Returns the maximum length for a procedure name. 0 for limit is unknown getMaxRowSize public int getMaxRowSize()(Code) Returns the maximum size of a row (in bytes). 0 for limit is unknown getMaxSchemaNameLength public int getMaxSchemaNameLength()(Code) Returns the maximum length for a schema name. 0 for limit is unknown getMaxStatementLength public int getMaxStatementLength()(Code) Returns the maximum length of a statement. 0 for limit is unknown getMaxStatements public int getMaxStatements()(Code) Returns the maximum number of open statements. 0 for limit is unknown getMaxTableNameLength public int getMaxTableNameLength()(Code) Returns the maximum length for a table name. 0 for limit is unknown getMaxTablesInSelect public int getMaxTablesInSelect()(Code) Returns the maximum number of tables in a SELECT. 0 for limit is unknown getMaxUserNameLength public int getMaxUserNameLength()(Code) Returns the maximum length for a user name. 0 for limit is unknown getNumericFunctions public String getNumericFunctions() throws SQLException(Code) Returns the list of numeric functions supported by this database. the list getPrimaryKeys public ResultSet getPrimaryKeys(String catalog, String schema, String tableName) throws SQLException(Code) Gets the primary key columns for a table. The result set is sorted by TABLE_SCHEM, and COLUMN_NAME (and not by KEY_SEQ). 1 TABLE_CAT (String) table catalog 2 TABLE_SCHEM (String) table schema 3 TABLE_NAME (String) table name 4 COLUMN_NAME (String) column name 5 KEY_SEQ (short) the column index of this column (1,2,...) 6 PK_NAME (String) always 'PRIMARY_KEY' Parameters:   catalog - null (to get all objects) or the catalog name Parameters:   schema - schema name (must be specified) Parameters:   tableName - table name (must be specified) the list of primary key columns throws:   SQLException - if the connection is closed getProcedureColumns public ResultSet getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) throws SQLException(Code) Gets the list of procedure columns. 1 PROCEDURE_CAT (String) catalog 2 PROCEDURE_SCHEM (String) schema 3 PROCEDURE_NAME (String) name 4 COLUMN_NAME (String) column name 5 COLUMN_TYPE (short) column type 6 DATA_TYPE (short) sql type 7 TYPE_NAME (String) type name 8 PRECISION (int) precision 9 LENGTH (int) length 10 SCALE (short) scale 11 RADIX (int) always 10 12 NULLABLE (short) nullable 13 REMARKS (String) description throws:   SQLException - if the connection is closed getProcedureTerm public String getProcedureTerm()(Code) Returns the term for "procedure". "procedure" getProcedures public ResultSet getProcedures(String catalog, String schemaPattern, String procedureNamePattern) throws SQLException(Code) Gets the list of procedures. The result set is sorted by PROCEDURE_SCHEM, and PROCEDURE_NAME. 1 PROCEDURE_CAT (String) catalog 2 PROCEDURE_SCHEM (String) schema 3 PROCEDURE_NAME (String) name 4 NUM_INPUT_PARAMS (int) for future use, always 0 5 NUM_OUTPUT_PARAMS (int) for future use, always 0 6 NUM_RESULT_SETS (int) for future use, always 0 7 REMARKS (String) description 8 PROCEDURE_TYPE (short) if this procedure returns a result (procedureNoResult or procedureReturnsResult) an empty result set throws:   SQLException - if the connection is closed getResultSetHoldability public int getResultSetHoldability()(Code) Gets the result set holdability. ResultSet.CLOSE_CURSORS_AT_COMMIT getSQLKeywords public String getSQLKeywords()(Code) Gets the comma-separated list of all SQL keywords that are not supported as table/column/index name, in addition to the SQL-92 keywords. a list with the keywords getSQLStateType public int getSQLStateType()(Code) Gets the SQL State type. DatabaseMetaData.sqlStateSQL99 getSchemaTerm public String getSchemaTerm()(Code) Returns the term for "schema". "schema" getSchemas public ResultSet getSchemas() throws SQLException(Code) Gets the list of schemas. The result set is sorted by TABLE_SCHEM. 1 TABLE_SCHEM (String) schema name 2 TABLE_CATALOG (String) catalog name 3 IS_DEFAULT (boolean) if this is the default schema the schema list throws:   SQLException - if the connection is closed getSchemas public ResultSet getSchemas(String catalog, String schemaPattern) throws SQLException(Code) [Not supported] Gets the list of schemas. getSearchStringEscape public String getSearchStringEscape()(Code) Returns the default escape character for LIKE. the character '\' getStringFunctions public String getStringFunctions() throws SQLException(Code) Returns the list of string functions supported by this database. the list getSuperTables public ResultSet getSuperTables(String catalog, String schemaPattern, String tableNamePattern) throws SQLException(Code) Get the list of super tables of a table. This method currently returns an empty result set. 1 TABLE_CAT (String) table catalog 2 TABLE_SCHEM (String) table schema 3 TABLE_NAME (String) table name 4 SUPERTABLE_NAME (String) the name of the super table an empty result set getSuperTypes public ResultSet getSuperTypes(String catalog, String schemaPattern, String typeNamePattern) throws SQLException(Code) [Not supported] getSystemFunctions public String getSystemFunctions() throws SQLException(Code) Returns the list of system functions supported by this database. the list getTablePrivileges public ResultSet getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern) throws SQLException(Code) Gets the list of table privileges. The result set is sorted by TABLE_SCHEM, TABLE_NAME, and PRIVILEGE. 1 TABLE_CAT (String) table catalog 2 TABLE_SCHEM (String) table schema 3 TABLE_NAME (String) table name 4 GRANTOR (String) grantor of access 5 GRANTEE (String) grantee of access 6 PRIVILEGE (String) SELECT, INSERT, UPDATE, DELETE or REFERENCES (only one per row) 7 IS_GRANTABLE (String) YES means the grantee can grant access to others Parameters:   catalog - null (to get all objects) or the catalog name Parameters:   schemaPattern - null (to get all objects) or a schema name(uppercase for unquoted names) Parameters:   tableNamePattern - null (to get all objects) or a table name(uppercase for unquoted names) the list of privileges throws:   SQLException - if the connection is closed getTableTypes public ResultSet getTableTypes() throws SQLException(Code) Gets the list of table types. This call returns a result set with three records: "SYSTEM TABLE", "TABLE", "and "VIEW". The result set is sorted by TABLE_TYPE. 1 TABLE_TYPE (String) table type the table types throws:   SQLException - if the connection is closed getTables public ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) throws SQLException(Code) Gets the list of tables in the database. The result set is sorted by TABLE_TYPE, TABLE_SCHEM, and TABLE_NAME. 1 TABLE_CAT (String) table catalog 2 TABLE_SCHEM (String) table schema 3 TABLE_NAME (String) table name 4 TABLE_TYPE (String) table type 5 REMARKS (String) comment 6 SQL (String) the create table statement or NULL for systems tables Parameters:   catalog - null (to get all objects) or the catalog name Parameters:   schemaPattern - null (to get all objects) or a schema name(uppercase for unquoted names) Parameters:   tableNamePattern - null (to get all objects) or a table name(uppercase for unquoted names) Parameters:   types - null or a list of table types the list of columns throws:   SQLException - if the connection is closed getTimeDateFunctions public String getTimeDateFunctions() throws SQLException(Code) Returns the list of date and time functions supported by this database. the list getTypeInfo public ResultSet getTypeInfo() throws SQLException(Code) Gets the list of data types. The result set is sorted by DATA_TYPE and afterwards by how closely the data type maps to the corresponding JDBC SQL type (best match first). 1 TYPE_NAME (String) type name 2 DATA_TYPE (short) SQL data type - see also java.sql.Types 3 PRECISION (int) maximum precision 4 LITERAL_PREFIX (String) prefix used to quote a literal 5 LITERAL_SUFFIX (String) suffix used to quote a literal 6 CREATE_PARAMS (String) parameters used (may be null) 7 NULLABLE (short) typeNoNulls (NULL not allowed) or typeNullable 8 CASE_SENSITIVE (boolean) case sensitive 9 SEARCHABLE (short) typeSearchable 10 UNSIGNED_ATTRIBUTE (boolean) unsigned 11 FIXED_PREC_SCALE (boolean) fixed precision 12 AUTO_INCREMENT (boolean) auto increment 13 LOCAL_TYPE_NAME (String) localized version of the data type 14 MINIMUM_SCALE (short) minimum scale 15 MAXIMUM_SCALE (short) maximum scale 16 SQL_DATA_TYPE (int) unused 17 SQL_DATETIME_SUB (int) unused 18 NUM_PREC_RADIX (int) 2 for binary, 10 for decimal the list of data types throws:   SQLException - if the connection is closed getUDTs public ResultSet getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) throws SQLException(Code) Gets the list of user defined data types. This call returns an empty result set. 1 TYPE_CAT (String) catalog 2 TYPE_SCHEM (String) schema 3 TYPE_NAME (String) type name 4 CLASS_NAME (String) Java class 5 DATA_TYPE (short) SQL Type - see also java.sql.Types 6 REMARKS (String) description 7 BASE_TYPE (short) base type - see also java.sql.Types Parameters:   catalog - ignored Parameters:   schemaPattern - ignored Parameters:   typeNamePattern - ignored Parameters:   types - ignored an empty result set throws:   SQLException - if the connection is closed getURL public String getURL() throws SQLException(Code) Returns the database URL for this connection. the url getUserName public String getUserName() throws SQLException(Code) Returns the user name as passed to DriverManager.getConnection(url, user, password). the user name getVersionColumns public ResultSet getVersionColumns(String catalog, String schema, String tableName) throws SQLException(Code) Get the list of columns that are update when any value is updated. 1 SCOPE (int) not used 2 COLUMN_NAME (String) column name 3 DATA_TYPE (int) SQL data type - see also java.sql.Types 4 TYPE_NAME (String) data type name 5 COLUMN_SIZE (int) precision 6 BUFFER_LENGTH (int) length (bytes) 7 DECIMAL_DIGITS (int) scale 8 PSEUDO_COLUMN (int) is this column a pseudo column Parameters:   catalog - null (to get all objects) or the catalog name Parameters:   schema - schema name (must be specified) Parameters:   tableName - table name (must be specified) an empty result set throws:   SQLException - if the connection is closed insertsAreDetected public boolean insertsAreDetected(int type)(Code) Returns whether inserts are detected. false isCatalogAtStart public boolean isCatalogAtStart()(Code) Returns whether the catalog is at the beginning. true isReadOnly public boolean isReadOnly() throws SQLException(Code) Returns the same as Connection.isReadOnly(). if read only optimization is switched on locatorsUpdateCopy public boolean locatorsUpdateCopy()(Code) Does the database make a copy before updating. false nullPlusNonNullIsNull public boolean nullPlusNonNullIsNull()(Code) Returns whether NULL+1 is NULL or not. true nullsAreSortedAtEnd public boolean nullsAreSortedAtEnd()(Code) Checks is NULL values are sorted at the end (no matter if ASC or DESC is used). false nullsAreSortedAtStart public boolean nullsAreSortedAtStart()(Code) Checks is NULL values are sorted at the beginning (no matter if ASC or DESC is used). false nullsAreSortedHigh public boolean nullsAreSortedHigh()(Code) Checks is NULL values are sorted high (bigger than any non-null values). false nullsAreSortedLow public boolean nullsAreSortedLow()(Code) Checks is NULL values are sorted low (smaller than any non-null values). true othersDeletesAreVisible public boolean othersDeletesAreVisible(int type)(Code) Returns whether other deletes are visible. false othersInsertsAreVisible public boolean othersInsertsAreVisible(int type)(Code) Returns whether other inserts are visible. false othersUpdatesAreVisible public boolean othersUpdatesAreVisible(int type)(Code) Returns whether other updates are visible. false ownDeletesAreVisible public boolean ownDeletesAreVisible(int type)(Code) Returns whether own deletes are visible. false ownInsertsAreVisible public boolean ownInsertsAreVisible(int type)(Code) Returns whether own inserts are visible. false ownUpdatesAreVisible public boolean ownUpdatesAreVisible(int type)(Code) Returns whether own updates are visible. false storesLowerCaseIdentifiers public boolean storesLowerCaseIdentifiers()(Code) Checks if for CREATE TABLE Test(ID INT), getTables returns test as the table name. false storesLowerCaseQuotedIdentifiers public boolean storesLowerCaseQuotedIdentifiers()(Code) Checks if for CREATE TABLE "Test"(ID INT), getTables returns test as the table name. false storesMixedCaseIdentifiers public boolean storesMixedCaseIdentifiers()(Code) Checks if for CREATE TABLE Test(ID INT), getTables returns Test as the table name. false storesMixedCaseQuotedIdentifiers public boolean storesMixedCaseQuotedIdentifiers()(Code) Checks if for CREATE TABLE "Test"(ID INT), getTables returns Test as the table name. true storesUpperCaseIdentifiers public boolean storesUpperCaseIdentifiers()(Code) Checks if for CREATE TABLE Test(ID INT), getTables returns TEST as the table name. true storesUpperCaseQuotedIdentifiers public boolean storesUpperCaseQuotedIdentifiers()(Code) Checks if for CREATE TABLE "Test"(ID INT), getTables returns TEST as the table name. false supportsANSI92EntryLevelSQL public boolean supportsANSI92EntryLevelSQL()(Code) Returns whether SQL-92 entry level grammar is supported. true supportsANSI92FullSQL public boolean supportsANSI92FullSQL()(Code) Returns whether SQL-92 full level grammar is supported. false supportsANSI92IntermediateSQL public boolean supportsANSI92IntermediateSQL()(Code) Returns whether SQL-92 intermediate level grammar is supported. false supportsAlterTableWithAddColumn public boolean supportsAlterTableWithAddColumn()(Code) Returns whether alter table with add column is supported. true supportsAlterTableWithDropColumn public boolean supportsAlterTableWithDropColumn()(Code) Returns whether alter table with drop column is supported. true supportsBatchUpdates public boolean supportsBatchUpdates()(Code) Returns whether batch updates are supported. true supportsCatalogsInDataManipulation public boolean supportsCatalogsInDataManipulation()(Code) Returns whether the catalog name in INSERT, UPDATE, DELETE is supported. true supportsCatalogsInIndexDefinitions public boolean supportsCatalogsInIndexDefinitions()(Code) Returns whether the catalog name in CREATE INDEX is supported. true supportsCatalogsInPrivilegeDefinitions public boolean supportsCatalogsInPrivilegeDefinitions()(Code) Returns whether the catalog name in GRANT is supported. true supportsCatalogsInProcedureCalls public boolean supportsCatalogsInProcedureCalls()(Code) Returns whether the catalog name in procedure calls is supported. false supportsCatalogsInTableDefinitions public boolean supportsCatalogsInTableDefinitions()(Code) Returns whether the catalog name in CREATE TABLE is supported. true supportsColumnAliasing public boolean supportsColumnAliasing()(Code) Returns whether column aliasing is supported. true supportsConvert public boolean supportsConvert()(Code) Returns whether CONVERT is supported. true supportsConvert public boolean supportsConvert(int fromType, int toType)(Code) Returns whether CONVERT is supported for one datatype to another. true supportsCoreSQLGrammar public boolean supportsCoreSQLGrammar()(Code) Returns whether ODBC Core SQL grammar is supported. true supportsCorrelatedSubqueries public boolean supportsCorrelatedSubqueries()(Code) Returns whether correlated subqueries are supported. true supportsDataDefinitionAndDataManipulationTransactions public boolean supportsDataDefinitionAndDataManipulationTransactions()(Code) Returns whether data manipulation and CREATE/DROP is supported in transactions. false supportsDataManipulationTransactionsOnly public boolean supportsDataManipulationTransactionsOnly()(Code) Returns whether only data manipulations are supported in transactions. true supportsDifferentTableCorrelationNames public boolean supportsDifferentTableCorrelationNames()(Code) Returns whether table correlation names (table alias) are restricted to be different than table names. false supportsExpressionsInOrderBy public boolean supportsExpressionsInOrderBy()(Code) Returns whether expression in ORDER BY are supported. true supportsExtendedSQLGrammar public boolean supportsExtendedSQLGrammar()(Code) Returns whether ODBC Extended SQL grammar is supported. false supportsFullOuterJoins public boolean supportsFullOuterJoins()(Code) Returns whether full outer joins are supported. false supportsGetGeneratedKeys public boolean supportsGetGeneratedKeys()(Code) Does the database support getGeneratedKeys. true supportsGroupBy public boolean supportsGroupBy()(Code) Returns whether GROUP BY is supported. true supportsGroupByBeyondSelect public boolean supportsGroupByBeyondSelect()(Code) Checks whether a GROUP BY clause can use columns that are not in the SELECT clause, provided that it specifies all the columns in the SELECT clause. true supportsGroupByUnrelated public boolean supportsGroupByUnrelated()(Code) Returns whether GROUP BY is supported if the column is not in the SELECT list. true supportsIntegrityEnhancementFacility public boolean supportsIntegrityEnhancementFacility()(Code) Returns whether referential integrity is supported. true supportsLikeEscapeClause public boolean supportsLikeEscapeClause()(Code) Returns whether LIKE... ESCAPE is supported. true supportsLimitedOuterJoins public boolean supportsLimitedOuterJoins()(Code) Returns whether limited outer joins are supported. true supportsMinimumSQLGrammar public boolean supportsMinimumSQLGrammar()(Code) Returns whether ODBC Minimum SQL grammar is supported. true supportsMixedCaseIdentifiers public boolean supportsMixedCaseIdentifiers()(Code) Checks if for CREATE TABLE Test(ID INT), getTables returns Test as the table name. false supportsMixedCaseQuotedIdentifiers public boolean supportsMixedCaseQuotedIdentifiers()(Code) Checks if a table created with CREATE TABLE "Test"(ID INT) is a different table than a table created with CREATE TABLE TEST(ID INT). true supportsMultipleOpenResults public boolean supportsMultipleOpenResults()(Code) Does the database support multiple open result sets. true supportsMultipleResultSets public boolean supportsMultipleResultSets()(Code) Returns whether multiple result sets are supported. false supportsMultipleTransactions public boolean supportsMultipleTransactions()(Code) Returns whether multiple transactions (on different connections) are supported. true supportsNamedParameters public boolean supportsNamedParameters()(Code) Does the database support named parameters. false supportsNonNullableColumns public boolean supportsNonNullableColumns()(Code) Returns whether columns with NOT NULL are supported. true supportsOpenCursorsAcrossCommit public boolean supportsOpenCursorsAcrossCommit()(Code) Returns whether open result sets across commits are supported. false supportsOpenCursorsAcrossRollback public boolean supportsOpenCursorsAcrossRollback()(Code) Returns whether open result sets across rollback are supported. false supportsOpenStatementsAcrossCommit public boolean supportsOpenStatementsAcrossCommit()(Code) Returns whether open statements across commit are supported. true supportsOpenStatementsAcrossRollback public boolean supportsOpenStatementsAcrossRollback()(Code) Returns whether open statements across rollback are supported. true supportsOrderByUnrelated public boolean supportsOrderByUnrelated()(Code) Returns whether ORDER BY is supported if the column is not in the SELECT list. true supportsOuterJoins public boolean supportsOuterJoins()(Code) Returns whether outer joins are supported. true supportsPositionedDelete public boolean supportsPositionedDelete()(Code) Returns whether positioned deletes are supported. true supportsPositionedUpdate public boolean supportsPositionedUpdate()(Code) Returns whether positioned updates are supported. true supportsResultSetConcurrency public boolean supportsResultSetConcurrency(int type, int concurrency)(Code) Returns whether a specific result set concurrency is supported. ResultSet.TYPE_SCROLL_SENSITIVE is not supported. true if the type is not ResultSet.TYPE_SCROLL_SENSITIVE supportsResultSetHoldability public boolean supportsResultSetHoldability(int holdability)(Code) Does this database supports a result set holdability. Parameters:   holdability - ResultSet.HOLD_CURSORS_OVER_COMMIT orCLOSE_CURSORS_AT_COMMIT true if the holdability is ResultSet.CLOSE_CURSORS_AT_COMMIT supportsResultSetType public boolean supportsResultSetType(int type)(Code) Returns whether a specific result set type is supported. ResultSet.TYPE_SCROLL_SENSITIVE is not supported. true for all types except ResultSet.TYPE_FORWARD_ONLY supportsSavepoints public boolean supportsSavepoints()(Code) Does the database support savepoints. true supportsSchemasInDataManipulation public boolean supportsSchemasInDataManipulation()(Code) Returns whether the schema name in INSERT, UPDATE, DELETE is supported. true supportsSchemasInIndexDefinitions public boolean supportsSchemasInIndexDefinitions()(Code) Returns whether the schema name in CREATE INDEX is supported. true supportsSchemasInPrivilegeDefinitions public boolean supportsSchemasInPrivilegeDefinitions()(Code) Returns whether the schema name in GRANT is supported. true supportsSchemasInProcedureCalls public boolean supportsSchemasInProcedureCalls()(Code) Returns whether the schema name in procedure calls is supported. true supportsSchemasInTableDefinitions public boolean supportsSchemasInTableDefinitions()(Code) Returns whether the schema name in CREATE TABLE is supported. true supportsSelectForUpdate public boolean supportsSelectForUpdate()(Code) Returns whether SELECT ... FOR UPDATE is supported. true supportsStatementPooling public boolean supportsStatementPooling()(Code) Does the database support statement pooling. false supportsStoredFunctionsUsingCallSyntax public boolean supportsStoredFunctionsUsingCallSyntax() throws SQLException(Code) Returns whether the database supports calling functions using the call syntax. true supportsStoredProcedures public boolean supportsStoredProcedures()(Code) Returns whether stored procedures are supported. false supportsSubqueriesInComparisons public boolean supportsSubqueriesInComparisons()(Code) Returns whether subqueries (SELECT) in comparisons are supported. true supportsSubqueriesInExists public boolean supportsSubqueriesInExists()(Code) Returns whether SELECT in EXISTS is supported. true supportsSubqueriesInIns public boolean supportsSubqueriesInIns()(Code) Returns whether IN(SELECT...) is supported. true supportsSubqueriesInQuantifieds public boolean supportsSubqueriesInQuantifieds()(Code) Returns whether subqueries in quantified expression are supported. true supportsTableCorrelationNames public boolean supportsTableCorrelationNames()(Code) Returns whether table correlation names (table alias) are supported. true supportsTransactionIsolationLevel public boolean supportsTransactionIsolationLevel(int level)(Code) Returns whether a specific transaction isolation level is supported. true supportsTransactions public boolean supportsTransactions()(Code) Returns whether transactions are supported. true supportsUnion public boolean supportsUnion()(Code) Returns whether UNION SELECT is supported. true supportsUnionAll public boolean supportsUnionAll()(Code) Returns whether UNION ALL SELECT is supported. true toString public String toString()(Code) INTERNAL updatesAreDetected public boolean updatesAreDetected(int type)(Code) Returns whether updates are detected. false usesLocalFilePerTable public boolean usesLocalFilePerTable()(Code) Checks if this database use one file per table. false usesLocalFiles public boolean usesLocalFiles()(Code) Checks if this database store data in local files. true Fields inherited from org.h2.message.TraceObject final public static int CALLABLE_STATEMENTCONNECTIONDATABASE_META_DATAPREPARED_STATEMENTRESULT_SETRESULT_SET_META_DATASAVEPOINTSQL_EXCEPTIONSTATEMENTBLOBCLOBPARAMETER_META_DATA(Code)(Java Doc) final public static int DATA_SOURCEXA_DATA_SOURCEXIDARRAY(Code)(Java Doc) Methods inherited from org.h2.message.TraceObject protected boolean debug()(Code)(Java Doc) protected void debugCode(String text)(Code)(Java Doc) protected void debugCodeAssign(String className, int type, int id, String value)(Code)(Java Doc) protected void debugCodeCall(String text)(Code)(Java Doc) protected void debugCodeCall(String text, long param)(Code)(Java Doc) protected void debugCodeCall(String text, String param)(Code)(Java Doc) protected int getNextId(int type)(Code)(Java Doc) protected Trace getTrace()(Code)(Java Doc) protected int getTraceId()(Code)(Java Doc) public String getTraceObjectName()(Code)(Java Doc) protected boolean info()(Code)(Java Doc) protected SQLException logAndConvert(Throwable e)(Code)(Java Doc) protected String quote(String s)(Code)(Java Doc) protected String quoteArray(String[] s)(Code)(Java Doc) protected String quoteBigDecimal(BigDecimal x)(Code)(Java Doc) protected String quoteBytes(byte[] x)(Code)(Java Doc) protected String quoteDate(java.sql.Date x)(Code)(Java Doc) protected String quoteIntArray(int[] s)(Code)(Java Doc) protected String quoteMap(Map map)(Code)(Java Doc) protected String quoteTime(java.sql.Time x)(Code)(Java Doc) protected String quoteTimestamp(java.sql.Timestamp x)(Code)(Java Doc) protected void setTrace(Trace trace, int type, int id)(Code)(Java Doc) public static String toString(String sql, ObjectArray params)(Code)(Java Doc) Methods inherited from java.lang.Object native protected Object clone() throws CloneNotSupportedException(Code)(Java Doc) public boolean equals(Object obj)(Code)(Java Doc) protected void finalize() throws Throwable(Code)(Java Doc) final native public Class getClass()(Code)(Java Doc) native public int hashCode()(Code)(Java Doc) final native public void notify()(Code)(Java Doc) final native public void notifyAll()(Code)(Java Doc) public String toString()(Code)(Java Doc) final native public void wait(long timeout) throws InterruptedException(Code)(Java Doc) final public void wait(long timeout, int nanos) throws InterruptedException(Code)(Java Doc) final public void wait() throws InterruptedException(Code)(Java Doc)