org.postgresql.jdbc2
Class AbstractJdbc2DatabaseMetaData

java.lang.Object
  org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData

Direct Known Subclasses:

AbstractJdbc3DatabaseMetaData

public abstract class AbstractJdbc2DatabaseMetaData
extends java.lang.Object

Field Summary

protected AbstractJdbc2Connection

connection

Constructor Summary

AbstractJdbc2DatabaseMetaData(AbstractJdbc2Connection conn)

Method Summary

boolean	allProceduresAreCallable()
boolean	allTablesAreSelectable()
protected java.sql.Statement	createMetaDataStatement()
boolean	dataDefinitionCausesTransactionCommit()
boolean	dataDefinitionIgnoredInTransactions()
boolean	deletesAreDetected(int i)
boolean	doesMaxRowSizeIncludeBlobs()
protected java.lang.String	escapeQuotes(java.lang.String s) Escape single quotes with another single quote, escape backslashes as needed.
java.sql.ResultSet	getBestRowIdentifier(java.lang.String catalog, java.lang.String schema, java.lang.String table, int scope, boolean nullable)
java.sql.ResultSet	getCatalogs()
java.lang.String	getCatalogSeparator()
java.lang.String	getCatalogTerm()
java.sql.ResultSet	getColumnPrivileges(java.lang.String catalog, java.lang.String schema, java.lang.String table, java.lang.String columnNamePattern)
java.sql.ResultSet	getColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String columnNamePattern)
java.sql.Connection	getConnection()
java.sql.ResultSet	getCrossReference(java.lang.String primaryCatalog, java.lang.String primarySchema, java.lang.String primaryTable, java.lang.String foreignCatalog, java.lang.String foreignSchema, java.lang.String foreignTable)
java.lang.String	getDatabaseProductName()
java.lang.String	getDatabaseProductVersion()
int	getDefaultTransactionIsolation()
int	getDriverMajorVersion()
int	getDriverMinorVersion()
java.lang.String	getDriverName()
java.lang.String	getDriverVersion()
java.sql.ResultSet	getExportedKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table)
java.lang.String	getExtraNameCharacters()
java.lang.String	getIdentifierQuoteString()
protected java.sql.ResultSet	getImportedExportedKeys(java.lang.String primaryCatalog, java.lang.String primarySchema, java.lang.String primaryTable, java.lang.String foreignCatalog, java.lang.String foreignSchema, java.lang.String foreignTable)
java.sql.ResultSet	getImportedKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table)
java.sql.ResultSet	getIndexInfo(java.lang.String catalog, java.lang.String schema, java.lang.String tableName, boolean unique, boolean approximate)
int	getMaxBinaryLiteralLength()
int	getMaxCatalogNameLength()
int	getMaxCharLiteralLength()
int	getMaxColumnNameLength()
int	getMaxColumnsInGroupBy()
int	getMaxColumnsInIndex()
int	getMaxColumnsInOrderBy()
int	getMaxColumnsInSelect()
int	getMaxColumnsInTable()
int	getMaxConnections()
int	getMaxCursorNameLength()
protected int	getMaxIndexKeys()
int	getMaxIndexLength()
protected int	getMaxNameLength()
int	getMaxProcedureNameLength()
int	getMaxRowSize()
int	getMaxSchemaNameLength()
int	getMaxStatementLength()
int	getMaxStatements()
int	getMaxTableNameLength()
int	getMaxTablesInSelect()
int	getMaxUserNameLength()
java.lang.String	getNumericFunctions() get supported escaped numeric functions
java.sql.ResultSet	getPrimaryKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table)
java.sql.ResultSet	getProcedureColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedureNamePattern, java.lang.String columnNamePattern)
java.sql.ResultSet	getProcedures(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedureNamePattern)
java.lang.String	getProcedureTerm()
java.sql.ResultSet	getSchemas()
java.lang.String	getSchemaTerm()
java.lang.String	getSearchStringEscape()
java.lang.String	getSQLKeywords()
java.lang.String	getStringFunctions()
java.lang.String	getSystemFunctions()
java.sql.ResultSet	getTablePrivileges(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern)
java.sql.ResultSet	getTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String[] types)
java.sql.ResultSet	getTableTypes()
java.lang.String	getTimeDateFunctions()
java.sql.ResultSet	getTypeInfo()
java.sql.ResultSet	getUDTs(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, int[] types)
java.lang.String	getURL()
java.lang.String	getUserName()
java.sql.ResultSet	getVersionColumns(java.lang.String catalog, java.lang.String schema, java.lang.String table)
boolean	insertsAreDetected(int type)
boolean	isCatalogAtStart()
boolean	isReadOnly()
boolean	nullPlusNonNullIsNull()
boolean	nullsAreSortedAtEnd()
boolean	nullsAreSortedAtStart()
boolean	nullsAreSortedHigh()
boolean	nullsAreSortedLow()
boolean	othersDeletesAreVisible(int i)
boolean	othersInsertsAreVisible(int type)
boolean	othersUpdatesAreVisible(int type)
boolean	ownDeletesAreVisible(int type)
boolean	ownInsertsAreVisible(int type)
boolean	ownUpdatesAreVisible(int type)
protected java.util.Hashtable	parseACL(java.lang.String aclArray, java.lang.String owner) Take the a String representing an array of ACLs and return a Hashtable mapping the SQL permission name to a Vector of usernames who have that permission.
boolean	rowChangesAreDetected(int type)
boolean	rowChangesAreVisible(int type)
boolean	storesLowerCaseIdentifiers()
boolean	storesLowerCaseQuotedIdentifiers()
boolean	storesMixedCaseIdentifiers()
boolean	storesMixedCaseQuotedIdentifiers()
boolean	storesUpperCaseIdentifiers()
boolean	storesUpperCaseQuotedIdentifiers()
boolean	supportsAlterTableWithAddColumn()
boolean	supportsAlterTableWithDropColumn()
boolean	supportsANSI92EntryLevelSQL()
boolean	supportsANSI92FullSQL()
boolean	supportsANSI92IntermediateSQL()
boolean	supportsBatchUpdates()
boolean	supportsCatalogsInDataManipulation()
boolean	supportsCatalogsInIndexDefinitions()
boolean	supportsCatalogsInPrivilegeDefinitions()
boolean	supportsCatalogsInProcedureCalls()
boolean	supportsCatalogsInTableDefinitions()
boolean	supportsColumnAliasing()
boolean	supportsConvert()
boolean	supportsConvert(int fromType, int toType)
boolean	supportsCoreSQLGrammar()
boolean	supportsCorrelatedSubqueries()
boolean	supportsDataDefinitionAndDataManipulationTransactions()
boolean	supportsDataManipulationTransactionsOnly()
boolean	supportsDifferentTableCorrelationNames()
boolean	supportsExpressionsInOrderBy()
boolean	supportsExtendedSQLGrammar()
boolean	supportsFullOuterJoins()
boolean	supportsGroupBy()
boolean	supportsGroupByBeyondSelect()
boolean	supportsGroupByUnrelated()
boolean	supportsIntegrityEnhancementFacility()
boolean	supportsLikeEscapeClause()
boolean	supportsLimitedOuterJoins()
boolean	supportsMinimumSQLGrammar()
boolean	supportsMixedCaseIdentifiers()
boolean	supportsMixedCaseQuotedIdentifiers()
boolean	supportsMultipleResultSets()
boolean	supportsMultipleTransactions()
boolean	supportsNonNullableColumns()
boolean	supportsOpenCursorsAcrossCommit()
boolean	supportsOpenCursorsAcrossRollback()
boolean	supportsOpenStatementsAcrossCommit()
boolean	supportsOpenStatementsAcrossRollback()
boolean	supportsOrderByUnrelated()
boolean	supportsOuterJoins()
boolean	supportsPositionedDelete()
boolean	supportsPositionedUpdate()
boolean	supportsResultSetConcurrency(int type, int concurrency)
boolean	supportsResultSetType(int type)
boolean	supportsSchemasInDataManipulation()
boolean	supportsSchemasInIndexDefinitions()
boolean	supportsSchemasInPrivilegeDefinitions()
boolean	supportsSchemasInProcedureCalls()
boolean	supportsSchemasInTableDefinitions()
boolean	supportsSelectForUpdate()
boolean	supportsStoredProcedures()
boolean	supportsSubqueriesInComparisons()
boolean	supportsSubqueriesInExists()
boolean	supportsSubqueriesInIns()
boolean	supportsSubqueriesInQuantifieds()
boolean	supportsTableCorrelationNames()
boolean	supportsTransactionIsolationLevel(int level)
boolean	supportsTransactions()
boolean	supportsUnion()
boolean	supportsUnionAll()
boolean	updatesAreDetected(int type)
boolean	usesLocalFilePerTable()
boolean	usesLocalFiles()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

