Java Doc for SQLDatabaseMetaData.java in  » Database-Client » squirrel-sql-2.6.5a » net » sourceforge » squirrel_sql » fw » sql » 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 Client » squirrel sql 2.6.5a » net.sourceforge.squirrel_sql.fw.sql 
Source Cross Reference  Class Diagram Java Document (Java Doc) 


java.lang.Object
   net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData

All known Subclasses:   net.sourceforge.squirrel_sql.fw.sql.MockSQLDatabaseMetaData,
SQLDatabaseMetaData
public class SQLDatabaseMetaData implements ISQLDatabaseMetaData(Code)
This class represents the metadata for a database. It is essentially a wrapper around java.sql.DatabaseMetaData.

Some data can be cached on the first retrieval in order to speed up subsequent retrievals. To clear this cache call clearCache().

From the JavaDoc for java.sql.DatabaseMetaData. "Some methods take arguments that are String patterns. These arguments all have names such as fooPattern. Within a pattern String, "%" means match any substring of 0 or more characters, and "_" means match any one character. Only metadata entries matching the search pattern are returned. If a search pattern argument is set to null, that argument's criterion will be dropped from the search."

Additionally, it should be noted that some JDBC drivers (like Oracle) do not handle multi-threaded access to methods that return ResultSets very well. It is therefore highly recommended that methods in this class that return a ResultSet, should not be called outside of this class where this class' monitor has no jurisdiction. Furthermore, methods that are meant to be called externally that create a ResultSet should package the data in some container object structure for use by the caller, and should always be synchronized on this class' monitor.
author:
   Colin Bell


Inner Class :public static class DriverMatch


Constructor Summary
 SQLDatabaseMetaData(ISQLConnection conn)
     ctor specifying the connection that we are retrieving metadata for.

Method Summary
public  voidclearCache()
    
public  booleancorrectlySupportsSetMaxRows()
    
public synchronized  BestRowIdentifier[]getBestRowIdentifier(ITableInfo ti)
    
public synchronized  StringgetCascadeClause()
    
public synchronized  StringgetCatalogSeparator()
    
public synchronized  StringgetCatalogTerm()
    
public synchronized  String[]getCatalogs()
    
public synchronized  TableColumnInfo[]getColumnInfo(String catalog, String schema, String table)
    
public synchronized  TableColumnInfo[]getColumnInfo(ITableInfo ti)
    
public  ResultSetgetColumnPrivileges(ITableInfo ti)
    
public synchronized  IDataSetgetColumnPrivilegesDataSet(ITableInfo ti, int[] columnIndices, boolean computeWidths)
    
public synchronized  IDataSetgetColumns(ITableInfo ti, int[] columnIndices, boolean computeWidths)
    
public synchronized  DataTypeInfo[]getDataTypes()
    
public synchronized  intgetDatabaseMajorVersion()
    
public synchronized  StringgetDatabaseProductName()
    
public synchronized  StringgetDatabaseProductVersion()
    
public synchronized  StringgetDriverName()
    
public  ResultSetgetExportedKeys(ITableInfo ti)
    
public synchronized  IDataSetgetExportedKeysDataSet(ITableInfo ti)
    
public synchronized  ForeignKeyInfo[]getExportedKeysInfo(String catalog, String schema, String tableName)
    
public synchronized  ForeignKeyInfo[]getExportedKeysInfo(ITableInfo ti)
    
public synchronized  StringgetIdentifierQuoteString()
    
public  ResultSetgetImportedKeys(ITableInfo ti)
    
public synchronized  IDataSetgetImportedKeysDataSet(ITableInfo ti)
    
public synchronized  ForeignKeyInfo[]getImportedKeysInfo(String catalog, String schema, String tableName)
    
public synchronized  ForeignKeyInfo[]getImportedKeysInfo(ITableInfo ti)
    
public synchronized  ResultSetDataSetgetIndexInfo(ITableInfo ti, int[] columnIndices, boolean computeWidths)
    
public  List<IndexInfo>getIndexInfo(ITableInfo ti)
     Returns a list of IndexInfos describing indexes for the specified table.
Parameters:
  ti - the table to find all index information for.
public synchronized  DatabaseMetaDatagetJDBCMetaData()
    
public  intgetJDBCVersion()
    
public synchronized  IDataSetgetMetaDataSet()
    
public synchronized  String[]getNumericFunctions()
    
public synchronized  IDataSetgetPrimaryKey(ITableInfo ti, int[] columnIndices, boolean computeWidths)
    
public synchronized  PrimaryKeyInfo[]getPrimaryKey(ITableInfo ti)
    
public synchronized  PrimaryKeyInfo[]getPrimaryKey(String catalog, String schema, String table)
    
public  ResultSetgetPrimaryKeys(ITableInfo ti)
    
public  ResultSetgetProcedureColumns(IProcedureInfo ti)
    
public synchronized  IDataSetgetProcedureColumnsDataSet(IProcedureInfo ti)
    
public synchronized  StringgetProcedureTerm()
    
