Connection
class implements a virtual connection that is just used to store the needed information when the real connection will have to be established by the Controller to execute a query. This code has been largely inspired from the Postgres JDBC driver by Peter T. Mount.
DatabaseMetaData.java の 43 行で定義されています。
Public メソッド | |
DatabaseMetaData (Connection conn) | |
boolean | allProceduresAreCallable () throws SQLException |
boolean | allTablesAreSelectable () throws SQLException |
boolean | dataDefinitionCausesTransactionCommit () throws SQLException |
boolean | dataDefinitionIgnoredInTransactions () throws SQLException |
boolean | deletesAreDetected (int type) throws SQLException |
boolean | doesMaxRowSizeIncludeBlobs () throws SQLException |
java.sql.ResultSet | getBestRowIdentifier (String catalog, String schema, String table, int scope, boolean nullable) throws SQLException |
java.sql.ResultSet | getCatalogs () throws SQLException |
String | getCatalogSeparator () throws SQLException |
String | getCatalogTerm () throws SQLException |
java.sql.ResultSet | getColumns (String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SQLException |
java.sql.ResultSet | getColumnPrivileges (String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SQLException |
java.sql.Connection | getConnection () throws SQLException |
java.sql.ResultSet | getCrossReference (String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) throws SQLException |
String | getDatabaseProductName () throws SQLException |
String | getDatabaseProductVersion () throws SQLException |
int | getDefaultTransactionIsolation () throws SQLException |
int | getDriverMajorVersion () |
int | getDriverMinorVersion () |
String | getDriverName () throws SQLException |
String | getDriverVersion () throws SQLException |
java.sql.ResultSet | getExportedKeys (String catalog, String schema, String table) throws SQLException |
String | getExtraNameCharacters () throws SQLException |
String | getIdentifierQuoteString () throws SQLException |
java.sql.ResultSet | getImportedKeys (String catalog, String schema, String table) throws SQLException |
java.sql.ResultSet | getIndexInfo (String catalog, String schema, String table, boolean unique, boolean approximate) throws SQLException |
int | getMaxBinaryLiteralLength () throws SQLException |
int | getMaxCatalogNameLength () throws SQLException |
int | getMaxCharLiteralLength () throws SQLException |
int | getMaxColumnNameLength () throws SQLException |
int | getMaxColumnsInGroupBy () throws SQLException |
int | getMaxColumnsInIndex () throws SQLException |
int | getMaxColumnsInOrderBy () throws SQLException |
int | getMaxColumnsInSelect () throws SQLException |
int | getMaxColumnsInTable () throws SQLException |
int | getMaxConnections () throws SQLException |
int | getMaxCursorNameLength () throws SQLException |
int | getMaxIndexLength () throws SQLException |
int | getMaxProcedureNameLength () throws SQLException |
int | getMaxRowSize () throws SQLException |
int | getMaxSchemaNameLength () throws SQLException |
int | getMaxStatementLength () throws SQLException |
int | getMaxStatements () throws SQLException |
int | getMaxTableNameLength () throws SQLException |
int | getMaxTablesInSelect () throws SQLException |
int | getMaxUserNameLength () throws SQLException |
String | getNumericFunctions () throws SQLException |
java.sql.ResultSet | getPrimaryKeys (String catalog, String schema, String table) throws SQLException |
java.sql.ResultSet | getProcedureColumns (String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) throws SQLException |
java.sql.ResultSet | getProcedures (String catalog, String schemaPattern, String procedureNamePattern) throws SQLException |
String | getProcedureTerm () throws SQLException |
java.sql.ResultSet | getSchemas () throws SQLException |
String | getSchemaTerm () throws SQLException |
String | getSearchStringEscape () throws SQLException |
String | getSQLKeywords () throws SQLException |
String | getStringFunctions () throws SQLException |
String | getSystemFunctions () throws SQLException |
java.sql.ResultSet | getTables (String catalog, String schemaPattern, String tableNamePattern, String types[]) throws SQLException |
java.sql.ResultSet | getTablePrivileges (String catalog, String schemaPattern, String tableNamePattern) throws SQLException |
java.sql.ResultSet | getTableTypes () throws SQLException |
String | getTimeDateFunctions () throws SQLException |
java.sql.ResultSet | getTypeInfo () throws SQLException |
java.sql.ResultSet | getUDTs (String catalog, String schemaPattern, String typeNamePattern, int[] types) throws SQLException |
String | getURL () throws SQLException |
String | getUserName () throws SQLException |
java.sql.ResultSet | getVersionColumns (String catalog, String schema, String table) throws SQLException |
boolean | insertsAreDetected (int type) throws SQLException |
boolean | isCatalogAtStart () throws SQLException |
boolean | isReadOnly () throws SQLException |
boolean | nullPlusNonNullIsNull () throws SQLException |
boolean | nullsAreSortedAtEnd () throws SQLException |
boolean | nullsAreSortedAtStart () throws SQLException |
boolean | nullsAreSortedHigh () throws SQLException |
boolean | nullsAreSortedLow () throws SQLException |
boolean | othersDeletesAreVisible (int type) throws SQLException |
boolean | othersInsertsAreVisible (int type) throws SQLException |
boolean | othersUpdatesAreVisible (int type) throws SQLException |
boolean | ownDeletesAreVisible (int type) throws SQLException |
boolean | ownInsertsAreVisible (int type) throws SQLException |
boolean | ownUpdatesAreVisible (int type) throws SQLException |
boolean | storesLowerCaseIdentifiers () throws SQLException |
boolean | storesLowerCaseQuotedIdentifiers () throws SQLException |
boolean | storesMixedCaseIdentifiers () throws SQLException |
boolean | storesMixedCaseQuotedIdentifiers () throws SQLException |
boolean | storesUpperCaseIdentifiers () throws SQLException |
boolean | storesUpperCaseQuotedIdentifiers () throws SQLException |
boolean | supportsAlterTableWithAddColumn () throws SQLException |
boolean | supportsAlterTableWithDropColumn () throws SQLException |
boolean | supportsANSI92EntryLevelSQL () throws SQLException |
boolean | supportsANSI92FullSQL () throws SQLException |
boolean | supportsANSI92IntermediateSQL () throws SQLException |
boolean | supportsBatchUpdates () throws SQLException |
boolean | supportsCatalogsInDataManipulation () throws SQLException |
boolean | supportsCatalogsInIndexDefinitions () throws SQLException |
boolean | supportsCatalogsInPrivilegeDefinitions () throws SQLException |
boolean | supportsCatalogsInProcedureCalls () throws SQLException |
boolean | supportsCatalogsInTableDefinitions () throws SQLException |
boolean | supportsColumnAliasing () throws SQLException |
boolean | supportsConvert () throws SQLException |
boolean | supportsConvert (int fromType, int toType) throws SQLException |
boolean | supportsCoreSQLGrammar () throws SQLException |
boolean | supportsCorrelatedSubqueries () throws SQLException |
boolean | supportsDataDefinitionAndDataManipulationTransactions () throws SQLException |
boolean | supportsDataManipulationTransactionsOnly () throws SQLException |
boolean | supportsDifferentTableCorrelationNames () throws SQLException |
boolean | supportsExpressionsInOrderBy () throws SQLException |
boolean | supportsExtendedSQLGrammar () throws SQLException |
boolean | supportsFullOuterJoins () throws SQLException |
boolean | supportsGroupBy () throws SQLException |
boolean | supportsGroupByBeyondSelect () throws SQLException |
boolean | supportsGroupByUnrelated () throws SQLException |
boolean | supportsIntegrityEnhancementFacility () throws SQLException |
boolean | supportsLikeEscapeClause () throws SQLException |
boolean | supportsLimitedOuterJoins () throws SQLException |
boolean | supportsMinimumSQLGrammar () throws SQLException |
boolean | supportsMixedCaseIdentifiers () throws SQLException |
boolean | supportsMixedCaseQuotedIdentifiers () throws SQLException |
boolean | supportsMultipleResultSets () throws SQLException |
boolean | supportsMultipleTransactions () throws SQLException |
boolean | supportsNonNullableColumns () throws SQLException |
boolean | supportsOpenCursorsAcrossCommit () throws SQLException |
boolean | supportsOpenCursorsAcrossRollback () throws SQLException |
boolean | supportsOpenStatementsAcrossCommit () throws SQLException |
boolean | supportsOpenStatementsAcrossRollback () throws SQLException |
boolean | supportsOrderByUnrelated () throws SQLException |
boolean | supportsOuterJoins () throws SQLException |
boolean | supportsPositionedDelete () throws SQLException |
boolean | supportsPositionedUpdate () throws SQLException |
boolean | supportsResultSetConcurrency (int type, int concurrency) throws SQLException |
boolean | supportsResultSetType (int type) throws SQLException |
boolean | supportsSchemasInDataManipulation () throws SQLException |
boolean | supportsSchemasInIndexDefinitions () throws SQLException |
boolean | supportsSchemasInPrivilegeDefinitions () throws SQLException |
boolean | supportsSchemasInProcedureCalls () throws SQLException |
boolean | supportsSchemasInTableDefinitions () throws SQLException |
boolean | supportsSelectForUpdate () throws SQLException |
boolean | supportsStoredProcedures () throws SQLException |
boolean | supportsSubqueriesInComparisons () throws SQLException |
boolean | supportsSubqueriesInExists () throws SQLException |
boolean | supportsSubqueriesInIns () throws SQLException |
boolean | supportsSubqueriesInQuantifieds () throws SQLException |
boolean | supportsTableCorrelationNames () throws SQLException |
boolean | supportsTransactionIsolationLevel (int level) throws SQLException |
boolean | supportsTransactions () throws SQLException |
boolean | supportsUnion () throws SQLException |
boolean | supportsUnionAll () throws SQLException |
boolean | updatesAreDetected (int type) throws SQLException |
boolean | usesLocalFilePerTable () throws SQLException |
boolean | usesLocalFiles () throws SQLException |
boolean | supportsSavepoints () throws SQLException |
boolean | supportsNamedParameters () throws SQLException |
boolean | supportsMultipleOpenResults () throws SQLException |
boolean | supportsGetGeneratedKeys () throws SQLException |
java.sql.ResultSet | getSuperTypes (String catalog, String schemaPattern, String typeNamePattern) throws SQLException |
java.sql.ResultSet | getSuperTables (String catalog, String schemaPattern, String tableNamePattern) throws SQLException |
java.sql.ResultSet | getAttributes (String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern) throws SQLException |
boolean | supportsResultSetHoldability (int holdability) throws SQLException |
int | getResultSetHoldability () throws SQLException |
int | getDatabaseMajorVersion () throws SQLException |
int | getDatabaseMinorVersion () throws SQLException |
int | getJDBCMajorVersion () throws SQLException |
int | getJDBCMinorVersion () throws SQLException |
int | getSQLStateType () throws SQLException |
boolean | locatorsUpdateCopy () throws SQLException |
boolean | supportsStatementPooling () throws SQLException |
Private 変数 | |
Connection | connection |
|
Creates a new
|
|
Can all the procedures returned by
|
|
Can all the tables returned by
|
|
Does a data definition statement within a transaction force the transaction to commit? I think this means something like:
CREATE TABLE T (A INT); INSERT INTO T (A) VALUES (2); BEGIN; UPDATE T SET A = A + 1; CREATE TABLE X (A INT); SELECT A FROM T INTO X; COMMIT; does the CREATE TABLE call cause a commit? The answer is no.
|
|
Is a data definition statement within a transaction ignored? It seems to be (from experiment in previous method).
|
|
C-JDBC does NOT support deleted rows.
|
|
Did
|
|
Retrieves a description of the given attribute of the given type for a user-defined type (UDT) that is available in the given schema and catalog. Descriptions are returned only for attributes of UDTs matching the catalog, schema, type, and attribute name criteria. They are ordered by TYPE_SCHEM, TYPE_NAME and ORDINAL_POSITION. This description does not contain inherited attributes.
The
|
|
This method is currently not supported and returns
|
|
Return a list of available catalogs
参照先 org.objectweb.cjdbc.driver.DatabaseMetaData.connection, と org.objectweb.cjdbc.driver.Connection.getCatalogs().
|
|
Returns the catalog separator.
|
|
What is the database vendor's preferred term for "schema" - well, we do not provide support for schemas, so lets just use that term.
|
|
Feature not yet supported by C-JDBC.
|
|
参照先 org.objectweb.cjdbc.driver.DatabaseMetaData.connection, と org.objectweb.cjdbc.driver.Connection.getColumns().
|
|
Retrieves the
参照先 org.objectweb.cjdbc.driver.DatabaseMetaData.connection.
|
|
Feature not yet supported by C-JDBC
|
|
Retrieves the major version number of the underlying database. This is not yet supported by C-JDBC.
|
|
Retrieves the minor version number of the underlying database. This is not yet supported by C-JDBC.
|
|
We return a comma separated list of database engine names connected to the controller. A name appears only once regardless of the number of instances of this particular db engine. If no database product name is provided by the backend drivers, default is to return "C-JDBC Controller".
参照先 org.objectweb.cjdbc.driver.DatabaseMetaData.connection, と org.objectweb.cjdbc.driver.Connection.getDatabaseProductName().
|
|
What is the version of this database product.
参照先 org.objectweb.cjdbc.driver.DatabaseMetaData.connection, と org.objectweb.cjdbc.driver.Connection.getControllerVersionNumber().
|
|
What is the database's default transaction isolation level? We do not support this, so assume it's TRANSACTION_READ_COMMITTED.
|
|
What is this JDBC driver's major version number?
|
|
What is this JDBC driver's minor version number?
|
|
What is the name of this JDBC driver?
|
|
What is the version string of this JDBC driver?
|
|
Feature not yet supported by C-JDBC.
|
|
Gets all the "extra" characters that can be used in unquoted identifier names (those beyond a-zA-Z0-9 and _). For portability reasons, we assume that no extra character is allowed.
|
|
What is the string used to quote SQL identifiers? This returns a space if identifier quoting isn't supported. A JDBC Compliant driver will always use a double quote character. If an SQL identifier is a table name, column name, etc. then we do not support it.
|
|
Feature not yet supported by C-JDBC.
|
|
Feature not yet supported by C-JDBC.
|
|
Retrieves the major JDBC version number for this driver.
|
|
Retrieves the minor JDBC version number for this driver.
|
|
How many hex characters can you have in an inline binary literal. The spec says 0 should be returned if unknown.
|
|
Maximum number of characters in a catalog name. The spec says 0 should be returned if unknown.
|
|
Maximum length for a character literal. The spec says 0 should be returned if unknown.
|
|
Maximum length for a column name. The spec says 0 should be returned if unknown.
|
|
Maximum number of columns in a "GROUP BY" clause? The spec says 0 should be returned if unknown.
|
|
Maximum number of columns allowed in an index? The spec says 0 should be returned if unknown.
|
|
Maximum number of columns in an "ORDER BY clause? The spec says 0 should be returned if unknown.
|
|
Maximum number of columns in a "SELECT" list? The spec says 0 should be returned if unknown.
|
|
Maximum number of columns in a table? The spec says 0 should be returned if unknown.
|
|
Maximum number of connections to the database (virtually no limit since these are virtual connections to the Controller). The spec says 0 should be returned if unknown.
|
|
Maximum cursor name length. The spec says 0 should be returned if unknown.
|
|
Maximum length of an index (in bytes)? The spec says 0 should be returned if unknown.
|
|
Maximum length of a procedure name? The spec says 0 should be returned if unknown.
|
|
Maximum length of a single row? (not including blobs). The spec says 0 should be returned if unknown.
|
|
Maximum length of a schema name. The spec says 0 should be returned if unknown.
|
|
Maximum length of a SQL statement? The spec says 0 should be returned if unknown.
|
|
How many active statements can we have open at one time to this database? Basically, since each
|
|
Maximum length of a table name? The spec says 0 should be returned if unknown.
|
|
Maximum number of tables that can be specified in a SELECT. The spec says 0 should be returned if unknown.
|
|
Maximum length of a user name. The spec says 0 should be returned if unknown.
|
|
Name of Open Group CLI is not supported.
|
|
参照先 org.objectweb.cjdbc.driver.DatabaseMetaData.connection, と org.objectweb.cjdbc.driver.Connection.getPrimaryKeys().
|
|
参照先 org.objectweb.cjdbc.driver.DatabaseMetaData.connection, と org.objectweb.cjdbc.driver.Connection.getProcedureColumns().
|
|
参照先 org.objectweb.cjdbc.driver.DatabaseMetaData.connection, と org.objectweb.cjdbc.driver.Connection.getProcedures().
|
|
What is the database vendor's preferred term for "procedure" - I kind of like "procedure" myself.
|
|
Retrieves the default holdability of this
|
|
参照先 org.objectweb.cjdbc.driver.DatabaseMetaData.connection, と org.objectweb.cjdbc.driver.Connection.getSchemas().
|
|
What is the database vendor's preferred term for "schema" - well, we do not provide support for schemas, so lets just use that term.
|
|
This is the string that can be used to escape '_' and '%' in a search string pattern style catalog search parameters. We assume that '\' will work for all databases ...
|
|
Get a comma separated list of all a database's SQL keywords that are NOT also SQL92 keywords. We assume that we don't use any non-SQL92 keywords.
|
|
Indicates whether the SQLSTATE returned by
|
|
Feature not yet supported by C-JDBC.
|
|
Retrieves a description of the table hierarchies defined in a particular schema in this database. Only supertable information for tables matching the catalog, schema and table name are returned. The table name parameter may be a fully- qualified name, in which case, the catalog and schemaPattern parameters are ignored. If a table does not have a super table, it is not listed here. Supertables have to be defined in the same catalog and schema as the sub tables. Therefore, the type description does not need to include this information for the supertable. Each type description has the following columns:
Note: If the driver does not support type hierarchies, an empty result set is returned.
|
|
Retrieves a description of the user-defined type (UDT) hierarchies defined in a particular schema in this database. Only the immediate super type/ sub type relationship is modeled. Only supertype information for UDTs matching the catalog, schema, and type name is returned. The type name parameter may be a fully-qualified name. When the UDT name supplied is a fully-qualified name, the catalog and schemaPattern parameters are ignored.
If a UDT does not have a direct super type, it is not listed here. A row of the
Note: If the driver does not support type hierarchies, an empty result set is returned.
|
|
Feature not yet supported by C-JDBC.
|
|
Gets a description of the access rights for each table available in a catalog. Note that a table privilege applies to one or more columns in the table. It would be wrong to assume that this priviledge applies to all columns (this may be true for some systems but is not true for all.) Only privileges matching the schema and table name criteria are returned. They are ordered by TABLE_SCHEM, TABLE_NAME, and PRIVILEGE.
参照先 org.objectweb.cjdbc.driver.DatabaseMetaData.connection, と org.objectweb.cjdbc.driver.Connection.getTablePrivileges().
|
|
Gets a description of the available tables.
参照先 org.objectweb.cjdbc.driver.DatabaseMetaData.connection, と org.objectweb.cjdbc.driver.Connection.getTables().
|
|
Gets the table types available in this database. The results are ordered by table type.
参照先 org.objectweb.cjdbc.driver.DatabaseMetaData.connection, と org.objectweb.cjdbc.driver.Connection.getTableTypes().
|
|
Feature not yet supported by C-JDBC.
|
|
Feature not yet supported by C-JDBC.
|
|
Feature not yet supported by C-JDBC.
|
|
What is the URL for this database?
参照先 org.objectweb.cjdbc.driver.DatabaseMetaData.connection, と org.objectweb.cjdbc.driver.Connection.getURL().
|
|
What is our user name as known to the database?
参照先 org.objectweb.cjdbc.driver.DatabaseMetaData.connection, と org.objectweb.cjdbc.driver.Connection.getUserName().
|
|
Feature not yet supported by C-JDBC.
|
|
We do not support row insert in
|
|
Does a catalog appear at the start of a qualified table name? (Otherwise it appears at the end).
|
|
Is the database in read-only mode?
参照先 org.objectweb.cjdbc.driver.DatabaseMetaData.connection, と org.objectweb.cjdbc.driver.Connection.isReadOnly().
|
|
Indicates whether updates made to a LOB are made on a copy or directly to the LOB.
|
|
Are concatenations between NULL and non-NULL values NULL? A JDBC Compliant driver always returns
|
|
Are NULL values sorted at the end regardless of sort order?
|
|
Are NULL values sorted at the start regardless of sort order?
|
|
Are NULL values sorted high?
|
|
Are NULL values sorted low?
|
|
C-JDBC does not support deletes.
|
|
C-JDBC does not support inserts.
|
|
C-JDBC does not support updates.
|
|
C-JDBC does not support deletes.
|
|
C-JDBC does not support inserts.
|
|
C-JDBC does not support updates.
|
|
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in lower case?
|
|
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in lower case?
|
|
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in mixed case?
|
|
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in mixed case?
|
|
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in upper case?
|
|
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in upper case?
|
|
Not implemented (returns
|
|
Not implemented (returns
|
|
Does this driver support the ANSI-92 entry level SQL grammar? All JDBC Compliant drivers must return
|
|
Does this driver support the ANSI-92 full SQL grammar?
|
|
Does this driver support the ANSI-92 intermediate level SQL grammar? Anyone who does not support Entry level cannot support Intermediate level.
|
|
Does this driver support batch updates ? Yes, since 1.0a5.
|
|
Can a catalog name be used in a data manipulation statement?
|
|
Can a catalog name be used in an index definition?
|
|
Can a catalog name be used in a privilege definition statement?
|
|
Can a catalog name be used in a procedure call statement?
|
|
Can a catalog name be used in a table definition statement?
|
|
Is column aliasing supported?
If so, the SQL AS clause can be used to provide names for computed columns or to provide alias names for columns as required. A JDBC Compliant driver always returns
e.g.
select count(C) as C_COUNT from T group by C;
|
|
Not implemented (returns
|
|
Not implemented (returns
|
|
Does this driver support the Core ODBC SQL grammar. We need SQL-92 conformance for this.
|
|
Not implemented (returns
|
|
Are both data definition and data manipulation transactions supported? In Postgres we could not do a CREATE TABLE within a transaction, so I am assuming that we don't.
|
|
Are only data manipulation statements within a transaction supported?
|
|
Not implemented (returns
|
|
Not implemented (returns
|
|
Does this driver support the Extended (Level 2) ODBC SQL grammar. We don't conform to the Core (Level 1), so we can't conform to the Extended SQL Grammar.
|
|
Not implemented (returns
|
|
Retrieves whether auto-generated keys can be retrieved after a statement has been executed.
|
|
Is some form of "GROUP BY" clause supported? I checked it, and yes it is.
|
|
Can a "GROUP BY" clause add columns not in the SELECT provided it specifies all the columns in the SELECT? Does anyone actually understand what they mean here?
|
|
Can a "GROUP BY" clause use columns not in the SELECT? I checked it - it seems to allow it.
|
|
Is the SQL Integrity Enhancement Facility supported? I haven't seen this mentioned anywhere, so I guess not
|
|
Is the escape character in "LIKE" clauses supported? A JDBC compliant driver always returns
|
|
Is there limited support for outer joins? (This will be
|
|
Does this driver support the minimum ODBC SQL grammar. This grammar is defined at: In Postgres Appendix C. From this description, we seem to support the ODBC minimal (Level 0) grammar.
|
|
Does the database treat mixed case unquoted SQL identifiers as case sensitive and as a result store them in mixed case? A JDBC-Compliant driver will always return Predicament - what do they mean by "SQL identifiers" - if it means the names of the tables and columns, then the answers given below are correct - otherwise I don't know.
|
|
Does the database treat mixed case quoted SQL identifiers as case sensitive and as a result store them in mixed case? A JDBC compliant driver will always return Predicament - what do they mean by "SQL identifiers" - if it means the names of the tables and columns, then the answers given below are correct - otherwise I don't know.
|
|
Retrieves whether it is possible to have multiple This is not yet supported by C-JDBC.
|
|
Are multiple
|
|
Can we have multiple transactions open at once (on different connections?). I guess we can have, since we are relying on it.
|
|
Retrieves whether this database supports named parameters to callable statements. This is not yet supported by C-JDBC.
|
|
Can columns be defined as non-nullable. A JDBC Compliant driver always returns
|
|
Does this database support having cursors remain open across commits. Note that a return value of flase does not mean that cursors are always close on commit; rather false means that cursors are not always left open across commits.
|
|
Do we support open cursors across rollback ?
|
|
Can statements remain open across commits? They may, but this driver cannot guarentee that. In further reflection. We are talking a
|
|
Can statements remain open across rollbacks? They may, but this driver cannot guarentee that. In further contemplation, we are talking a
|
|
Can an "ORDER BY" clause use columns not in the SELECT?
|
|
Is some form of outer join supported?
|
|
We support cursors for gets only it seems. I dont see a method to get a positioned delete.
|
|
Is positioned UPDATE supported?
|
|
Which combination of concurrency level and
|
|
Retrieves whether this database supports the given result set holdability. This is not yet supported by C-JDBC.
|
|
Supported
|
|
Retrieves whether this database supports savepoints. This is not yet supported by C-JDBC.
|
|
Can a schema name be used in a data manipulation statement? Nope.
|
|
Can a schema name be used in an index definition statement?
|
|
Can a schema name be used in a privilege definition statement?
|
|
Can a schema name be used in a procedure call statement? Nope.
|
|
Can a schema be used in a table definition statement? Nope.
|
|
Not implemented (returns
|
|
Retrieves whether this database supports statement pooling. This is not yet supported in C-JDBC.
|
|
Yes, stored procedures are supported since 1.0b6.
|
|
Not implemented (returns
|
|
Not implemented (returns
|
|
Not implemented (returns
|
|
Not implemented (returns
|
|
Not implemented (returns
|
|
Does the database support the given transaction isolation level? We should support all of them or at least ask the Controller ...
|
|
Are transactions supported? If not, commit and rollback are noops and the isolation level is TRANSACTION_NONE. We do support transactions.
|
|
Is SQL UNION supported?
|
|
Is SQL UNION ALL supported? Nope.
|
|
Not implemented (returns
|
|
Does the database use a file for each table? Well, not really, since it doesn't use local files.
|
|
Does the database store tables in a local file? No, it stores them in a file on the server.
|
|