Java Doc for dbfFileDatabaseMetaData.java in  » Database-DBMS » TinySQL » com » sqlmagic » tinysql » 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 » TinySQL » com.sqlmagic.tinysql 
Source Cross Reference  Class Diagram Java Document (Java Doc) 


java.lang.Object
   com.sqlmagic.tinysql.tinySQLDatabaseMetaData
      com.sqlmagic.tinysql.dbfFileDatabaseMetaData

dbfFileDatabaseMetaData
public class dbfFileDatabaseMetaData extends tinySQLDatabaseMetaData (Code)
dBase read/write access

author:
   Brian Jepson
author:
   Marcel Ruff Added DatabaseMetaData with JDK 2 support
author:
   Thomas Morgner Changed DatabaseMetaData to use java.sql.Types.



Constructor Summary
public  dbfFileDatabaseMetaData(Connection connection)
    

Method Summary
public  ResultSetgetColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)
     Gets a description of table columns available in the specified catalog.

Only column descriptions matching the catalog, schema, table and column name criteria are returned.

 StringgetDataDir()
    
public  StringgetDatabaseProductName()
    
public  StringgetDatabaseProductVersion()
    
public  ResultSetgetTables(String catalog, String schemaPattern, String tableNamePattern, String types)
    
public  ResultSetgetTypeInfo()
     Gets a description of all the standard SQL types supported by this database.


Constructor Detail
dbfFileDatabaseMetaData
public dbfFileDatabaseMetaData(Connection connection)(Code)




Method Detail
getColumns
public ResultSet getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)(Code)
Gets a description of table columns available in the specified catalog.

Only column descriptions matching the catalog, schema, table and column name criteria are returned. They are ordered by TABLE_SCHEM, TABLE_NAME and ORDINAL_POSITION.

Each column description has the following columns:

  1. TABLE_CAT String => table catalog (may be null)
  2. TABLE_SCHEM String => table schema (may be null)
  3. TABLE_NAME String => table name
  4. COLUMN_NAME String => column name
  5. DATA_TYPE short => SQL type from java.sql.Types
  6. TYPE_NAME String => Data source dependent type name, for a UDT the type name is fully qualified
  7. COLUMN_SIZE int => column size. For char or date types this is the maximum number of characters, for numeric or decimal types this is precision.
  8. BUFFER_LENGTH is not used.
  9. DECIMAL_DIGITS int => the number of fractional digits
  10. NUM_PREC_RADIX int => Radix (typically either 10 or 2)
  11. NULLABLE int => is NULL allowed?
    • columnNoNulls - might not allow NULL values
    • columnNullable - definitely allows NULL values
    • columnNullableUnknown - nullability unknown
  12. REMARKS String => comment describing column (may be null)
  13. COLUMN_DEF String => default value (may be null)
  14. SQL_DATA_TYPE int => unused
  15. SQL_DATETIME_SUB int => unused
  16. CHAR_OCTET_LENGTH int => for char types the maximum number of bytes in the column
  17. ORDINAL_POSITION int => index of column in table (starting at 1)
  18. IS_NULLABLE String => "NO" means column definitely does not allow NULL values; "YES" means the column might allow NULL values. An empty string means nobody knows.

Parameters:
  catalog - a catalog name; "" retrieves those without acatalog; null means drop catalog name from the selection criteria
Parameters:
  schemaPattern - a schema name pattern; "" retrieves thosewithout a schema
Parameters:
  tableNamePattern - a table name pattern
Parameters:
  columnNamePattern - a column name pattern ResultSet - each row is a column description
exception:
  SQLException - if a database access error occurs
See Also:   dbfFileDatabaseMetaData.getSearchStringEscape



getDataDir
String getDataDir()(Code)



getDatabaseProductName
public String getDatabaseProductName()(Code)



getDatabaseProductVersion
public String getDatabaseProductVersion()(Code)



getTables
public ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String types)(Code)



getTypeInfo
public ResultSet getTypeInfo() throws SQLException(Code)
Gets a description of all the standard SQL types supported by this database. They are ordered by DATA_TYPE and then by how closely the data type maps to the corresponding JDBC SQL type.