public synchronized  IProcedureInfo[]getProcedures(String catalog, String schemaPattern, String procedureNamePattern, ProgressCallBack progressCallBack)
    
public synchronized  String[]getSQLKeywords()
    
public synchronized  StringgetSchemaTerm()
    
public synchronized  String[]getSchemas()
    
public synchronized  String[]getStringFunctions()
    
public synchronized  String[]getSystemFunctions()
    
public  ResultSetgetTablePrivileges(ITableInfo ti)
    
public synchronized  IDataSetgetTablePrivilegesDataSet(ITableInfo ti, int[] columnIndices, boolean computeWidths)
    
public synchronized  String[]getTableTypes()
    
public synchronized  ITableInfo[]getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types, ProgressCallBack progressCallBack)
    
public synchronized  String[]getTimeDateFunctions()
    
public  ResultSetgetTypeInfo()
    
public synchronized  IDataSetgetTypesDataSet()
    
public synchronized  IUDTInfo[]getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types)
    
public synchronized  StringgetURL()
    
public synchronized  StringgetUserName()
    
public  ResultSetgetVersionColumns(ITableInfo ti)
    
public synchronized  IDataSetgetVersionColumnsDataSet(ITableInfo ti)
    
public synchronized  booleanstoresUpperCaseIdentifiers()
    
public  booleansupportsCatalogs()
    
public synchronized  booleansupportsCatalogsInDataManipulation()
    
public synchronized  booleansupportsCatalogsInProcedureCalls()
    
public synchronized  booleansupportsCatalogsInTableDefinitions()
    
public synchronized  booleansupportsMultipleResultSets()
    
public synchronized  booleansupportsResultSetType(int type)
    
public synchronized  booleansupportsSavepoints()
    
public  booleansupportsSchemas()
    
public synchronized  booleansupportsSchemasInDataManipulation()
    
public synchronized  booleansupportsSchemasInTableDefinitions()
    
public synchronized  booleansupportsStoredProcedures()
    


Constructor Detail
SQLDatabaseMetaData
SQLDatabaseMetaData(ISQLConnection conn)(Code)
ctor specifying the connection that we are retrieving metadata for.
Parameters:
  conn - Connection to database.
throws:
  IllegalArgumentException - Thrown if null SQLConnection passed.




Method Detail
clearCache
public void clearCache()(Code)



correctlySupportsSetMaxRows
public boolean correctlySupportsSetMaxRows() throws SQLException(Code)



getBestRowIdentifier
public synchronized BestRowIdentifier[] getBestRowIdentifier(ITableInfo ti) throws SQLException(Code)



getCascadeClause
public synchronized String getCascadeClause() throws SQLException(Code)



getCatalogSeparator
public synchronized String getCatalogSeparator() throws SQLException(Code)



getCatalogTerm
public synchronized String getCatalogTerm() throws SQLException(Code)



getCatalogs
public synchronized String[] getCatalogs() throws SQLException(Code)



getColumnInfo
public synchronized TableColumnInfo[] getColumnInfo(String catalog, String schema, String table) throws SQLException(Code)



getColumnInfo
public synchronized TableColumnInfo[] getColumnInfo(ITableInfo ti) throws SQLException(Code)



getColumnPrivileges
public ResultSet getColumnPrivileges(ITableInfo ti) throws SQLException(Code)



getColumnPrivilegesDataSet
public synchronized IDataSet getColumnPrivilegesDataSet(ITableInfo ti, int[] columnIndices, boolean computeWidths) throws DataSetException(Code)



getColumns
public synchronized IDataSet getColumns(ITableInfo ti, int[] columnIndices, boolean computeWidths) throws DataSetException(Code)



getDataTypes
public synchronized DataTypeInfo[] getDataTypes() throws SQLException(Code)



getDatabaseMajorVersion
public synchronized int getDatabaseMajorVersion() throws SQLException(Code)



getDatabaseProductName
public synchronized String getDatabaseProductName() throws SQLException(Code)



getDatabaseProductVersion
public synchronized String getDatabaseProductVersion() throws SQLException(Code)



getDriverName
public synchronized String getDriverName() throws SQLException(Code)



getExportedKeys
public ResultSet getExportedKeys(ITableInfo ti) throws SQLException(Code)



getExportedKeysDataSet
public synchronized IDataSet getExportedKeysDataSet(ITableInfo ti) throws DataSetException(Code)



getExportedKeysInfo
public synchronized ForeignKeyInfo[] getExportedKeysInfo(String catalog, String schema, String tableName) throws SQLException(Code)



getExportedKeysInfo
public synchronized ForeignKeyInfo[] getExportedKeysInfo(ITableInfo ti) throws SQLException(Code)



getIdentifierQuoteString
public synchronized String getIdentifierQuoteString() throws SQLException(Code)



getImportedKeys
public ResultSet getImportedKeys(ITableInfo ti) throws SQLException(Code)



getImportedKeysDataSet
public synchronized IDataSet getImportedKeysDataSet(ITableInfo ti) throws DataSetException(Code)



getImportedKeysInfo
public synchronized ForeignKeyInfo[] getImportedKeysInfo(String catalog, String schema, String tableName) throws SQLException(Code)



