Java Doc for DatabaseMetaData.java in  » Database-DBMS » db-derby-10.2 » org » apache » derby » client » am » Java Source Code / Java DocumentationJava Source Code and Java Documentation

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


java.lang.Object
   org.apache.derby.client.am.DatabaseMetaData

All known Subclasses:   org.apache.derby.client.net.NetDatabaseMetaData,
DatabaseMetaData
abstract public class DatabaseMetaData implements java.sql.DatabaseMetaData(Code)


Field Summary
protected  Agentagent_
    
protected  Connectionconnection_
    
public  ProductLevelproductLevel_
    
public  booleanuseServerXAState_
    

Constructor Summary
protected  DatabaseMetaData(Agent agent, Connection connection, ProductLevel productLevel)
    

Method Summary
public  booleanallProceduresAreCallable()
    
public  booleanallTablesAreSelectable()
    
final public  booleanautoCommitFailureClosesAllResultSets()
     Retrieves whether an SQLException will cause all open ResultSets to be closed when auto-commit is true.
protected  voidcheckForClosedConnection()
     A "public" version of checkForClosedConnection() that throws SQLException instead of SqlException.
protected  voidcheckServerJdbcVersionX(String method, int major, int minor)
     Checks whether the server supports a JDBC version.
abstract protected  voidcomputeFeatureSet_()
    
public  booleandataDefinitionCausesTransactionCommit()
    
public  booleandataDefinitionIgnoredInTransactions()
    
public  booleandeletesAreDetected(int type)
    
public  booleandoesMaxRowSizeIncludeBlobs()
    
public  java.sql.ResultSetgetAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern)
    
public  java.sql.ResultSetgetBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable)
    
public  StringgetCatalogSeparator()
    
public  StringgetCatalogTerm()
    
public  java.sql.ResultSetgetCatalogs()
    
public  ResultSetgetClientInfoProperties()
     Returns a list of the client info properties supported by the driver.
public  java.sql.ResultSetgetColumnPrivileges(String catalog, String schema, String table, String columnNamePattern)
    
public  java.sql.ResultSetgetColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)
    
public  java.sql.ConnectiongetConnection()
    
public  java.sql.ResultSetgetCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable)
    
public  intgetDatabaseMajorVersion()
    
public  intgetDatabaseMinorVersion()
    
public  StringgetDatabaseProductName()
    
public  StringgetDatabaseProductVersion()
    
public  intgetDefaultTransactionIsolation()
    
public  intgetDriverMajorVersion()
    
public  intgetDriverMinorVersion()
    
public  StringgetDriverName()
    
public  StringgetDriverVersion()
    
public  java.sql.ResultSetgetExportedKeys(String catalog, String schema, String table)
    
public  StringgetExtraNameCharacters()
    
public  java.sql.ResultSetgetFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String parameterNamePattern)
     Get the function names available in the database.
public  java.sql.ResultSetgetFunctions(String catalog, String schemaPattern, String functionNamePattern)
     Get the function names available in the database.
public  StringgetIdentifierQuoteString()
    
public  java.sql.ResultSetgetImportedKeys(String catalog, String schema, String table)
    
public  java.sql.ResultSetgetIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate)
    
public  intgetJDBCMajorVersion()
    
public  intgetJDBCMinorVersion()
    
public  intgetMaxBinaryLiteralLength()
    
public  intgetMaxCatalogNameLength()
    
public  intgetMaxCharLiteralLength()
    
public  intgetMaxColumnNameLength()
    
public  intgetMaxColumnsInGroupBy()
    
public  intgetMaxColumnsInIndex()
    
public  intgetMaxColumnsInOrderBy()
    
public  intgetMaxColumnsInSelect()
    
public  intgetMaxColumnsInTable()
    
public  intgetMaxConnections()
    
public  intgetMaxCursorNameLength()
    
public  intgetMaxIndexLength()
    
public  intgetMaxProcedureNameLength()
    
public  intgetMaxRowSize()
    
public  intgetMaxSchemaNameLength()
    
public  intgetMaxStatementLength()
    