connection

protected final AbstractJdbc2Connection connection

Constructor Detail

AbstractJdbc2DatabaseMetaData

public AbstractJdbc2DatabaseMetaData(AbstractJdbc2Connection conn)

Method Detail

getMaxIndexKeys

protected int getMaxIndexKeys()
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

getMaxNameLength

protected int getMaxNameLength()
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

allProceduresAreCallable

public boolean allProceduresAreCallable()
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

allTablesAreSelectable

public boolean allTablesAreSelectable()
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

getURL

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

Throws:

java.sql.SQLException

getUserName

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

Throws:

java.sql.SQLException

isReadOnly

public boolean isReadOnly()
                   throws java.sql.SQLException

Throws:

java.sql.SQLException

nullsAreSortedHigh

public boolean nullsAreSortedHigh()
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

nullsAreSortedLow

public boolean nullsAreSortedLow()
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

nullsAreSortedAtStart

public boolean nullsAreSortedAtStart()
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

nullsAreSortedAtEnd

public boolean nullsAreSortedAtEnd()
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

getDatabaseProductName

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

Throws:

java.sql.SQLException

getDatabaseProductVersion

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

Throws:

java.sql.SQLException

getDriverName

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

Throws:

java.sql.SQLException

getDriverVersion

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

Throws:

java.sql.SQLException

getDriverMajorVersion

public int getDriverMajorVersion()

getDriverMinorVersion

public int getDriverMinorVersion()

usesLocalFiles

public boolean usesLocalFiles()
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

usesLocalFilePerTable

public boolean usesLocalFilePerTable()
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsMixedCaseIdentifiers

public boolean supportsMixedCaseIdentifiers()
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

storesUpperCaseIdentifiers

public boolean storesUpperCaseIdentifiers()
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

storesLowerCaseIdentifiers

public boolean storesLowerCaseIdentifiers()
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

storesMixedCaseIdentifiers

public boolean storesMixedCaseIdentifiers()
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsMixedCaseQuotedIdentifiers

public boolean supportsMixedCaseQuotedIdentifiers()
                                           throws java.sql.SQLException

Throws:

java.sql.SQLException

storesUpperCaseQuotedIdentifiers

public boolean storesUpperCaseQuotedIdentifiers()
                                         throws java.sql.SQLException

Throws:

java.sql.SQLException

storesLowerCaseQuotedIdentifiers

public boolean storesLowerCaseQuotedIdentifiers()
                                         throws java.sql.SQLException

Throws:

java.sql.SQLException

storesMixedCaseQuotedIdentifiers

public boolean storesMixedCaseQuotedIdentifiers()
                                         throws java.sql.SQLException

Throws:

java.sql.SQLException

getIdentifierQuoteString

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

Throws:

java.sql.SQLException

getSQLKeywords

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

Throws:

java.sql.SQLException

getNumericFunctions

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

get supported escaped numeric functions

Returns:

a comma separated list of function names