getImportedKeysInfo
public synchronized ForeignKeyInfo[] getImportedKeysInfo(ITableInfo ti) throws SQLException(Code)



getIndexInfo
public synchronized ResultSetDataSet getIndexInfo(ITableInfo ti, int[] columnIndices, boolean computeWidths) throws DataSetException(Code)



getIndexInfo
public List<IndexInfo> getIndexInfo(ITableInfo ti) throws SQLException(Code)
Returns a list of IndexInfos describing indexes for the specified table.
Parameters:
  ti - the table to find all index information for. a list of IndexInfos
throws:
  SQLException -



getJDBCMetaData
public synchronized DatabaseMetaData getJDBCMetaData() throws SQLException(Code)



getJDBCVersion
public int getJDBCVersion() throws SQLException(Code)



getMetaDataSet
public synchronized IDataSet getMetaDataSet() throws SQLException(Code)



getNumericFunctions
public synchronized String[] getNumericFunctions() throws SQLException(Code)



getPrimaryKey
public synchronized IDataSet getPrimaryKey(ITableInfo ti, int[] columnIndices, boolean computeWidths) throws DataSetException(Code)



getPrimaryKey
public synchronized PrimaryKeyInfo[] getPrimaryKey(ITableInfo ti) throws SQLException(Code)



getPrimaryKey
public synchronized PrimaryKeyInfo[] getPrimaryKey(String catalog, String schema, String table) throws SQLException(Code)



getPrimaryKeys
public ResultSet getPrimaryKeys(ITableInfo ti) throws SQLException(Code)



getProcedureColumns
public ResultSet getProcedureColumns(IProcedureInfo ti) throws SQLException(Code)



getProcedureColumnsDataSet
public synchronized IDataSet getProcedureColumnsDataSet(IProcedureInfo ti) throws DataSetException(Code)



getProcedureTerm
public synchronized String getProcedureTerm() throws SQLException(Code)



getProcedures
public synchronized IProcedureInfo[] getProcedures(String catalog, String schemaPattern, String procedureNamePattern, ProgressCallBack progressCallBack) throws SQLException(Code)



getSQLKeywords
public synchronized String[] getSQLKeywords() throws SQLException(Code)



getSchemaTerm
public synchronized String getSchemaTerm() throws SQLException(Code)



getSchemas
public synchronized String[] getSchemas() throws SQLException(Code)



getStringFunctions
public synchronized String[] getStringFunctions() throws SQLException(Code)



getSystemFunctions
public synchronized String[] getSystemFunctions() throws SQLException(Code)



getTablePrivileges
public ResultSet getTablePrivileges(ITableInfo ti) throws SQLException(Code)



getTablePrivilegesDataSet
public synchronized IDataSet getTablePrivilegesDataSet(ITableInfo ti, int[] columnIndices, boolean computeWidths) throws DataSetException(Code)



getTableTypes
public synchronized String[] getTableTypes() throws SQLException(Code)



getTables
public synchronized ITableInfo[] getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types, ProgressCallBack progressCallBack) throws SQLException(Code)



getTimeDateFunctions
public synchronized String[] getTimeDateFunctions() throws SQLException(Code)



getTypeInfo
public ResultSet getTypeInfo() throws SQLException(Code)



getTypesDataSet
public synchronized IDataSet getTypesDataSet() throws DataSetException(Code)



getUDTs
public synchronized IUDTInfo[] getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) throws SQLException(Code)



getURL
public synchronized String getURL() throws SQLException(Code)



getUserName
public synchronized String getUserName() throws SQLException(Code)



getVersionColumns
public ResultSet getVersionColumns(ITableInfo ti) throws SQLException(Code)



getVersionColumnsDataSet
public synchronized IDataSet getVersionColumnsDataSet(ITableInfo ti) throws DataSetException(Code)



storesUpperCaseIdentifiers
public synchronized boolean storesUpperCaseIdentifiers() throws SQLException(Code)



supportsCatalogs
public boolean supportsCatalogs() throws SQLException(Code)



supportsCatalogsInDataManipulation
public synchronized boolean supportsCatalogsInDataManipulation() throws SQLException(Code)



supportsCatalogsInProcedureCalls
public synchronized boolean supportsCatalogsInProcedureCalls() throws SQLException(Code)



supportsCatalogsInTableDefinitions
public synchronized boolean supportsCatalogsInTableDefinitions() throws SQLException(Code)



supportsMultipleResultSets
public synchronized boolean supportsMultipleResultSets() throws SQLException(Code)



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



supportsSavepoints
public synchronized boolean supportsSavepoints() throws SQLException(Code)



supportsSchemas
public boolean supportsSchemas() throws SQLException(Code)



supportsSchemasInDataManipulation
public synchronized boolean supportsSchemasInDataManipulation() throws SQLException(Code)



supportsSchemasInTableDefinitions
public synchronized boolean supportsSchemasInTableDefinitions() throws SQLException(Code)



supportsStoredProcedures
public synchronized boolean supportsStoredProcedures() 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.