public  intgetMaxStatements()
    
public  intgetMaxTableNameLength()
    
public  intgetMaxTablesInSelect()
    
public  intgetMaxUserNameLength()
    
public  StringgetNumericFunctions()
    
public  java.sql.ResultSetgetPrimaryKeys(String catalog, String schema, String table)
    
public  java.sql.ResultSetgetProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern)
    
public  StringgetProcedureTerm()
    
public  java.sql.ResultSetgetProcedures(String catalog, String schemaPattern, String procedureNamePattern)
    
public  intgetResultSetHoldability()
    
public  StringgetSQLKeywords()
    
public  intgetSQLStateType()
    
public  StringgetSchemaTerm()
    
public  java.sql.ResultSetgetSchemas()
    
public  ResultSetgetSchemas(String catalog, String schemaPattern)
     Get the schema names available in this database.
public  StringgetSearchStringEscape()
    
public  StringgetStringFunctions()
    
public  java.sql.ResultSetgetSuperTables(String catalog, String schemaPattern, String tableNamePattern)
    
public  java.sql.ResultSetgetSuperTypes(String catalog, String schemaPattern, String typeNamePattern)
    
public  StringgetSystemFunctions()
    
public  java.sql.ResultSetgetTablePrivileges(String catalog, String schemaPattern, String tableNamePattern)
    
public  java.sql.ResultSetgetTableTypes()
    
public  java.sql.ResultSetgetTables(String catalog, String schemaPattern, String tableNamePattern, String types)
    
public  StringgetTimeDateFunctions()
    
public  java.sql.ResultSetgetTypeInfo()
    
public  java.sql.ResultSetgetUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types)
    
public  StringgetURL()
    
abstract public  StringgetURL_()
    
public  StringgetUserName()
    
public  java.sql.ResultSetgetVersionColumns(String catalog, String schema, String table)
    
public  booleaninsertsAreDetected(int type)
    
public  booleanisCatalogAtStart()
    
public  booleanisReadOnly()
    
public  booleanlocatorsUpdateCopy()
    
public  booleannullPlusNonNullIsNull()
    
public  booleannullsAreSortedAtEnd()
    
public  booleannullsAreSortedAtStart()
    
public  booleannullsAreSortedHigh()
    
public  booleannullsAreSortedLow()
    
public  booleanothersDeletesAreVisible(int type)
    
public  booleanothersInsertsAreVisible(int type)
    
public  booleanothersUpdatesAreVisible(int type)
    
public  booleanownDeletesAreVisible(int type)
    
public  booleanownInsertsAreVisible(int type)
    
public  booleanownUpdatesAreVisible(int type)
    
final public  booleanprovidesQueryObjectGenerator()
     Retrieves whether this JDBC driver provides its own QueryObjectGenerator.
public  booleanstoresLowerCaseIdentifiers()
    
public  booleanstoresLowerCaseQuotedIdentifiers()
    
public  booleanstoresMixedCaseIdentifiers()
    
public  booleanstoresMixedCaseQuotedIdentifiers()
    
public  booleanstoresUpperCaseIdentifiers()
    
public  booleanstoresUpperCaseQuotedIdentifiers()
    
public  booleansupportsANSI92EntryLevelSQL()
    
public  booleansupportsANSI92FullSQL()
    
public  booleansupportsANSI92IntermediateSQL()
    
public  booleansupportsAlterTableWithAddColumn()
    
public  booleansupportsAlterTableWithDropColumn()
    
public  booleansupportsBatchUpdates()
    
public  booleansupportsCatalogsInDataManipulation()
    
public  booleansupportsCatalogsInIndexDefinitions()
    
public  booleansupportsCatalogsInPrivilegeDefinitions()
    
public  booleansupportsCatalogsInProcedureCalls()
    
public  booleansupportsCatalogsInTableDefinitions()
    
public  booleansupportsColumnAliasing()
    
public  booleansupportsConvert()
    
public  booleansupportsConvert(int fromType, int toType)
    
public  booleansupportsCoreSQLGrammar()
    
public  booleansupportsCorrelatedSubqueries()
    
