クラス PgDatabaseMetaData
- すべての実装されたインタフェース:
DatabaseMetaData
,Wrapper
-
フィールドの概要
フィールドインタフェースから継承されたフィールド java.sql.DatabaseMetaData
attributeNoNulls, attributeNullable, attributeNullableUnknown, bestRowNotPseudo, bestRowPseudo, bestRowSession, bestRowTemporary, bestRowTransaction, bestRowUnknown, columnNoNulls, columnNullable, columnNullableUnknown, functionColumnIn, functionColumnInOut, functionColumnOut, functionColumnResult, functionColumnUnknown, functionNoNulls, functionNoTable, functionNullable, functionNullableUnknown, functionResultUnknown, functionReturn, functionReturnsTable, importedKeyCascade, importedKeyInitiallyDeferred, importedKeyInitiallyImmediate, importedKeyNoAction, importedKeyNotDeferrable, importedKeyRestrict, importedKeySetDefault, importedKeySetNull, procedureColumnIn, procedureColumnInOut, procedureColumnOut, procedureColumnResult, procedureColumnReturn, procedureColumnUnknown, procedureNoNulls, procedureNoResult, procedureNullable, procedureNullableUnknown, procedureResultUnknown, procedureReturnsResult, sqlStateSQL, sqlStateSQL99, sqlStateXOpen, tableIndexClustered, tableIndexHashed, tableIndexOther, tableIndexStatistic, typeNoNulls, typeNullable, typeNullableUnknown, typePredBasic, typePredChar, typePredNone, typeSearchable, versionColumnNotPseudo, versionColumnPseudo, versionColumnUnknown
-
コンストラクタの概要
コンストラクタ -
メソッドの概要
修飾子とタイプメソッド説明boolean
boolean
boolean
protected Statement
boolean
Does a data definition statement within a transaction force the transaction to commit?boolean
boolean
deletesAreDetected
(int i) boolean
protected String
Turn the provided value into a valid string literal for direct inclusion into a query.boolean
getAttributes
(@Nullable String catalog, @Nullable String schemaPattern, @Nullable String typeNamePattern, @Nullable String attributeNamePattern) getBestRowIdentifier
(@Nullable String catalog, @Nullable String schema, String table, int scope, boolean nullable) getColumnPrivileges
(@Nullable String catalog, @Nullable String schema, String table, @Nullable String columnNamePattern) getColumns
(@Nullable String catalog, @Nullable String schemaPattern, @Nullable String tableNamePattern, @Nullable String columnNamePattern) getCrossReference
(@Nullable String primaryCatalog, @Nullable String primarySchema, String primaryTable, @Nullable String foreignCatalog, @Nullable String foreignSchema, String foreignTable) int
int
Retrieves the name of this database product.int
int
int
getExportedKeys
(@Nullable String catalog, @Nullable String schema, String table) getFunctionColumns
(@Nullable String catalog, @Nullable String schemaPattern, @Nullable String functionNamePattern, @Nullable String columnNamePattern) getFunctions
(@Nullable String catalog, @Nullable String schemaPattern, @Nullable String functionNamePattern) What is the string used to quote SQL identifiers?protected ResultSet
getImportedExportedKeys
(@Nullable String primaryCatalog, @Nullable String primarySchema, @Nullable String primaryTable, @Nullable String foreignCatalog, @Nullable String foreignSchema, @Nullable String foreignTable) getImportedKeys
(@Nullable String catalog, @Nullable String schema, String table) getIndexInfo
(@Nullable String catalog, @Nullable String schema, String tableName, boolean unique, boolean approximate) int
int
int
int
int
int
int
int
int
int
int
What is the maximum number of columns in a table?int
How many active connection can we have at a time to this database?int
protected int
int
long
protected int
int
int
int
int
int
int
int
int
getPrimaryKeys
(@Nullable String catalog, @Nullable String schema, String table) protected ResultSet
getPrimaryUniqueKeys
(@Nullable String catalog, @Nullable String schema, String table) getProcedureColumns
(@Nullable String catalog, @Nullable String schemaPattern, @Nullable String procedureNamePattern, @Nullable String columnNamePattern) getProcedures
(@Nullable String catalog, @Nullable String schemaPattern, @Nullable String procedureNamePattern) getPseudoColumns
(@Nullable String catalog, @Nullable String schemaPattern, @Nullable String tableNamePattern, @Nullable String columnNamePattern) int
getSchemas
(@Nullable String catalog, @Nullable String schemaPattern) int
getSuperTables
(@Nullable String catalog, @Nullable String schemaPattern, @Nullable String tableNamePattern) getSuperTypes
(@Nullable String catalog, @Nullable String schemaPattern, @Nullable String typeNamePattern) getTablePrivileges
(@Nullable String catalog, @Nullable String schemaPattern, @Nullable String tableNamePattern) getTables
(@Nullable String catalog, @Nullable String schemaPattern, @Nullable String tableNamePattern, String @Nullable [] types) getUDTs
(@Nullable String catalog, @Nullable String schemaPattern, @Nullable String typeNamePattern, int @Nullable [] types) getURL()
getVersionColumns
(@Nullable String catalog, @Nullable String schema, String table) boolean
insertsAreDetected
(int type) boolean
boolean
boolean
isWrapperFor
(Class<?> iface) boolean
boolean
boolean
boolean
boolean
boolean
boolean
othersDeletesAreVisible
(int i) boolean
othersInsertsAreVisible
(int type) boolean
othersUpdatesAreVisible
(int type) boolean
ownDeletesAreVisible
(int type) boolean
ownInsertsAreVisible
(int type) boolean
ownUpdatesAreVisible
(int type) Take the a String representing an array of ACLs and return a Map mapping the SQL permission name to a List of usernames who have that permission.boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
Does this driver support the ANSI-92 entry level SQL grammar?boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
supportsConvert
(int fromType, int toType) boolean
Does this driver support the Core ODBC SQL grammar.boolean
boolean
boolean
boolean
boolean
boolean
Does this driver support the Extended (Level 2) ODBC SQL grammar.boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
Does the database treat mixed case unquoted SQL identifiers as case sensitive and as a result store them in mixed case?boolean
Does the database treat mixed case quoted SQL identifiers as case sensitive and as a result store them in mixed case?boolean
boolean
boolean
boolean
boolean
boolean
In PostgreSQL, Cursors are only open within transactions.boolean
boolean
boolean
boolean
boolean
boolean
We support cursors for gets only it seems.boolean
boolean
boolean
supportsResultSetConcurrency
(int type, int concurrency) boolean
supportsResultSetHoldability
(int holdability) boolean
supportsResultSetType
(int type) boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
supportsTransactionIsolationLevel
(int level) boolean
boolean
boolean
<T> T
boolean
updatesAreDetected
(int type) boolean
Does the database use a file for each table?boolean
Does the database store tables in a local file?クラスから継承されたメソッド java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
インタフェースから継承されたメソッド java.sql.DatabaseMetaData
supportsSharding
-
フィールド詳細
-
connection
-
-
コンストラクタの詳細
-
PgDatabaseMetaData
-
-
メソッドの詳細
-
getMaxIndexKeys
- 例外:
SQLException
-
getMaxNameLength
- 例外:
SQLException
-
allProceduresAreCallable
- 定義:
allProceduresAreCallable
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
allTablesAreSelectable
- 定義:
allTablesAreSelectable
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getURL
- 定義:
getURL
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getUserName
- 定義:
getUserName
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
isReadOnly
- 定義:
isReadOnly
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
nullsAreSortedHigh
- 定義:
nullsAreSortedHigh
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
nullsAreSortedLow
- 定義:
nullsAreSortedLow
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
nullsAreSortedAtStart
- 定義:
nullsAreSortedAtStart
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
nullsAreSortedAtEnd
- 定義:
nullsAreSortedAtEnd
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getDatabaseProductName
Retrieves the name of this database product. We hope that it is PostgreSQL, so we return that explicitly.- 定義:
getDatabaseProductName
インタフェース内DatabaseMetaData
- 戻り値:
- "PostgreSQL"
- 例外:
SQLException
-
getDatabaseProductVersion
- 定義:
getDatabaseProductVersion
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getDriverName
- 定義:
getDriverName
インタフェース内DatabaseMetaData
-
getDriverVersion
- 定義:
getDriverVersion
インタフェース内DatabaseMetaData
-
getDriverMajorVersion
public int getDriverMajorVersion()- 定義:
getDriverMajorVersion
インタフェース内DatabaseMetaData
-
getDriverMinorVersion
public int getDriverMinorVersion()- 定義:
getDriverMinorVersion
インタフェース内DatabaseMetaData
-
usesLocalFiles
Does the database store tables in a local file? No - it stores them in a file on the server.- 定義:
usesLocalFiles
インタフェース内DatabaseMetaData
- 戻り値:
- true if so
- 例外:
SQLException
- if a database access error occurs
-
usesLocalFilePerTable
Does the database use a file for each table? Well, not really, since it doesn't use local files.- 定義:
usesLocalFilePerTable
インタフェース内DatabaseMetaData
- 戻り値:
- true if so
- 例外:
SQLException
- if a database access error occurs
-
supportsMixedCaseIdentifiers
Does the database treat mixed case unquoted SQL identifiers as case sensitive and as a result store them in mixed case? A JDBC-Compliant driver will always return false.- 定義:
supportsMixedCaseIdentifiers
インタフェース内DatabaseMetaData
- 戻り値:
- true if so
- 例外:
SQLException
- if a database access error occurs
-
storesUpperCaseIdentifiers
- 定義:
storesUpperCaseIdentifiers
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
storesLowerCaseIdentifiers
- 定義:
storesLowerCaseIdentifiers
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
storesMixedCaseIdentifiers
- 定義:
storesMixedCaseIdentifiers
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsMixedCaseQuotedIdentifiers
Does the database treat mixed case quoted SQL identifiers as case sensitive and as a result store them in mixed case? A JDBC compliant driver will always return true.- 定義:
supportsMixedCaseQuotedIdentifiers
インタフェース内DatabaseMetaData
- 戻り値:
- true if so
- 例外:
SQLException
- if a database access error occurs
-
storesUpperCaseQuotedIdentifiers
- 定義:
storesUpperCaseQuotedIdentifiers
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
storesLowerCaseQuotedIdentifiers
- 定義:
storesLowerCaseQuotedIdentifiers
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
storesMixedCaseQuotedIdentifiers
- 定義:
storesMixedCaseQuotedIdentifiers
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getIdentifierQuoteString
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.- 定義:
getIdentifierQuoteString
インタフェース内DatabaseMetaData
- 戻り値:
- the quoting string
- 例外:
SQLException
- if a database access error occurs
-
getSQLKeywords
From PostgreSQL 9.0+ return the keywords from pg_catalog.pg_get_keywords()
- 定義:
getSQLKeywords
インタフェース内DatabaseMetaData
- 戻り値:
- a comma separated list of keywords we use
- 例外:
SQLException
- if a database access error occurs
-
getNumericFunctions
- 定義:
getNumericFunctions
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getStringFunctions
- 定義:
getStringFunctions
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getSystemFunctions
- 定義:
getSystemFunctions
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getTimeDateFunctions
- 定義:
getTimeDateFunctions
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getSearchStringEscape
- 定義:
getSearchStringEscape
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getExtraNameCharacters
Postgresql allows any high-bit character to be used in an unquoted identifier, so we can't possibly list them all.
From the file src/backend/parser/scan.l, an identifier is ident_start [A-Za-z\200-\377_] ident_cont [A-Za-z\200-\377_0-9\$] identifier {ident_start}{ident_cont}*
- 定義:
getExtraNameCharacters
インタフェース内DatabaseMetaData
- 戻り値:
- a string containing the extra characters
- 例外:
SQLException
- if a database access error occurs
-
supportsAlterTableWithAddColumn
- 定義:
supportsAlterTableWithAddColumn
インタフェース内DatabaseMetaData
- 戻り値:
- true if connected to PostgreSQL 6.1+
- 例外:
SQLException
-
supportsAlterTableWithDropColumn
- 定義:
supportsAlterTableWithDropColumn
インタフェース内DatabaseMetaData
- 戻り値:
- true if connected to PostgreSQL 7.3+
- 例外:
SQLException
-
supportsColumnAliasing
- 定義:
supportsColumnAliasing
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
nullPlusNonNullIsNull
- 定義:
nullPlusNonNullIsNull
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsConvert
- 定義:
supportsConvert
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsConvert
- 定義:
supportsConvert
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsTableCorrelationNames
- 定義:
supportsTableCorrelationNames
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsDifferentTableCorrelationNames
- 定義:
supportsDifferentTableCorrelationNames
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsExpressionsInOrderBy
- 定義:
supportsExpressionsInOrderBy
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsGroupBy
- 定義:
supportsGroupBy
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsGroupByBeyondSelect
- 定義:
supportsGroupByBeyondSelect
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsLikeEscapeClause
- 定義:
supportsLikeEscapeClause
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsMultipleResultSets
- 定義:
supportsMultipleResultSets
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsMultipleTransactions
- 定義:
supportsMultipleTransactions
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsNonNullableColumns
- 定義:
supportsNonNullableColumns
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsMinimumSQLGrammar
This grammar is defined at: http://www.microsoft.com/msdn/sdk/platforms/doc/odbc/src/intropr.htm
In Appendix C. From this description, we seem to support the ODBC minimal (Level 0) grammar.
- 定義:
supportsMinimumSQLGrammar
インタフェース内DatabaseMetaData
- 戻り値:
- true
- 例外:
SQLException
-
supportsCoreSQLGrammar
Does this driver support the Core ODBC SQL grammar. We need SQL-92 conformance for this.- 定義:
supportsCoreSQLGrammar
インタフェース内DatabaseMetaData
- 戻り値:
- false
- 例外:
SQLException
- if a database access error occurs
-
supportsExtendedSQLGrammar
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.- 定義:
supportsExtendedSQLGrammar
インタフェース内DatabaseMetaData
- 戻り値:
- false
- 例外:
SQLException
- if a database access error occurs
-
supportsANSI92EntryLevelSQL
Does this driver support the ANSI-92 entry level SQL grammar? All JDBC Compliant drivers must return true. We currently report false until 'schema' support is added. Then this should be changed to return true, since we will be mostly compliant (probably more compliant than many other databases) And since this is a requirement for all JDBC drivers we need to get to the point where we can return true.- 定義:
supportsANSI92EntryLevelSQL
インタフェース内DatabaseMetaData
- 戻り値:
- true if connected to PostgreSQL 7.3+
- 例外:
SQLException
- if a database access error occurs
-
supportsANSI92IntermediateSQL
- 定義:
supportsANSI92IntermediateSQL
インタフェース内DatabaseMetaData
- 戻り値:
- false
- 例外:
SQLException
-
supportsANSI92FullSQL
- 定義:
supportsANSI92FullSQL
インタフェース内DatabaseMetaData
- 戻り値:
- false
- 例外:
SQLException
-
supportsIntegrityEnhancementFacility
- 定義:
supportsIntegrityEnhancementFacility
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsOuterJoins
- 定義:
supportsOuterJoins
インタフェース内DatabaseMetaData
- 戻り値:
- true if connected to PostgreSQL 7.1+
- 例外:
SQLException
-
supportsFullOuterJoins
- 定義:
supportsFullOuterJoins
インタフェース内DatabaseMetaData
- 戻り値:
- true if connected to PostgreSQL 7.1+
- 例外:
SQLException
-
supportsLimitedOuterJoins
- 定義:
supportsLimitedOuterJoins
インタフェース内DatabaseMetaData
- 戻り値:
- true if connected to PostgreSQL 7.1+
- 例外:
SQLException
-
getSchemaTerm
PostgreSQL doesn't have schemas, but when it does, we'll use the term "schema".
- 定義:
getSchemaTerm
インタフェース内DatabaseMetaData
- 戻り値:
"schema"
- 例外:
SQLException
-
getProcedureTerm
- 定義:
getProcedureTerm
インタフェース内DatabaseMetaData
- 戻り値:
"function"
- 例外:
SQLException
-
getCatalogTerm
- 定義:
getCatalogTerm
インタフェース内DatabaseMetaData
- 戻り値:
"database"
- 例外:
SQLException
-
isCatalogAtStart
- 定義:
isCatalogAtStart
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getCatalogSeparator
- 定義:
getCatalogSeparator
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsSchemasInDataManipulation
- 定義:
supportsSchemasInDataManipulation
インタフェース内DatabaseMetaData
- 戻り値:
- true if connected to PostgreSQL 7.3+
- 例外:
SQLException
-
supportsSchemasInProcedureCalls
- 定義:
supportsSchemasInProcedureCalls
インタフェース内DatabaseMetaData
- 戻り値:
- true if connected to PostgreSQL 7.3+
- 例外:
SQLException
-
supportsSchemasInTableDefinitions
- 定義:
supportsSchemasInTableDefinitions
インタフェース内DatabaseMetaData
- 戻り値:
- true if connected to PostgreSQL 7.3+
- 例外:
SQLException
-
supportsSchemasInIndexDefinitions
- 定義:
supportsSchemasInIndexDefinitions
インタフェース内DatabaseMetaData
- 戻り値:
- true if connected to PostgreSQL 7.3+
- 例外:
SQLException
-
supportsSchemasInPrivilegeDefinitions
- 定義:
supportsSchemasInPrivilegeDefinitions
インタフェース内DatabaseMetaData
- 戻り値:
- true if connected to PostgreSQL 7.3+
- 例外:
SQLException
-
supportsCatalogsInDataManipulation
- 定義:
supportsCatalogsInDataManipulation
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsCatalogsInProcedureCalls
- 定義:
supportsCatalogsInProcedureCalls
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsCatalogsInTableDefinitions
- 定義:
supportsCatalogsInTableDefinitions
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsCatalogsInIndexDefinitions
- 定義:
supportsCatalogsInIndexDefinitions
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsCatalogsInPrivilegeDefinitions
- 定義:
supportsCatalogsInPrivilegeDefinitions
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsPositionedDelete
We support cursors for gets only it seems. I dont see a method to get a positioned delete.- 定義:
supportsPositionedDelete
インタフェース内DatabaseMetaData
- 戻り値:
- false
- 例外:
SQLException
- if a database access error occurs
-
supportsPositionedUpdate
- 定義:
supportsPositionedUpdate
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsSelectForUpdate
- 定義:
supportsSelectForUpdate
インタフェース内DatabaseMetaData
- 戻り値:
- true if connected to PostgreSQL 6.5+
- 例外:
SQLException
-
supportsStoredProcedures
- 定義:
supportsStoredProcedures
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsSubqueriesInComparisons
- 定義:
supportsSubqueriesInComparisons
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsSubqueriesInExists
- 定義:
supportsSubqueriesInExists
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsSubqueriesInIns
- 定義:
supportsSubqueriesInIns
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsSubqueriesInQuantifieds
- 定義:
supportsSubqueriesInQuantifieds
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsUnion
- 定義:
supportsUnion
インタフェース内DatabaseMetaData
- 戻り値:
- true if connected to PostgreSQL 6.3+
- 例外:
SQLException
-
supportsUnionAll
- 定義:
supportsUnionAll
インタフェース内DatabaseMetaData
- 戻り値:
- true if connected to PostgreSQL 7.1+
- 例外:
SQLException
-
supportsOpenCursorsAcrossCommit
In PostgreSQL, Cursors are only open within transactions.- 定義:
supportsOpenCursorsAcrossCommit
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsOpenCursorsAcrossRollback
- 定義:
supportsOpenCursorsAcrossRollback
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsOpenStatementsAcrossCommit
Can statements remain open across commits? They may, but this driver cannot guarantee that. In further reflection. we are talking a Statement object here, so the answer is yes, since the Statement is only a vehicle to ExecSQL()
- 定義:
supportsOpenStatementsAcrossCommit
インタフェース内DatabaseMetaData
- 戻り値:
- true
- 例外:
SQLException
-
supportsOpenStatementsAcrossRollback
Can statements remain open across rollbacks? They may, but this driver cannot guarantee that. In further contemplation, we are talking a Statement object here, so the answer is yes, since the Statement is only a vehicle to ExecSQL() in Connection
- 定義:
supportsOpenStatementsAcrossRollback
インタフェース内DatabaseMetaData
- 戻り値:
- true
- 例外:
SQLException
-
getMaxCharLiteralLength
- 定義:
getMaxCharLiteralLength
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getMaxBinaryLiteralLength
- 定義:
getMaxBinaryLiteralLength
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getMaxColumnNameLength
- 定義:
getMaxColumnNameLength
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getMaxColumnsInGroupBy
- 定義:
getMaxColumnsInGroupBy
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getMaxColumnsInIndex
- 定義:
getMaxColumnsInIndex
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getMaxColumnsInOrderBy
- 定義:
getMaxColumnsInOrderBy
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getMaxColumnsInSelect
- 定義:
getMaxColumnsInSelect
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getMaxColumnsInTable
What is the maximum number of columns in a table? From the CREATE TABLE reference page..."The new class is created as a heap with no initial data. A class can have no more than 1600 attributes (realistically, this is limited by the fact that tuple sizes must be less than 8192 bytes)..."
- 定義:
getMaxColumnsInTable
インタフェース内DatabaseMetaData
- 戻り値:
- the max columns
- 例外:
SQLException
- if a database access error occurs
-
getMaxConnections
How many active connection can we have at a time to this database? Well, since it depends on postmaster, which just does a listen() followed by an accept() and fork(), its basically very high. Unless the system runs out of processes, it can be 65535 (the number of aux. ports on a TCP/IP system). I will return 8192 since that is what even the largest system can realistically handle,- 定義:
getMaxConnections
インタフェース内DatabaseMetaData
- 戻り値:
- the maximum number of connections
- 例外:
SQLException
- if a database access error occurs
-
getMaxCursorNameLength
- 定義:
getMaxCursorNameLength
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getMaxIndexLength
- 定義:
getMaxIndexLength
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getMaxSchemaNameLength
- 定義:
getMaxSchemaNameLength
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getMaxProcedureNameLength
- 定義:
getMaxProcedureNameLength
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getMaxCatalogNameLength
- 定義:
getMaxCatalogNameLength
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getMaxRowSize
- 定義:
getMaxRowSize
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
doesMaxRowSizeIncludeBlobs
- 定義:
doesMaxRowSizeIncludeBlobs
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getMaxStatementLength
- 定義:
getMaxStatementLength
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getMaxStatements
- 定義:
getMaxStatements
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getMaxTableNameLength
- 定義:
getMaxTableNameLength
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getMaxTablesInSelect
- 定義:
getMaxTablesInSelect
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getMaxUserNameLength
- 定義:
getMaxUserNameLength
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getDefaultTransactionIsolation
- 定義:
getDefaultTransactionIsolation
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsTransactions
- 定義:
supportsTransactions
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsTransactionIsolationLevel
We only support TRANSACTION_SERIALIZABLE and TRANSACTION_READ_COMMITTED before 8.0; from 8.0 READ_UNCOMMITTED and REPEATABLE_READ are accepted aliases for READ_COMMITTED.
- 定義:
supportsTransactionIsolationLevel
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsDataDefinitionAndDataManipulationTransactions
-
supportsDataManipulationTransactionsOnly
- 定義:
supportsDataManipulationTransactionsOnly
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
dataDefinitionCausesTransactionCommit
Does a data definition statement within a transaction force the transaction to commit? It seems to mean 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.
- 定義:
dataDefinitionCausesTransactionCommit
インタフェース内DatabaseMetaData
- 戻り値:
- true if so
- 例外:
SQLException
- if a database access error occurs
-
dataDefinitionIgnoredInTransactions
- 定義:
dataDefinitionIgnoredInTransactions
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
escapeQuotes
Turn the provided value into a valid string literal for direct inclusion into a query. This includes the single quotes needed around it.- パラメータ:
s
- input value- 戻り値:
- string literal for direct inclusion into a query
- 例外:
SQLException
- if something wrong happens
-
getProcedures
public ResultSet getProcedures(@Nullable String catalog, @Nullable String schemaPattern, @Nullable String procedureNamePattern) throws SQLException - 定義:
getProcedures
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getProcedureColumns
public ResultSet getProcedureColumns(@Nullable String catalog, @Nullable String schemaPattern, @Nullable String procedureNamePattern, @Nullable String columnNamePattern) throws SQLException - 定義:
getProcedureColumns
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getTables
public ResultSet getTables(@Nullable String catalog, @Nullable String schemaPattern, @Nullable String tableNamePattern, String @Nullable [] types) throws SQLException - 定義:
getTables
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getSchemas
- 定義:
getSchemas
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getSchemas
public ResultSet getSchemas(@Nullable String catalog, @Nullable String schemaPattern) throws SQLException - 定義:
getSchemas
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getCatalogs
- 定義:
getCatalogs
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getTableTypes
- 定義:
getTableTypes
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getColumns
public ResultSet getColumns(@Nullable String catalog, @Nullable String schemaPattern, @Nullable String tableNamePattern, @Nullable String columnNamePattern) throws SQLException - 定義:
getColumns
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getColumnPrivileges
public ResultSet getColumnPrivileges(@Nullable String catalog, @Nullable String schema, String table, @Nullable String columnNamePattern) throws SQLException - 定義:
getColumnPrivileges
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getTablePrivileges
public ResultSet getTablePrivileges(@Nullable String catalog, @Nullable String schemaPattern, @Nullable String tableNamePattern) throws SQLException - 定義:
getTablePrivileges
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
parseACL
public Map<String,Map<String, parseACLList<@Nullable String[]>>> (@Nullable String aclArray, String owner) Take the a String representing an array of ACLs and return a Map mapping the SQL permission name to a List of usernames who have that permission. For instance:SELECT -> user1 -> list of [grantor, grantable]
- パラメータ:
aclArray
- ACL arrayowner
- owner- 戻り値:
- a Map mapping the SQL permission name
-
getBestRowIdentifier
public ResultSet getBestRowIdentifier(@Nullable String catalog, @Nullable String schema, String table, int scope, boolean nullable) throws SQLException - 定義:
getBestRowIdentifier
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getVersionColumns
public ResultSet getVersionColumns(@Nullable String catalog, @Nullable String schema, String table) throws SQLException - 定義:
getVersionColumns
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getPrimaryKeys
public ResultSet getPrimaryKeys(@Nullable String catalog, @Nullable String schema, String table) throws SQLException - 定義:
getPrimaryKeys
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getPrimaryUniqueKeys
protected ResultSet getPrimaryUniqueKeys(@Nullable String catalog, @Nullable String schema, String table) throws SQLException - 例外:
SQLException
-
getImportedExportedKeys
protected ResultSet getImportedExportedKeys(@Nullable String primaryCatalog, @Nullable String primarySchema, @Nullable String primaryTable, @Nullable String foreignCatalog, @Nullable String foreignSchema, @Nullable String foreignTable) throws SQLException - パラメータ:
primaryCatalog
- primary catalogprimarySchema
- primary schemaprimaryTable
- if provided will get the keys exported by this tableforeignCatalog
- foreign catalogforeignSchema
- foreign schemaforeignTable
- if provided will get the keys imported by this table- 戻り値:
- ResultSet
- 例外:
SQLException
- if something wrong happens
-
getImportedKeys
public ResultSet getImportedKeys(@Nullable String catalog, @Nullable String schema, String table) throws SQLException - 定義:
getImportedKeys
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getExportedKeys
public ResultSet getExportedKeys(@Nullable String catalog, @Nullable String schema, String table) throws SQLException - 定義:
getExportedKeys
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getCrossReference
public ResultSet getCrossReference(@Nullable String primaryCatalog, @Nullable String primarySchema, String primaryTable, @Nullable String foreignCatalog, @Nullable String foreignSchema, String foreignTable) throws SQLException - 定義:
getCrossReference
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getTypeInfo
- 定義:
getTypeInfo
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getIndexInfo
public ResultSet getIndexInfo(@Nullable String catalog, @Nullable String schema, String tableName, boolean unique, boolean approximate) throws SQLException - 定義:
getIndexInfo
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsResultSetType
- 定義:
supportsResultSetType
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsResultSetConcurrency
- 定義:
supportsResultSetConcurrency
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
ownUpdatesAreVisible
- 定義:
ownUpdatesAreVisible
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
ownDeletesAreVisible
- 定義:
ownDeletesAreVisible
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
ownInsertsAreVisible
- 定義:
ownInsertsAreVisible
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
othersUpdatesAreVisible
- 定義:
othersUpdatesAreVisible
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
othersDeletesAreVisible
- 定義:
othersDeletesAreVisible
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
othersInsertsAreVisible
- 定義:
othersInsertsAreVisible
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
updatesAreDetected
- 定義:
updatesAreDetected
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
deletesAreDetected
- 定義:
deletesAreDetected
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
insertsAreDetected
- 定義:
insertsAreDetected
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsBatchUpdates
- 定義:
supportsBatchUpdates
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getUDTs
public ResultSet getUDTs(@Nullable String catalog, @Nullable String schemaPattern, @Nullable String typeNamePattern, int @Nullable [] types) throws SQLException - 定義:
getUDTs
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getConnection
- 定義:
getConnection
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
createMetaDataStatement
- 例外:
SQLException
-
getMaxLogicalLobSize
- 定義:
getMaxLogicalLobSize
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsRefCursors
- 定義:
supportsRefCursors
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getRowIdLifetime
- 定義:
getRowIdLifetime
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsStoredFunctionsUsingCallSyntax
- 定義:
supportsStoredFunctionsUsingCallSyntax
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
autoCommitFailureClosesAllResultSets
- 定義:
autoCommitFailureClosesAllResultSets
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getClientInfoProperties
- 定義:
getClientInfoProperties
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
isWrapperFor
- 定義:
isWrapperFor
インタフェース内Wrapper
- 例外:
SQLException
-
unwrap
- 定義:
unwrap
インタフェース内Wrapper
- 例外:
SQLException
-
getFunctions
public ResultSet getFunctions(@Nullable String catalog, @Nullable String schemaPattern, @Nullable String functionNamePattern) throws SQLException - 定義:
getFunctions
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getFunctionColumns
public ResultSet getFunctionColumns(@Nullable String catalog, @Nullable String schemaPattern, @Nullable String functionNamePattern, @Nullable String columnNamePattern) throws SQLException - 定義:
getFunctionColumns
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getPseudoColumns
public ResultSet getPseudoColumns(@Nullable String catalog, @Nullable String schemaPattern, @Nullable String tableNamePattern, @Nullable String columnNamePattern) throws SQLException - 定義:
getPseudoColumns
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
generatedKeyAlwaysReturned
- 定義:
generatedKeyAlwaysReturned
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsSavepoints
- 定義:
supportsSavepoints
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsNamedParameters
- 定義:
supportsNamedParameters
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsMultipleOpenResults
- 定義:
supportsMultipleOpenResults
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsGetGeneratedKeys
- 定義:
supportsGetGeneratedKeys
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getSuperTypes
public ResultSet getSuperTypes(@Nullable String catalog, @Nullable String schemaPattern, @Nullable String typeNamePattern) throws SQLException - 定義:
getSuperTypes
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getSuperTables
public ResultSet getSuperTables(@Nullable String catalog, @Nullable String schemaPattern, @Nullable String tableNamePattern) throws SQLException - 定義:
getSuperTables
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getAttributes
public ResultSet getAttributes(@Nullable String catalog, @Nullable String schemaPattern, @Nullable String typeNamePattern, @Nullable String attributeNamePattern) throws SQLException - 定義:
getAttributes
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsResultSetHoldability
- 定義:
supportsResultSetHoldability
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getResultSetHoldability
- 定義:
getResultSetHoldability
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getDatabaseMajorVersion
- 定義:
getDatabaseMajorVersion
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getDatabaseMinorVersion
- 定義:
getDatabaseMinorVersion
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
getJDBCMajorVersion
public int getJDBCMajorVersion()- 定義:
getJDBCMajorVersion
インタフェース内DatabaseMetaData
-
getJDBCMinorVersion
public int getJDBCMinorVersion()- 定義:
getJDBCMinorVersion
インタフェース内DatabaseMetaData
-
getSQLStateType
- 定義:
getSQLStateType
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
locatorsUpdateCopy
- 定義:
locatorsUpdateCopy
インタフェース内DatabaseMetaData
- 例外:
SQLException
-
supportsStatementPooling
- 定義:
supportsStatementPooling
インタフェース内DatabaseMetaData
- 例外:
SQLException
-