Throws:

java.sql.SQLException

getStringFunctions

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

Throws:

java.sql.SQLException

getSystemFunctions

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

Throws:

java.sql.SQLException

getTimeDateFunctions

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

Throws:

java.sql.SQLException

getSearchStringEscape

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

Throws:

java.sql.SQLException

getExtraNameCharacters

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

Throws:

java.sql.SQLException

supportsAlterTableWithAddColumn

public boolean supportsAlterTableWithAddColumn()
                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsAlterTableWithDropColumn

public boolean supportsAlterTableWithDropColumn()
                                         throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsColumnAliasing

public boolean supportsColumnAliasing()
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

nullPlusNonNullIsNull

public boolean nullPlusNonNullIsNull()
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsConvert

public boolean supportsConvert()
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsConvert

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

Throws:

java.sql.SQLException

supportsTableCorrelationNames

public boolean supportsTableCorrelationNames()
                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsDifferentTableCorrelationNames

public boolean supportsDifferentTableCorrelationNames()
                                               throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsExpressionsInOrderBy

public boolean supportsExpressionsInOrderBy()
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsOrderByUnrelated

public boolean supportsOrderByUnrelated()
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsGroupBy

public boolean supportsGroupBy()
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsGroupByUnrelated

public boolean supportsGroupByUnrelated()
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsGroupByBeyondSelect

public boolean supportsGroupByBeyondSelect()
                                    throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsLikeEscapeClause

public boolean supportsLikeEscapeClause()
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsMultipleResultSets

public boolean supportsMultipleResultSets()
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsMultipleTransactions

public boolean supportsMultipleTransactions()
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsNonNullableColumns

public boolean supportsNonNullableColumns()
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsMinimumSQLGrammar

public boolean supportsMinimumSQLGrammar()
                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsCoreSQLGrammar

public boolean supportsCoreSQLGrammar()
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsExtendedSQLGrammar

public boolean supportsExtendedSQLGrammar()
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsANSI92EntryLevelSQL

public boolean supportsANSI92EntryLevelSQL()
                                    throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsANSI92IntermediateSQL

public boolean supportsANSI92IntermediateSQL()
                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsANSI92FullSQL

public boolean supportsANSI92FullSQL()
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsIntegrityEnhancementFacility

public boolean supportsIntegrityEnhancementFacility()
                                             throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsOuterJoins

public boolean supportsOuterJoins()
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsFullOuterJoins

public boolean supportsFullOuterJoins()
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsLimitedOuterJoins

public boolean supportsLimitedOuterJoins()
                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

getSchemaTerm

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

Throws:

java.sql.SQLException

getProcedureTerm

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

Throws:

java.sql.SQLException

getCatalogTerm

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

Throws:

java.sql.SQLException

isCatalogAtStart

public boolean isCatalogAtStart()
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

getCatalogSeparator

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

Throws:

java.sql.SQLException

supportsSchemasInDataManipulation

public boolean supportsSchemasInDataManipulation()
                                          throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsSchemasInProcedureCalls

public boolean supportsSchemasInProcedureCalls()
                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsSchemasInTableDefinitions

public boolean supportsSchemasInTableDefinitions()
                                          throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsSchemasInIndexDefinitions

public boolean supportsSchemasInIndexDefinitions()
                                          throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsSchemasInPrivilegeDefinitions

public boolean supportsSchemasInPrivilegeDefinitions()
                                              throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsCatalogsInDataManipulation

public boolean supportsCatalogsInDataManipulation()
                                           throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsCatalogsInProcedureCalls

public boolean supportsCatalogsInProcedureCalls()
                                         throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsCatalogsInTableDefinitions

public boolean supportsCatalogsInTableDefinitions()
                                           throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsCatalogsInIndexDefinitions

public boolean supportsCatalogsInIndexDefinitions()
                                           throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsCatalogsInPrivilegeDefinitions

public boolean supportsCatalogsInPrivilegeDefinitions()
                                               throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsPositionedDelete

public boolean supportsPositionedDelete()
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsPositionedUpdate

public boolean supportsPositionedUpdate()
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsSelectForUpdate

public boolean supportsSelectForUpdate()
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsStoredProcedures

public boolean supportsStoredProcedures()
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsSubqueriesInComparisons

public boolean supportsSubqueriesInComparisons()
                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsSubqueriesInExists

public boolean supportsSubqueriesInExists()
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsSubqueriesInIns

public boolean supportsSubqueriesInIns()
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsSubqueriesInQuantifieds

public boolean supportsSubqueriesInQuantifieds()
                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsCorrelatedSubqueries

public boolean supportsCorrelatedSubqueries()
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsUnion

public boolean supportsUnion()
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsUnionAll

public boolean supportsUnionAll()
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsOpenCursorsAcrossCommit

public boolean supportsOpenCursorsAcrossCommit()
                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsOpenCursorsAcrossRollback

public boolean supportsOpenCursorsAcrossRollback()
                                          throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsOpenStatementsAcrossCommit

public boolean supportsOpenStatementsAcrossCommit()
                                           throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsOpenStatementsAcrossRollback

public boolean supportsOpenStatementsAcrossRollback()
                                             throws java.sql.SQLException

Throws:

java.sql.SQLException

getMaxBinaryLiteralLength

public int getMaxBinaryLiteralLength()
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

getMaxCharLiteralLength

public int getMaxCharLiteralLength()
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

getMaxColumnNameLength

public int getMaxColumnNameLength()
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

getMaxColumnsInGroupBy

public int getMaxColumnsInGroupBy()
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

getMaxColumnsInIndex

public int getMaxColumnsInIndex()
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

getMaxColumnsInOrderBy

public int getMaxColumnsInOrderBy()
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

getMaxColumnsInSelect

public int getMaxColumnsInSelect()
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

getMaxColumnsInTable

public int getMaxColumnsInTable()
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

getMaxConnections

public int getMaxConnections()
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getMaxCursorNameLength

public int getMaxCursorNameLength()
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

getMaxIndexLength

public int getMaxIndexLength()
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getMaxSchemaNameLength

public int getMaxSchemaNameLength()
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

getMaxProcedureNameLength

public int getMaxProcedureNameLength()
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

getMaxCatalogNameLength

public int getMaxCatalogNameLength()
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

getMaxRowSize

public int getMaxRowSize()
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

doesMaxRowSizeIncludeBlobs

public boolean doesMaxRowSizeIncludeBlobs()
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

getMaxStatementLength

public int getMaxStatementLength()
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

getMaxStatements

public int getMaxStatements()
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

getMaxTableNameLength

public int getMaxTableNameLength()
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

getMaxTablesInSelect

public int getMaxTablesInSelect()
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

getMaxUserNameLength

public int getMaxUserNameLength()
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

getDefaultTransactionIsolation

public int getDefaultTransactionIsolation()
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsTransactions

public boolean supportsTransactions()
                             throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsTransactionIsolationLevel

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

Throws:

java.sql.SQLException

supportsDataDefinitionAndDataManipulationTransactions

public boolean supportsDataDefinitionAndDataManipulationTransactions()
                                                              throws java.sql.SQLException

Throws:

java.sql.SQLException

supportsDataManipulationTransactionsOnly

public boolean supportsDataManipulationTransactionsOnly()
                                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

dataDefinitionCausesTransactionCommit

public boolean dataDefinitionCausesTransactionCommit()
                                              throws java.sql.SQLException

Throws:

java.sql.SQLException

dataDefinitionIgnoredInTransactions

public boolean dataDefinitionIgnoredInTransactions()
                                            throws java.sql.SQLException

Throws:

java.sql.SQLException

escapeQuotes

protected java.lang.String escapeQuotes(java.lang.String s)
                                 throws java.sql.SQLException

Escape single quotes with another single quote, escape backslashes as needed.