public  booleansupportsDataDefinitionAndDataManipulationTransactions()
    
public  booleansupportsDataManipulationTransactionsOnly()
    
public  booleansupportsDifferentTableCorrelationNames()
    
public  booleansupportsExpressionsInOrderBy()
    
public  booleansupportsExtendedSQLGrammar()
    
public  booleansupportsFullOuterJoins()
    
public  booleansupportsGetGeneratedKeys()
    
public  booleansupportsGroupBy()
    
public  booleansupportsGroupByBeyondSelect()
    
public  booleansupportsGroupByUnrelated()
    
public  booleansupportsIntegrityEnhancementFacility()
    
public  booleansupportsLikeEscapeClause()
    
public  booleansupportsLimitedOuterJoins()
    
public  booleansupportsMinimumSQLGrammar()
    
public  booleansupportsMixedCaseIdentifiers()
    
public  booleansupportsMixedCaseQuotedIdentifiers()
    
public  booleansupportsMultipleOpenResults()
    
public  booleansupportsMultipleResultSets()
    
public  booleansupportsMultipleTransactions()
    
public  booleansupportsNamedParameters()
    
public  booleansupportsNonNullableColumns()
    
public  booleansupportsOpenCursorsAcrossCommit()
    
public  booleansupportsOpenCursorsAcrossRollback()
    
public  booleansupportsOpenStatementsAcrossCommit()
    
public  booleansupportsOpenStatementsAcrossRollback()
    
public  booleansupportsOrderByUnrelated()
    
public  booleansupportsOuterJoins()
    
public  booleansupportsPositionedDelete()
    
public  booleansupportsPositionedUpdate()
    
public  booleansupportsResultSetConcurrency(int type, int concurrency)
    
public  booleansupportsResultSetHoldability(int holdability)
    
public  booleansupportsResultSetType(int type)
    
public  booleansupportsSavepoints()
    
public  booleansupportsSchemasInDataManipulation()
    
public  booleansupportsSchemasInIndexDefinitions()
    
public  booleansupportsSchemasInPrivilegeDefinitions()
    
public  booleansupportsSchemasInProcedureCalls()
    
public  booleansupportsSchemasInTableDefinitions()
    
public  booleansupportsSelectForUpdate()
    
public  booleansupportsStatementPooling()
    
final public  booleansupportsStoredFunctionsUsingCallSyntax()
     Retrieves whether this database supports invoking user-defined or vendor functions using the stored procedure escape syntax.
public  booleansupportsStoredProcedures()
    
public  booleansupportsSubqueriesInComparisons()
    
public  booleansupportsSubqueriesInExists()
    
public  booleansupportsSubqueriesInIns()
    
public  booleansupportsSubqueriesInQuantifieds()
    
public  booleansupportsTableCorrelationNames()
    
public  booleansupportsTransactionIsolationLevel(int level)
    
public  booleansupportsTransactions()
    
public  booleansupportsUnion()
    
public  booleansupportsUnionAll()
    
public  booleanupdatesAreDetected(int type)
    
public  booleanusesLocalFilePerTable()
    
public  booleanusesLocalFiles()
    

Field Detail
agent_
protected Agent agent_(Code)



connection_
protected Connection connection_(Code)



productLevel_
public ProductLevel productLevel_(Code)



useServerXAState_
public boolean useServerXAState_(Code)




Constructor Detail
DatabaseMetaData
protected DatabaseMetaData(Agent agent, Connection connection, ProductLevel productLevel)(Code)




Method Detail
allProceduresAreCallable
public boolean allProceduresAreCallable() throws SQLException(Code)



allTablesAreSelectable
public boolean allTablesAreSelectable() throws SQLException(Code)



autoCommitFailureClosesAllResultSets
final public boolean autoCommitFailureClosesAllResultSets() throws SQLException(Code)
Retrieves whether an SQLException will cause all open ResultSets to be closed when auto-commit is true. false, since Derby does not close all openresult sets when an error occurs
exception:
  SQLException - if a database access error occurs