Each type description has the following columns:

  1. TYPE_NAME String => Type name
  2. DATA_TYPE short => SQL data type from java.sql.Types
  3. PRECISION int => maximum precision
  4. LITERAL_PREFIX String => prefix used to quote a literal (may be null)
  5. LITERAL_SUFFIX String => suffix used to quote a literal (may be null)
  6. CREATE_PARAMS String => parameters used in creating the type (may be null)
  7. NULLABLE short => can you use NULL for this type?
    • typeNoNulls - does not allow NULL values
    • typeNullable - allows NULL values
    • typeNullableUnknown - nullability unknown
  8. CASE_SENSITIVE boolean=> is it case sensitive?
  9. SEARCHABLE short => can you use "WHERE" based on this type:
    • typePredNone - No support
    • typePredChar - Only supported with WHERE .. LIKE
    • typePredBasic - Supported except for WHERE .. LIKE
    • typeSearchable - Supported for all WHERE ..
  10. UNSIGNED_ATTRIBUTE boolean => is it unsigned?
  11. FIXED_PREC_SCALE boolean => can it be a money value?
  12. AUTO_INCREMENT boolean => can it be used for an auto-increment value?
  13. LOCAL_TYPE_NAME String => localized version of type name (may be null)
  14. MINIMUM_SCALE short => minimum scale supported
  15. MAXIMUM_SCALE short => maximum scale supported
  16. SQL_DATA_TYPE int => unused
  17. SQL_DATETIME_SUB int => unused
  18. NUM_PREC_RADIX int => usually 2 or 10
ResultSet - each row is a SQL type description
exception:
  SQLException - if a database access error occurs



Fields inherited from com.sqlmagic.tinysql.tinySQLDatabaseMetaData
int bestRowNotPseudo(Code)(Java Doc)
int bestRowPseudo(Code)(Java Doc)
int bestRowSession(Code)(Java Doc)
int bestRowTemporary(Code)(Java Doc)
int bestRowTransaction(Code)(Java Doc)
int bestRowUnknown(Code)(Java Doc)
int columnNoNulls(Code)(Java Doc)
int columnNullable(Code)(Java Doc)
int columnNullableUnknown(Code)(Java Doc)
int importedKeyCascade(Code)(Java Doc)
int importedKeyInitiallyDeferred(Code)(Java Doc)
int importedKeyInitiallyImmediate(Code)(Java Doc)
int importedKeyNoAction(Code)(Java Doc)
int importedKeyNotDeferrable(Code)(Java Doc)
int importedKeyRestrict(Code)(Java Doc)
int importedKeySetDefault(Code)(Java Doc)
int importedKeySetNull(Code)(Java Doc)
int procedureColumnIn(Code)(Java Doc)
int procedureColumnInOut(Code)(Java Doc)
int procedureColumnOut(Code)(Java Doc)
int procedureColumnResult(Code)(Java Doc)
int procedureColumnReturn(Code)(Java Doc)
int procedureColumnUnknown(Code)(Java Doc)
int procedureNoNulls(Code)(Java Doc)
int procedureNoResult(Code)(Java Doc)
int procedureNullable(Code)(Java Doc)
int procedureNullableUnknown(Code)(Java Doc)
int procedureResultUnknown(Code)(Java Doc)
int procedureReturnsResult(Code)(Java Doc)
short tableIndexClustered(Code)(Java Doc)
short tableIndexHashed(Code)(Java Doc)
short tableIndexOther(Code)(Java Doc)
short tableIndexStatistic(Code)(Java Doc)
int typeNoNulls(Code)(Java Doc)
int typeNullable(Code)(Java Doc)
int typeNullableUnknown(Code)(Java Doc)
int typePredBasic(Code)(Java Doc)
int typePredChar(Code)(Java Doc)
int typePredNone(Code)(Java Doc)
int typeSearchable(Code)(Java Doc)
int versionColumnNotPseudo(Code)(Java Doc)
int versionColumnPseudo(Code)(Java Doc)
int versionColumnUnknown(Code)(Java Doc)