Throws:

java.sql.SQLException

getProcedures

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

Throws:

java.sql.SQLException

getProcedureColumns

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

Throws:

java.sql.SQLException

getTables

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

Throws:

java.sql.SQLException

getSchemas

public java.sql.ResultSet getSchemas()
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

getCatalogs

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

Throws:

java.sql.SQLException

getTableTypes

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

Throws:

java.sql.SQLException

getColumns

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

Throws:

java.sql.SQLException

getColumnPrivileges

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

Throws:

java.sql.SQLException

getTablePrivileges

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

Throws:

java.sql.SQLException

parseACL

protected java.util.Hashtable parseACL(java.lang.String aclArray,
                                       java.lang.String owner)

Take the a String representing an array of ACLs and return a Hashtable mapping the SQL permission name to a Vector of usernames who have that permission.

getBestRowIdentifier

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

Throws:

java.sql.SQLException

getVersionColumns

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

Throws:

java.sql.SQLException

getPrimaryKeys

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

Throws:

java.sql.SQLException

getImportedExportedKeys

protected java.sql.ResultSet getImportedExportedKeys(java.lang.String primaryCatalog,
                                                     java.lang.String primarySchema,
                                                     java.lang.String primaryTable,
                                                     java.lang.String foreignCatalog,
                                                     java.lang.String foreignSchema,
                                                     java.lang.String foreignTable)
                                              throws java.sql.SQLException

Parameters:

primaryCatalog -

primarySchema -

primaryTable - if provided will get the keys exported by this table

foreignTable - if provided will get the keys imported by this table

Returns:

ResultSet

Throws:

java.sql.SQLException

getImportedKeys

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

Throws:

java.sql.SQLException

getExportedKeys

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

Throws:

java.sql.SQLException

getCrossReference

public java.sql.ResultSet getCrossReference(java.lang.String primaryCatalog,
                                            java.lang.String primarySchema,
                                            java.lang.String primaryTable,
                                            java.lang.String foreignCatalog,
                                            java.lang.String foreignSchema,
                                            java.lang.String foreignTable)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

getTypeInfo

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

Throws:

java.sql.SQLException

getIndexInfo

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

Throws:

java.sql.SQLException

supportsResultSetType

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

Throws:

java.sql.SQLException

supportsResultSetConcurrency

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

Throws:

java.sql.SQLException

ownUpdatesAreVisible

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

Throws:

java.sql.SQLException

ownDeletesAreVisible

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

Throws:

java.sql.SQLException

ownInsertsAreVisible

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

Throws:

java.sql.SQLException

othersUpdatesAreVisible

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

Throws:

java.sql.SQLException

othersDeletesAreVisible

public boolean othersDeletesAreVisible(int i)
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

othersInsertsAreVisible

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

Throws:

java.sql.SQLException

updatesAreDetected

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

Throws:

java.sql.SQLException

deletesAreDetected

public boolean deletesAreDetected(int i)
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

insertsAreDetected

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

Throws:

java.sql.SQLException

supportsBatchUpdates

public boolean supportsBatchUpdates()
                             throws java.sql.SQLException

Throws:

java.sql.SQLException

getUDTs

public java.sql.ResultSet getUDTs(java.lang.String catalog,
                                  java.lang.String schemaPattern,
                                  java.lang.String typeNamePattern,
                                  int[] types)
                           throws java.sql.SQLException

Parameters:

catalog - String

schemaPattern - String

typeNamePattern - String

types - int[]

Returns:

ResultSet

Throws:

java.sql.SQLException

getConnection

public java.sql.Connection getConnection()
                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

rowChangesAreDetected

public boolean rowChangesAreDetected(int type)
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

rowChangesAreVisible

public boolean rowChangesAreVisible(int type)
                             throws java.sql.SQLException

Throws:

java.sql.SQLException

createMetaDataStatement

protected java.sql.Statement createMetaDataStatement()
                                              throws java.sql.SQLException

Throws:

java.sql.SQLException