checkForClosedConnection
protected void checkForClosedConnection() throws SQLException(Code)
A "public" version of checkForClosedConnection() that throws SQLException instead of SqlException. In particular this is used by all the DatabaseMetadata methods



checkServerJdbcVersionX
protected void checkServerJdbcVersionX(String method, int major, int minor) throws SqlException(Code)
Checks whether the server supports a JDBC version. If the server does not support the JDBC version, an exception is thrown.
Parameters:
  method - name of the method for which support is needed onthe server (used in exception message)
Parameters:
  major - minimum JDBC major version
Parameters:
  minor - minimum JDBC minor version if major version matches
exception:
  SqlException - if the server does not support thespecified JDBC version



computeFeatureSet_
abstract protected void computeFeatureSet_()(Code)



dataDefinitionCausesTransactionCommit
public boolean dataDefinitionCausesTransactionCommit() throws SQLException(Code)



dataDefinitionIgnoredInTransactions
public boolean dataDefinitionIgnoredInTransactions() throws SQLException(Code)



deletesAreDetected
public boolean deletesAreDetected(int type) throws SQLException(Code)



doesMaxRowSizeIncludeBlobs
public boolean doesMaxRowSizeIncludeBlobs() throws SQLException(Code)



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



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



getCatalogSeparator
public String getCatalogSeparator() throws SQLException(Code)



getCatalogTerm
public String getCatalogTerm() throws SQLException(Code)



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



getClientInfoProperties
public ResultSet getClientInfoProperties() throws SQLException(Code)
Returns a list of the client info properties supported by the driver. The result set contains the following columns:

  1. NAME String=> The name of the client info property.
  2. MAX_LEN int=> The maximum length of the value for the property.
  3. DEFAULT_VALUE String=> The default value of the property.
  4. DESCRIPTION String=> A description of the property.

The ResultSet is sorted by the NAME column. A ResultSet object; each row is asupported client info property
exception:
  SQLException - if an error occurs




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



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



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



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



getDatabaseMajorVersion
public int getDatabaseMajorVersion() throws SQLException(Code)



getDatabaseMinorVersion
public int getDatabaseMinorVersion() throws SQLException(Code)



getDatabaseProductName
public String getDatabaseProductName() throws SQLException(Code)



getDatabaseProductVersion
public String getDatabaseProductVersion() throws SQLException(Code)



getDefaultTransactionIsolation
public int getDefaultTransactionIsolation() throws SQLException(Code)



getDriverMajorVersion
public int getDriverMajorVersion()(Code)



getDriverMinorVersion
public int getDriverMinorVersion()(Code)



getDriverName
public String getDriverName() throws SQLException(Code)



getDriverVersion
public String getDriverVersion() throws SQLException(Code)



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



getExtraNameCharacters
public String getExtraNameCharacters() throws SQLException(Code)



getFunctionColumns
public java.sql.ResultSet getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String parameterNamePattern) throws SQLException(Code)
Get the function names available in the database. Calls stored procedure SYSIBM.SQLFunctionParams(CatalogName varchar(128), SchemaName varchar(128), FuncName varchar(128), ParamName varchar(128), Options varchar(4000)) on the server. This procedure will in turn call EmbedDatabaseMetaData.getFunctionColumns(String,String, String,String)

Compatibility: Only available if both server and client version > 10.1, and JDK version >= 1.6. Older clients will not have this method available. Newer clients will be able to call this method when connected to an older server, but this will be trigger an exception in checkServerJdbcVersionX().

Upgrade: SYSIBM.SQLFunctionParams is added in DataDictionaryImpl.create_10_2_system_procedures (TransactionController,UUID) so it will become available in newly created databases and after hard upgrade.
Parameters:
  catalog - limit search to this catalog
Parameters:
  schemaPattern - limit search to schemas matching this pattern
Parameters:
  functionNamePattern - limit search to functions matching this pattern a ResultSet listing the fucntions
exception:
  SqlException - if a database error occurs
See Also:   DatabaseMetaData.getFunctionColumnsX(String,String,String,String)
See Also:   org.apache.derby.impl.sql.catalog.DataDictionaryImpl.create_10_2_system_procedures(TransactionControllerUUID)
See Also:   org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getFunctions(StringStringString)