Methods inherited from com.sqlmagic.tinysql.tinySQLDatabaseMetaData
public boolean allProceduresAreCallable()(Code)(Java Doc)
public boolean allTablesAreSelectable()(Code)(Java Doc)
public boolean dataDefinitionCausesTransactionCommit()(Code)(Java Doc)
public boolean dataDefinitionIgnoredInTransactions() throws SQLException(Code)(Java Doc)
public boolean deletesAreDetected(int type)(Code)(Java Doc)
public boolean doesMaxRowSizeIncludeBlobs()(Code)(Java Doc)
public ResultSet getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable) throws SQLException(Code)(Java Doc)
public String getCatalogSeparator() throws SQLException(Code)(Java Doc)
public String getCatalogTerm() throws SQLException(Code)(Java Doc)
public ResultSet getCatalogs() throws SQLException(Code)(Java Doc)
public ResultSet getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) throws SQLException(Code)(Java Doc)
public ResultSet getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)(Code)(Java Doc)
public Connection getConnection()(Code)(Java Doc)
public ResultSet getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) throws SQLException(Code)(Java Doc)
public String getDatabaseProductName()(Code)(Java Doc)
public String getDatabaseProductVersion()(Code)(Java Doc)
public int getDefaultTransactionIsolation() throws SQLException(Code)(Java Doc)
public int getDriverMajorVersion()(Code)(Java Doc)
public int getDriverMinorVersion()(Code)(Java Doc)
public String getDriverName()(Code)(Java Doc)
public String getDriverVersion()(Code)(Java Doc)
public ResultSet getExportedKeys(String catalog, String schema, String table) throws SQLException(Code)(Java Doc)
public String getExtraNameCharacters()(Code)(Java Doc)
public String getIdentifierQuoteString()(Code)(Java Doc)
public ResultSet getImportedKeys(String catalog, String schema, String table) throws SQLException(Code)(Java Doc)
public ResultSet getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) throws SQLException(Code)(Java Doc)
public int getMaxBinaryLiteralLength()(Code)(Java Doc)
public int getMaxCatalogNameLength()(Code)(Java Doc)
public int getMaxCharLiteralLength()(Code)(Java Doc)
public int getMaxColumnNameLength()(Code)(Java Doc)
public int getMaxColumnsInGroupBy()(Code)(Java Doc)
public int getMaxColumnsInIndex()(Code)(Java Doc)
public int getMaxColumnsInOrderBy()(Code)(Java Doc)
public int getMaxColumnsInSelect()(Code)(Java Doc)
public int getMaxColumnsInTable()(Code)(Java Doc)
public int getMaxConnections()(Code)(Java Doc)
public int getMaxCursorNameLength()(Code)(Java Doc)
public int getMaxIndexLength()(Code)(Java Doc)
public int getMaxProcedureNameLength()(Code)(Java Doc)
public int getMaxRowSize()(Code)(Java Doc)
public int getMaxSchemaNameLength()(Code)(Java Doc)
public int getMaxStatementLength()(Code)(Java Doc)
public int getMaxStatements()(Code)(Java Doc)
public int getMaxTableNameLength()(Code)(Java Doc)
public int getMaxTablesInSelect()(Code)(Java Doc)
public int getMaxUserNameLength()(Code)(Java Doc)
public String getNumericFunctions()(Code)(Java Doc)
public ResultSet getPrimaryKeys(String catalog, String schema, String table) throws SQLException(Code)(Java Doc)
public ResultSet getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern)(Code)(Java Doc)
public String getProcedureTerm() throws SQLException(Code)(Java Doc)
public ResultSet getProcedures(String catalog, String schemaPattern, String procedureNamePattern)(Code)(Java Doc)
public String getSQLKeywords()(Code)(Java Doc)
public String getSchemaTerm() throws SQLException(Code)(Java Doc)
public ResultSet getSchemas() throws SQLException(Code)(Java Doc)
public String getSearchStringEscape()(Code)(Java Doc)
public String getStringFunctions()(Code)(Java Doc)
public String getSystemFunctions()(Code)(Java Doc)
public ResultSet getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern) throws SQLException(Code)(Java Doc)
public ResultSet getTableTypes()(Code)(Java Doc)
public ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String types)(Code)(Java Doc)
public String getTimeDateFunctions()(Code)(Java Doc)
public ResultSet getTypeInfo() throws SQLException(Code)(Java Doc)
public ResultSet getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) throws SQLException(Code)(Java Doc)
public String getURL()(Code)(Java Doc)
public String getUserName()(Code)(Java Doc)
public ResultSet getVersionColumns(String catalog, String schema, String table) throws SQLException(Code)(Java Doc)
public boolean insertsAreDetected(int type)(Code)(Java Doc)
public boolean isCatalogAtStart()(Code)(Java Doc)
public boolean isReadOnly()(Code)(Java Doc)
public boolean nullPlusNonNullIsNull()(Code)(Java Doc)
public boolean nullsAreSortedAtEnd()(Code)(Java Doc)
public boolean nullsAreSortedAtStart()(Code)(Java Doc)
public boolean nullsAreSortedHigh()(Code)(Java Doc)
public boolean nullsAreSortedLow()(Code)(Java Doc)
public boolean othersDeletesAreVisible(int type)(Code)(Java Doc)
public boolean othersInsertsAreVisible(int type)(Code)(Java Doc)
public boolean othersUpdatesAreVisible(int type)(Code)(Java Doc)
public boolean ownDeletesAreVisible(int type)(Code)(Java Doc)
public boolean ownInsertsAreVisible(int type)(Code)(Java Doc)
public boolean ownUpdatesAreVisible(int type)(Code)(Java Doc)
public boolean storesLowerCaseIdentifiers()(Code)(Java Doc)
public boolean storesLowerCaseQuotedIdentifiers()(Code)(Java Doc)
public boolean storesMixedCaseIdentifiers()(Code)(Java Doc)
public boolean storesMixedCaseQuotedIdentifiers()(Code)(Java Doc)
public boolean storesUpperCaseIdentifiers()(Code)(Java Doc)
public boolean storesUpperCaseQuotedIdentifiers()(Code)(Java Doc)
public boolean supportsANSI92EntryLevelSQL()(Code)(Java Doc)
public boolean supportsANSI92FullSQL()(Code)(Java Doc)
public boolean supportsANSI92IntermediateSQL()(Code)(Java Doc)
public boolean supportsAlterTableWithAddColumn()(Code)(Java Doc)
public boolean supportsAlterTableWithDropColumn()(Code)(Java Doc)
public boolean supportsBatchUpdates()(Code)(Java Doc)
public boolean supportsCatalogsInDataManipulation()(Code)(Java Doc)
public boolean supportsCatalogsInIndexDefinitions()(Code)(Java Doc)
public boolean supportsCatalogsInPrivilegeDefinitions()(Code)(Java Doc)
public boolean supportsCatalogsInProcedureCalls()(Code)(Java Doc)
public boolean supportsCatalogsInTableDefinitions()(Code)(Java Doc)
public boolean supportsColumnAliasing()(Code)(Java Doc)
public boolean supportsConvert()(Code)(Java Doc)
public boolean supportsConvert(int fromType, int toType)(Code)(Java Doc)
public boolean supportsCoreSQLGrammar()(Code)(Java Doc)
public boolean supportsCorrelatedSubqueries()(Code)(Java Doc)
public boolean supportsDataDefinitionAndDataManipulationTransactions()(Code)(Java Doc)
public boolean supportsDataManipulationTransactionsOnly()(Code)(Java Doc)
public boolean supportsDifferentTableCorrelationNames()(Code)(Java Doc)
public boolean supportsExpressionsInOrderBy()(Code)(Java Doc)
public boolean supportsExtendedSQLGrammar()(Code)(Java Doc)
public boolean supportsFullOuterJoins()(Code)(Java Doc)
public boolean supportsGroupBy()(Code)(Java Doc)
public boolean supportsGroupByBeyondSelect()(Code)(Java Doc)
public boolean supportsGroupByUnrelated()(Code)(Java Doc)
public boolean supportsIntegrityEnhancementFacility()(Code)(Java Doc)
public boolean supportsLikeEscapeClause()(Code)(Java Doc)
public boolean supportsLimitedOuterJoins()(Code)(Java Doc)
public boolean supportsMinimumSQLGrammar()(Code)(Java Doc)
public boolean supportsMixedCaseIdentifiers()(Code)(Java Doc)
public boolean supportsMixedCaseQuotedIdentifiers()(Code)(Java Doc)
public boolean supportsMultipleResultSets()(Code)(Java Doc)
public boolean supportsMultipleTransactions()(Code)(Java Doc)
public boolean supportsNonNullableColumns()(Code)(Java Doc)
public boolean supportsOpenCursorsAcrossCommit()(Code)(Java Doc)
public boolean supportsOpenCursorsAcrossRollback()(Code)(Java Doc)
public boolean supportsOpenStatementsAcrossCommit()(Code)(Java Doc)
public boolean supportsOpenStatementsAcrossRollback()(Code)(Java Doc)
public boolean supportsOrderByUnrelated()(Code)(Java Doc)
public boolean supportsOuterJoins()(Code)(Java Doc)
public boolean supportsPositionedDelete()(Code)(Java Doc)
public boolean supportsPositionedUpdate()(Code)(Java Doc)
public boolean supportsResultSetConcurrency(int type, int concurrency)(Code)(Java Doc)
public boolean supportsResultSetType(int type)(Code)(Java Doc)
public boolean supportsSchemasInDataManipulation()(Code)(Java Doc)
public boolean supportsSchemasInIndexDefinitions()(Code)(Java Doc)
public boolean supportsSchemasInPrivilegeDefinitions()(Code)(Java Doc)
public boolean supportsSchemasInProcedureCalls()(Code)(Java Doc)
public boolean supportsSchemasInTableDefinitions()(Code)(Java Doc)
public boolean supportsSelectForUpdate()(Code)(Java Doc)
public boolean supportsStatementPooling()(Code)(Java Doc)
public boolean supportsStoredProcedures()(Code)(Java Doc)
public boolean supportsSubqueriesInComparisons()(Code)(Java Doc)
public boolean supportsSubqueriesInExists()(Code)(Java Doc)
public boolean supportsSubqueriesInIns()(Code)(Java Doc)
public boolean supportsSubqueriesInQuantifieds()(Code)(Java Doc)
public boolean supportsTableCorrelationNames()(Code)(Java Doc)
public boolean supportsTransactionIsolationLevel(int level)(Code)(Java Doc)
public boolean supportsTransactions()(Code)(Java Doc)
public boolean supportsUnion()(Code)(Java Doc)
public boolean supportsUnionAll()(Code)(Java Doc)
public boolean updatesAreDetected(int type)(Code)(Java Doc)
public boolean usesLocalFilePerTable()(Code)(Java Doc)
public boolean usesLocalFiles()(Code)(Java Doc)

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.