getFunctions
public java.sql.ResultSet getFunctions(String catalog, String schemaPattern, String functionNamePattern) throws SQLException(Code)
Get the function names available in the database. Calls stored procedure SYSIBM.SQLFunctions(CatalogName varchar(128), SchemaName varchar(128), FuncName varchar(128), Options varchar(4000)) on the server. This procedure will in turn call EmbedDatabaseMetaData.getFunctions(String,String,String)

Compatibility: Only available if both server and client version > 10.1, and JDK version >= 1.6. Older clients will not have this method available. Newer clients will be able to call this method when connected to an older server, but this will be trigger an exception in checkServerJdbcVersionX().

Upgrade: SYSIBM.SQLFunctions is added in DataDictionaryImpl.create_10_2_system_procedures (TransactionController,UUID) so it will become available in newly created databases and after hard upgrade.
Parameters:
  catalog - limit search to this catalog
Parameters:
  schemaPattern - limit search to schemas matching this pattern
Parameters:
  functionNamePattern - limit search to functions matching this pattern a ResultSet listing the fucntions
exception:
  SqlException - if a database error occurs
See Also:   DatabaseMetaData.getFunctionsX(String,String,String)
See Also:   org.apache.derby.impl.sql.catalog.DataDictionaryImpl.create_10_2_system_procedures(TransactionControllerUUID)
See Also:   org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getFunctions(StringStringString)




getIdentifierQuoteString
public String getIdentifierQuoteString() throws SQLException(Code)



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



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



getJDBCMajorVersion
public int getJDBCMajorVersion() throws SQLException(Code)



getJDBCMinorVersion
public int getJDBCMinorVersion() throws SQLException(Code)



getMaxBinaryLiteralLength
public int getMaxBinaryLiteralLength() throws SQLException(Code)



getMaxCatalogNameLength
public int getMaxCatalogNameLength() throws SQLException(Code)



getMaxCharLiteralLength
public int getMaxCharLiteralLength() throws SQLException(Code)



getMaxColumnNameLength
public int getMaxColumnNameLength() throws SQLException(Code)



getMaxColumnsInGroupBy
public int getMaxColumnsInGroupBy() throws SQLException(Code)



getMaxColumnsInIndex
public int getMaxColumnsInIndex() throws SQLException(Code)



getMaxColumnsInOrderBy
public int getMaxColumnsInOrderBy() throws SQLException(Code)



getMaxColumnsInSelect
public int getMaxColumnsInSelect() throws SQLException(Code)



getMaxColumnsInTable
public int getMaxColumnsInTable() throws SQLException(Code)



getMaxConnections
public int getMaxConnections() throws SQLException(Code)



getMaxCursorNameLength
public int getMaxCursorNameLength() throws SQLException(Code)



getMaxIndexLength
public int getMaxIndexLength() throws SQLException(Code)



getMaxProcedureNameLength
public int getMaxProcedureNameLength() throws SQLException(Code)



getMaxRowSize
public int getMaxRowSize() throws SQLException(Code)



getMaxSchemaNameLength
public int getMaxSchemaNameLength() throws SQLException(Code)



getMaxStatementLength
public int getMaxStatementLength() throws SQLException(Code)



getMaxStatements
public int getMaxStatements() throws SQLException(Code)



getMaxTableNameLength
public int getMaxTableNameLength() throws SQLException(Code)



getMaxTablesInSelect
public int getMaxTablesInSelect() throws SQLException(Code)



getMaxUserNameLength
public int getMaxUserNameLength() throws SQLException(Code)



getNumericFunctions
public String getNumericFunctions() throws SQLException(Code)



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



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



getProcedureTerm
public String getProcedureTerm() throws SQLException(Code)



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



getResultSetHoldability
public int getResultSetHoldability() throws SQLException(Code)



getSQLKeywords
public String getSQLKeywords() throws SQLException(Code)



getSQLStateType
public int getSQLStateType() throws SQLException(Code)



getSchemaTerm
public String getSchemaTerm() throws SQLException(Code)



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



getSchemas
public ResultSet getSchemas(String catalog, String schemaPattern) throws SQLException(Code)
Get the schema names available in this database. The results are ordered by schema name.

The schema columns are:

  1. TABLE_SCHEM String => schema name
  2. TABLE_CATALOG String => catalog name (may be null)

Parameters:
  catalog - catalog name used to narrow down the search; ""means no catalog, null means any catalog
Parameters:
  schemaPattern - schema name used to narrow down thesearch, null means schema name should not be usedto narrow down search a ResultSet object in which each row is aschema description
exception:
  SQLException - if a database error occurs



getSearchStringEscape
public String getSearchStringEscape() throws SQLException(Code)



getStringFunctions
public String getStringFunctions() throws SQLException(Code)



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



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



getSystemFunctions
public String getSystemFunctions() throws SQLException(Code)



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



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



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



getTimeDateFunctions
public String getTimeDateFunctions() throws SQLException(Code)



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



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



getURL
public String getURL() throws SQLException(Code)



getURL_
abstract public String getURL_() throws SqlException(Code)



getUserName
public String getUserName() throws SQLException(Code)



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



insertsAreDetected
public boolean insertsAreDetected(int type) throws SQLException(Code)



isCatalogAtStart
public boolean isCatalogAtStart() throws SQLException(Code)



isReadOnly
public boolean isReadOnly() throws SQLException(Code)



locatorsUpdateCopy
public boolean locatorsUpdateCopy() throws SQLException(Code)



nullPlusNonNullIsNull
public boolean nullPlusNonNullIsNull() throws SQLException(Code)



nullsAreSortedAtEnd
public boolean nullsAreSortedAtEnd() throws SQLException(Code)



nullsAreSortedAtStart
public boolean nullsAreSortedAtStart() throws SQLException(Code)



nullsAreSortedHigh
public boolean nullsAreSortedHigh() throws SQLException(Code)



nullsAreSortedLow
public boolean nullsAreSortedLow() throws SQLException(Code)



othersDeletesAreVisible
public boolean othersDeletesAreVisible(int type) throws SQLException(Code)



othersInsertsAreVisible
public boolean othersInsertsAreVisible(int type) throws SQLException(Code)



othersUpdatesAreVisible
public boolean othersUpdatesAreVisible(int type) throws SQLException(Code)



ownDeletesAreVisible
public boolean ownDeletesAreVisible(int type) throws SQLException(Code)



ownInsertsAreVisible
public boolean ownInsertsAreVisible(int type) throws SQLException(Code)



ownUpdatesAreVisible
public boolean ownUpdatesAreVisible(int type) throws SQLException(Code)



providesQueryObjectGenerator
final public boolean providesQueryObjectGenerator() throws SQLException(Code)
Retrieves whether this JDBC driver provides its own QueryObjectGenerator. false, since Derby does not provide itsown generator
exception:
  SQLException - if a database access error occurs



storesLowerCaseIdentifiers
public boolean storesLowerCaseIdentifiers() throws SQLException(Code)



storesLowerCaseQuotedIdentifiers
public boolean storesLowerCaseQuotedIdentifiers() throws SQLException(Code)



storesMixedCaseIdentifiers
public boolean storesMixedCaseIdentifiers() throws SQLException(Code)



storesMixedCaseQuotedIdentifiers
public boolean storesMixedCaseQuotedIdentifiers() throws SQLException(Code)



storesUpperCaseIdentifiers
public boolean storesUpperCaseIdentifiers() throws SQLException(Code)



storesUpperCaseQuotedIdentifiers
public boolean storesUpperCaseQuotedIdentifiers() throws SQLException(Code)



supportsANSI92EntryLevelSQL
public boolean supportsANSI92EntryLevelSQL() throws SQLException(Code)



supportsANSI92FullSQL
public boolean supportsANSI92FullSQL() throws SQLException(Code)



supportsANSI92IntermediateSQL
public boolean supportsANSI92IntermediateSQL() throws SQLException(Code)



supportsAlterTableWithAddColumn
public boolean supportsAlterTableWithAddColumn() throws SQLException(Code)



supportsAlterTableWithDropColumn
public boolean supportsAlterTableWithDropColumn() throws SQLException(Code)



supportsBatchUpdates
public boolean supportsBatchUpdates() throws SQLException(Code)



supportsCatalogsInDataManipulation
public boolean supportsCatalogsInDataManipulation() throws SQLException(Code)



supportsCatalogsInIndexDefinitions
public boolean supportsCatalogsInIndexDefinitions() throws SQLException(Code)



supportsCatalogsInPrivilegeDefinitions
public boolean supportsCatalogsInPrivilegeDefinitions() throws SQLException(Code)



supportsCatalogsInProcedureCalls
public boolean supportsCatalogsInProcedureCalls() throws SQLException(Code)



supportsCatalogsInTableDefinitions
public boolean supportsCatalogsInTableDefinitions() throws SQLException(Code)



supportsColumnAliasing
public boolean supportsColumnAliasing() throws SQLException(Code)



supportsConvert
public boolean supportsConvert() throws SQLException(Code)



supportsConvert
public boolean supportsConvert(int fromType, int toType) throws SQLException(Code)



supportsCoreSQLGrammar
public boolean supportsCoreSQLGrammar() throws SQLException(Code)



supportsCorrelatedSubqueries
public boolean supportsCorrelatedSubqueries() throws SQLException(Code)



supportsDataDefinitionAndDataManipulationTransactions
public boolean supportsDataDefinitionAndDataManipulationTransactions() throws SQLException(Code)



supportsDataManipulationTransactionsOnly
public boolean supportsDataManipulationTransactionsOnly() throws SQLException(Code)



supportsDifferentTableCorrelationNames
public boolean supportsDifferentTableCorrelationNames() throws SQLException(Code)



supportsExpressionsInOrderBy
public boolean supportsExpressionsInOrderBy() throws SQLException(Code)



supportsExtendedSQLGrammar
public boolean supportsExtendedSQLGrammar() throws SQLException(Code)



supportsFullOuterJoins
public boolean supportsFullOuterJoins() throws SQLException(Code)



supportsGetGeneratedKeys
public boolean supportsGetGeneratedKeys() throws SQLException(Code)



supportsGroupBy
public boolean supportsGroupBy() throws SQLException(Code)



supportsGroupByBeyondSelect
public boolean supportsGroupByBeyondSelect() throws SQLException(Code)



supportsGroupByUnrelated
public boolean supportsGroupByUnrelated() throws SQLException(Code)



supportsIntegrityEnhancementFacility
public boolean supportsIntegrityEnhancementFacility() throws SQLException(Code)



supportsLikeEscapeClause
public boolean supportsLikeEscapeClause() throws SQLException(Code)



supportsLimitedOuterJoins
public boolean supportsLimitedOuterJoins() throws SQLException(Code)



supportsMinimumSQLGrammar
public boolean supportsMinimumSQLGrammar() throws SQLException(Code)



supportsMixedCaseIdentifiers
public boolean supportsMixedCaseIdentifiers() throws SQLException(Code)



supportsMixedCaseQuotedIdentifiers
public boolean supportsMixedCaseQuotedIdentifiers() throws SQLException(Code)



supportsMultipleOpenResults
public boolean supportsMultipleOpenResults() throws SQLException(Code)



supportsMultipleResultSets
public boolean supportsMultipleResultSets() throws SQLException(Code)



supportsMultipleTransactions
public boolean supportsMultipleTransactions() throws SQLException(Code)



supportsNamedParameters
public boolean supportsNamedParameters() throws SQLException(Code)



supportsNonNullableColumns
public boolean supportsNonNullableColumns() throws SQLException(Code)



supportsOpenCursorsAcrossCommit
public boolean supportsOpenCursorsAcrossCommit() throws SQLException(Code)



supportsOpenCursorsAcrossRollback
public boolean supportsOpenCursorsAcrossRollback() throws SQLException(Code)



supportsOpenStatementsAcrossCommit
public boolean supportsOpenStatementsAcrossCommit() throws SQLException(Code)



supportsOpenStatementsAcrossRollback
public boolean supportsOpenStatementsAcrossRollback() throws SQLException(Code)



supportsOrderByUnrelated
public boolean supportsOrderByUnrelated() throws SQLException(Code)



supportsOuterJoins
public boolean supportsOuterJoins() throws SQLException(Code)



supportsPositionedDelete
public boolean supportsPositionedDelete() throws SQLException(Code)



supportsPositionedUpdate
public boolean supportsPositionedUpdate() throws SQLException(Code)



supportsResultSetConcurrency
public boolean supportsResultSetConcurrency(int type, int concurrency) throws SQLException(Code)



supportsResultSetHoldability
public boolean supportsResultSetHoldability(int holdability) throws SQLException(Code)



supportsResultSetType
public boolean supportsResultSetType(int type) throws SQLException(Code)



supportsSavepoints
public boolean supportsSavepoints() throws SQLException(Code)



supportsSchemasInDataManipulation
public boolean supportsSchemasInDataManipulation() throws SQLException(Code)



supportsSchemasInIndexDefinitions
public boolean supportsSchemasInIndexDefinitions() throws SQLException(Code)



supportsSchemasInPrivilegeDefinitions
public boolean supportsSchemasInPrivilegeDefinitions() throws SQLException(Code)



supportsSchemasInProcedureCalls
public boolean supportsSchemasInProcedureCalls() throws SQLException(Code)



supportsSchemasInTableDefinitions
public boolean supportsSchemasInTableDefinitions() throws SQLException(Code)



supportsSelectForUpdate
public boolean supportsSelectForUpdate() throws SQLException(Code)



supportsStatementPooling
public boolean supportsStatementPooling() throws SQLException(Code)



supportsStoredFunctionsUsingCallSyntax
final public boolean supportsStoredFunctionsUsingCallSyntax() throws SQLException(Code)
Retrieves whether this database supports invoking user-defined or vendor functions using the stored procedure escape syntax. true, since Derby supports the escape syntax
exception:
  SQLException - if a database access error occurs



supportsStoredProcedures
public boolean supportsStoredProcedures() throws SQLException(Code)



supportsSubqueriesInComparisons
public boolean supportsSubqueriesInComparisons() throws SQLException(Code)



supportsSubqueriesInExists
public boolean supportsSubqueriesInExists() throws SQLException(Code)



supportsSubqueriesInIns
public boolean supportsSubqueriesInIns() throws SQLException(Code)



supportsSubqueriesInQuantifieds
public boolean supportsSubqueriesInQuantifieds() throws SQLException(Code)



supportsTableCorrelationNames
public boolean supportsTableCorrelationNames() throws SQLException(Code)



supportsTransactionIsolationLevel
public boolean supportsTransactionIsolationLevel(int level) throws SQLException(Code)



supportsTransactions
public boolean supportsTransactions() throws SQLException(Code)



supportsUnion
public boolean supportsUnion() throws SQLException(Code)



supportsUnionAll
public boolean supportsUnionAll() throws SQLException(Code)



updatesAreDetected
public boolean updatesAreDetected(int type) throws SQLException(Code)



usesLocalFilePerTable
public boolean usesLocalFilePerTable() throws SQLException(Code)



usesLocalFiles
public boolean usesLocalFiles() throws SQLException(Code)



Methods inherited from java.lang.Object
native protected Object clone() throws CloneNotSupportedException(Code)(Java Doc)
public boolean equals(Object obj)(Code)(Java Doc)
protected void finalize() throws Throwable(Code)(Java Doc)
final native public Class getClass()(Code)(Java Doc)
native public int hashCode()(Code)(Java Doc)
final native public void notify()(Code)(Java Doc)
final native public void notifyAll()(Code)(Java Doc)
public String toString()(Code)(Java Doc)
final native public void wait(long timeout) throws InterruptedException(Code)(Java Doc)
final public void wait(long timeout, int nanos) throws InterruptedException(Code)(Java Doc)
final public void wait() throws InterruptedException(Code)(Java Doc)

www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.