org.sqlite.jdbc
Class JdbcDatabaseMetaData

java.lang.Object
  extended by org.sqlite.jdbc.JdbcDatabaseMetaData
All Implemented Interfaces:
java.sql.DatabaseMetaData

public class JdbcDatabaseMetaData
extends java.lang.Object
implements java.sql.DatabaseMetaData


Field Summary
 
Fields inherited from interface java.sql.DatabaseMetaData
attributeNoNulls, attributeNullable, attributeNullableUnknown, bestRowNotPseudo, bestRowPseudo, bestRowSession, bestRowTemporary, bestRowTransaction, bestRowUnknown, columnNoNulls, columnNullable, columnNullableUnknown, importedKeyCascade, importedKeyInitiallyDeferred, importedKeyInitiallyImmediate, importedKeyNoAction, importedKeyNotDeferrable, importedKeyRestrict, importedKeySetDefault, importedKeySetNull, procedureColumnIn, procedureColumnInOut, procedureColumnOut, procedureColumnResult, procedureColumnReturn, procedureColumnUnknown, procedureNoNulls, procedureNoResult, procedureNullable, procedureNullableUnknown, procedureResultUnknown, procedureReturnsResult, sqlStateSQL99, sqlStateXOpen, tableIndexClustered, tableIndexHashed, tableIndexOther, tableIndexStatistic, typeNoNulls, typeNullable, typeNullableUnknown, typePredBasic, typePredChar, typePredNone, typeSearchable, versionColumnNotPseudo, versionColumnPseudo, versionColumnUnknown
 
Method Summary
 boolean allProceduresAreCallable()
          It always returns false.
 boolean allTablesAreSelectable()
          It always returns true.
 boolean dataDefinitionCausesTransactionCommit()
          It always returns false.
 boolean dataDefinitionIgnoredInTransactions()
          It always returns false.
 boolean deletesAreDetected(int type)
          It always returns false.
 boolean doesMaxRowSizeIncludeBlobs()
          It always returns true.
 java.sql.ResultSet getAttributes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, java.lang.String attributeNamePattern)
          Not suppoted yet.
 java.sql.ResultSet getBestRowIdentifier(java.lang.String catalog, java.lang.String schema, java.lang.String table, int scope, boolean nullable)
           
 java.sql.ResultSet getCatalogs()
          Catalog is not suppoted yet.
 java.lang.String getCatalogSeparator()
          Catalog is not supported yet.
 java.lang.String getCatalogTerm()
          Catalog is not supported yet.
static java.lang.String getColumnClassName(int columnType)
           
static int getColumnDisplaySize(int columnType)
           
 java.sql.ResultSet getColumnPrivileges(java.lang.String catalog, java.lang.String schema, java.lang.String table, java.lang.String columnNamePattern)
          Not suppoted yet.
 java.sql.ResultSet getColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String columnNamePattern)
           
static int getColumnType(int columnType)
           
 java.sql.Connection getConnection()
           
 java.sql.ResultSet getCrossReference(java.lang.String parentCatalog, java.lang.String parentSchema, java.lang.String parentTable, java.lang.String foreignCatalog, java.lang.String foreignSchema, java.lang.String foreignTable)
           
 java.util.List<DatabaseList> getDatabaseList()
          execute 'PRAGMA database_list' query.
 int getDatabaseMajorVersion()
          invoke sqlite3_libversion_number() function.
 int getDatabaseMinorVersion()
          invoke sqlite3_libversion_number() function.
 java.lang.String getDatabaseProductName()
          invoke org.sqlite.Database#getProductName() function.
 java.lang.String getDatabaseProductVersion()
          invoke sqlite3_libversion() function.
 int getDefaultTransactionIsolation()
          It always returns TRANSACTION_SERIALIZABLE.
 int getDriverMajorVersion()
          invoke org.sqlite.Driver#getDriverMajorVersion() function.
 int getDriverMinorVersion()
          invoke org.sqlite.Driver#getDriverMinorVersion() function.
 java.lang.String getDriverName()
          invoke org.sqlite.Driver#getDriverName() function.
 java.lang.String getDriverVersion()
          invoke org.sqlite.Driver#getDriverVersion() function.
 java.sql.ResultSet getExportedKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table)
           
 java.lang.String getExtraNameCharacters()
          It always returns empty string.
 java.util.List<ForeignKeyList> getForeignKeyList(java.lang.String tableName)
          execute 'PRAGMA foreign_key_list(table-name)' query.
 java.lang.String getIdentifierQuoteString()
          It always returns double quotes (").
 java.sql.ResultSet getImportedKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table)
           
 java.util.List<IndexInfo> getIndexInfo(java.lang.String indexName)
          execute 'PRAGMA index_info(index-name)' query.
 java.sql.ResultSet getIndexInfo(java.lang.String catalog, java.lang.String schema, java.lang.String table, boolean unique, boolean approximate)
           
 java.util.List<IndexList> getIndexList(java.lang.String tableName)
          execute 'PRAGMA index_list(table-name)' query.
 int getJDBCMajorVersion()
          It always returns 3.
 int getJDBCMinorVersion()
          It always returns 0.
 int getMaxBinaryLiteralLength()
          It always returns 0.
 int getMaxCatalogNameLength()
          Catalog is not supported yet.
 int getMaxCharLiteralLength()
          It always returns 0.
 int getMaxColumnNameLength()
          It always returns 0.
 int getMaxColumnsInGroupBy()
          It always returns 0.
 int getMaxColumnsInIndex()
          It always returns 0.
 int getMaxColumnsInOrderBy()
          It always returns 0.
 int getMaxColumnsInSelect()
          It always returns 0.
 int getMaxColumnsInTable()
          It always returns 0.
 int getMaxConnections()
          It always returns 0.
 int getMaxCursorNameLength()
          Cursor is not supported yet.
 int getMaxIndexLength()
          It always returns 0.
 int getMaxProcedureNameLength()
          Procedure is not supported yet.
 int getMaxRowSize()
          It always returns 0.
 int getMaxSchemaNameLength()
          Schema name is not supported yet.
 int getMaxStatementLength()
          It always returns 0.
 int getMaxStatements()
          It always returns 0.
 int getMaxTableNameLength()
          It always returns 0.
 int getMaxTablesInSelect()
          It always returns 64.
 int getMaxUserNameLength()
          User name is not supported yet.
 java.lang.String getNumericFunctions()
          It always returns empty string.
static int getPrecision(int columnType)
           
 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)
          Procedure is not suppoted yet.
 java.sql.ResultSet getProcedures(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedureNamePattern)
          Procedure is not suppoted yet.
 java.lang.String getProcedureTerm()
          Procedure is not supported yet.
static int getRadix(int columnType)
           
 int getResultSetHoldability()
          It always returns ResultSet.CLOSE_CURSORS_AT_COMMIT.
static int getScale(int columnType)
           
 java.sql.ResultSet getSchemas()
          Retrieves th open database list.
 java.lang.String getSchemaTerm()
          Schema is not supported yet.
 java.lang.String getSearchStringEscape()
          Escape charactor is NOTHING.
 java.lang.String getSQLKeywords()
          It always returns empty string.
 int getSQLStateType()
          It always returns sqlStateSQL99.
 java.lang.String getStringFunctions()
          It always returns empty string.
 java.sql.ResultSet getSuperTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern)
          Not suppoted yet.
 java.sql.ResultSet getSuperTypes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern)
          Not suppoted yet.
 java.lang.String getSystemFunctions()
          It always returns empty string.
 java.util.List<TableInfo> getTableInfo(java.lang.String tableName)
          execute 'PRAGMA table_info(table-name)' query.
 java.sql.ResultSet getTablePrivileges(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern)
          Not suppoted yet.
 java.sql.ResultSet getTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String[] types)
           
 java.sql.ResultSet getTableTypes()
          It always returns "TABLE" and "VIEW".
 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)
          UDT is not supported yet.
 java.lang.String getURL()
          Retrieves the URL for this DBMS.
 java.lang.String getUserName()
          It always returns null.
 java.sql.ResultSet getVersionColumns(java.lang.String catalog, java.lang.String schema, java.lang.String table)
          Not suppoted yet.
 boolean insertsAreDetected(int type)
          It always returns false.
 boolean isCatalogAtStart()
          Catalog is not supported yet.
 boolean isReadOnly()
          invoke JdbcConnection#isReadOnly() method.
static boolean isSigned(int columnType)
           
 boolean locatorsUpdateCopy()
          It always returns false.
 boolean nullPlusNonNullIsNull()
          It always returns true.
 boolean nullsAreSortedAtEnd()
          It always returns false.
 boolean nullsAreSortedAtStart()
          It always returns false.
 boolean nullsAreSortedHigh()
          It always returns false.
 boolean nullsAreSortedLow()
          It always returns true.
 boolean othersDeletesAreVisible(int type)
          It always returns false.
 boolean othersInsertsAreVisible(int type)
          It always returns false.
 boolean othersUpdatesAreVisible(int type)
          It always returns false.
 boolean ownDeletesAreVisible(int type)
          It always returns false.
 boolean ownInsertsAreVisible(int type)
          It always returns false.
 boolean ownUpdatesAreVisible(int type)
          It always returns false.
 boolean storesLowerCaseIdentifiers()
          It always returns false.
 boolean storesLowerCaseQuotedIdentifiers()
          It always returns false.
 boolean storesMixedCaseIdentifiers()
          It always returns true.
 boolean storesMixedCaseQuotedIdentifiers()
          It always returns true.
 boolean storesUpperCaseIdentifiers()
          It always returns false.
 boolean storesUpperCaseQuotedIdentifiers()
          It always returns false.
 boolean supportsAlterTableWithAddColumn()
          Supported by SQLite 3.0.0 or later.
 boolean supportsAlterTableWithDropColumn()
          It always returns false.
 boolean supportsANSI92EntryLevelSQL()
          It always returns true.
 boolean supportsANSI92FullSQL()
          It always returns false.
 boolean supportsANSI92IntermediateSQL()
          It always returns false.
 boolean supportsBatchUpdates()
          It always returns true.
 boolean supportsCatalogsInDataManipulation()
          It always returns false.
 boolean supportsCatalogsInIndexDefinitions()
          It always returns false.
 boolean supportsCatalogsInPrivilegeDefinitions()
          It always returns false.
 boolean supportsCatalogsInProcedureCalls()
          It always returns false.
 boolean supportsCatalogsInTableDefinitions()
          It always returns false.
 boolean supportsColumnAliasing()
          It always returns true.
 boolean supportsConvert()
          It always returns false.
 boolean supportsConvert(int fromType, int toType)
          It always returns false.
 boolean supportsCoreSQLGrammar()
          It always returns false.
 boolean supportsCorrelatedSubqueries()
          It always returns true.
 boolean supportsDataDefinitionAndDataManipulationTransactions()
          It always returns true.
 boolean supportsDataManipulationTransactionsOnly()
          It always returns false.
 boolean supportsDifferentTableCorrelationNames()
          It always returns false.
 boolean supportsExpressionsInOrderBy()
          It always returns true.
 boolean supportsExtendedSQLGrammar()
          It always returns false.
 boolean supportsFullOuterJoins()
          It always returns false.
 boolean supportsGetGeneratedKeys()
          Supported by sqlite3_last_insert_rowid() function.
 boolean supportsGroupBy()
          It always returns true.
 boolean supportsGroupByBeyondSelect()
          It always returns true.
 boolean supportsGroupByUnrelated()
          It always returns true.
 boolean supportsIntegrityEnhancementFacility()
          It always returns false.
 boolean supportsLikeEscapeClause()
          It always returns true.
 boolean supportsLimitedOuterJoins()
          It always returns true.
 boolean supportsMinimumSQLGrammar()
          It always returns false.
 boolean supportsMixedCaseIdentifiers()
          It always returns false.
 boolean supportsMixedCaseQuotedIdentifiers()
          It always returns false.
 boolean supportsMultipleOpenResults()
          CallableStatement is not supported yet.
 boolean supportsMultipleResultSets()
          It always returns true.
 boolean supportsMultipleTransactions()
          It always returns true.
 boolean supportsNamedParameters()
          It always returns true.
 boolean supportsNonNullableColumns()
          It always returns true.
 boolean supportsOpenCursorsAcrossCommit()
          It always returns false.
 boolean supportsOpenCursorsAcrossRollback()
          It always returns false.
 boolean supportsOpenStatementsAcrossCommit()
          It always returns false.
 boolean supportsOpenStatementsAcrossRollback()
          It always returns false.
 boolean supportsOrderByUnrelated()
          It always returns true.
 boolean supportsOuterJoins()
          It always returns true.
 boolean supportsPositionedDelete()
          It always returns false.
 boolean supportsPositionedUpdate()
          It always returns false.
 boolean supportsResultSetConcurrency(int type, int concurrency)
          Supported type is ResultSet.TYPE_FORWARD_ONLY and concurrency is ResultSet.CONCUR_READ_ONLY only.
 boolean supportsResultSetHoldability(int holdability)
          Supported type is ResultSet.CLOSE_CURSORS_AT_COMMIT only.
 boolean supportsResultSetType(int type)
          Supported type is ResultSet.TYPE_FORWARD_ONLY only.
 boolean supportsSavepoints()
          It always returns false.
 boolean supportsSchemasInDataManipulation()
          It always returns false.
 boolean supportsSchemasInIndexDefinitions()
          It always returns false.
 boolean supportsSchemasInPrivilegeDefinitions()
          It always returns false.
 boolean supportsSchemasInProcedureCalls()
          It always returns false.
 boolean supportsSchemasInTableDefinitions()
          It always returns false.
 boolean supportsSelectForUpdate()
          It always returns false.
 boolean supportsStatementPooling()
          It always returns false.
 boolean supportsStoredProcedures()
          It always returns false.
 boolean supportsSubqueriesInComparisons()
          It always returns true.
 boolean supportsSubqueriesInExists()
          It always returns true.
 boolean supportsSubqueriesInIns()
          It always returns true.
 boolean supportsSubqueriesInQuantifieds()
          It always returns false.
 boolean supportsTableCorrelationNames()
          It always returns true.
 boolean supportsTransactionIsolationLevel(int level)
           
 boolean supportsTransactions()
          It always returns true.
 boolean supportsUnion()
          It always returns true.
 boolean supportsUnionAll()
          It always returns true.
 boolean updatesAreDetected(int type)
          It always returns false.
 boolean usesLocalFilePerTable()
          It always returns false.
 boolean usesLocalFiles()
          false is returned for the in-memory database.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Method Detail

allProceduresAreCallable

public boolean allProceduresAreCallable()
It always returns false.

Specified by:
allProceduresAreCallable in interface java.sql.DatabaseMetaData
Returns:
false

allTablesAreSelectable

public boolean allTablesAreSelectable()
It always returns true.

Specified by:
allTablesAreSelectable in interface java.sql.DatabaseMetaData
Returns:
true

getURL

public java.lang.String getURL()
Retrieves the URL for this DBMS.

Specified by:
getURL in interface java.sql.DatabaseMetaData
Returns:
the URL for this DBMS.

getUserName

public java.lang.String getUserName()
It always returns null.

Specified by:
getUserName in interface java.sql.DatabaseMetaData
Returns:
null

isReadOnly

public boolean isReadOnly()
                   throws java.sql.SQLException
invoke JdbcConnection#isReadOnly() method.

Specified by:
isReadOnly in interface java.sql.DatabaseMetaData
Returns:
Returs the value of JdbcConnection#isReadOnly()
Throws:
java.sql.SQLException
See Also:
JdbcConnection.isReadOnly()

nullsAreSortedHigh

public boolean nullsAreSortedHigh()
It always returns false.

Specified by:
nullsAreSortedHigh in interface java.sql.DatabaseMetaData
Returns:
false

nullsAreSortedLow

public boolean nullsAreSortedLow()
It always returns true.

Specified by:
nullsAreSortedLow in interface java.sql.DatabaseMetaData
Returns:
true

nullsAreSortedAtStart

public boolean nullsAreSortedAtStart()
It always returns false.

Specified by:
nullsAreSortedAtStart in interface java.sql.DatabaseMetaData
Returns:
false

nullsAreSortedAtEnd

public boolean nullsAreSortedAtEnd()
It always returns false.

Specified by:
nullsAreSortedAtEnd in interface java.sql.DatabaseMetaData
Returns:
false

getDatabaseProductName

public java.lang.String getDatabaseProductName()
invoke org.sqlite.Database#getProductName() function.

Specified by:
getDatabaseProductName in interface java.sql.DatabaseMetaData
Returns:
Returns the value of org.sqlite.Database#getProductName()
See Also:
Database.getProductName()

getDatabaseProductVersion

public java.lang.String getDatabaseProductVersion()
invoke sqlite3_libversion() function.

Specified by:
getDatabaseProductVersion in interface java.sql.DatabaseMetaData
Returns:
Returns the value of sqlite3_libversion()
See Also:
Run-Time Library Version Numbers

getDriverName

public java.lang.String getDriverName()
invoke org.sqlite.Driver#getDriverName() function.

Specified by:
getDriverName in interface java.sql.DatabaseMetaData
Returns:
Returns the value of org.sqlite.Driver#getDriverName()
See Also:
Driver.getDriverName()

getDriverVersion

public java.lang.String getDriverVersion()
invoke org.sqlite.Driver#getDriverVersion() function.

Specified by:
getDriverVersion in interface java.sql.DatabaseMetaData
Returns:
See Also:
Driver.getDriverVersion()

getDriverMajorVersion

public int getDriverMajorVersion()
invoke org.sqlite.Driver#getDriverMajorVersion() function.

Specified by:
getDriverMajorVersion in interface java.sql.DatabaseMetaData
Returns:
Returns the value of org.sqlite.Driver#getDriverMajorVersion()
See Also:
Driver.getDriverMajorVersion()

getDriverMinorVersion

public int getDriverMinorVersion()
invoke org.sqlite.Driver#getDriverMinorVersion() function.

Specified by:
getDriverMinorVersion in interface java.sql.DatabaseMetaData
Returns:
Returns the value of org.sqlite.Driver#getDriverMinorVersion()
See Also:
Driver.getDriverMinorVersion()

usesLocalFiles

public boolean usesLocalFiles()
false is returned for the in-memory database.

Specified by:
usesLocalFiles in interface java.sql.DatabaseMetaData
Returns:
false is returned for the in-memory database.
See Also:
Database.isInMemoryMode()

usesLocalFilePerTable

public boolean usesLocalFilePerTable()
It always returns false.

Specified by:
usesLocalFilePerTable in interface java.sql.DatabaseMetaData
Returns:
false

supportsMixedCaseIdentifiers

public boolean supportsMixedCaseIdentifiers()
It always returns false.

Specified by:
supportsMixedCaseIdentifiers in interface java.sql.DatabaseMetaData
Returns:
false

storesUpperCaseIdentifiers

public boolean storesUpperCaseIdentifiers()
It always returns false.

Specified by:
storesUpperCaseIdentifiers in interface java.sql.DatabaseMetaData
Returns:
false

storesLowerCaseIdentifiers

public boolean storesLowerCaseIdentifiers()
It always returns false.

Specified by:
storesLowerCaseIdentifiers in interface java.sql.DatabaseMetaData
Returns:
false

storesMixedCaseIdentifiers

public boolean storesMixedCaseIdentifiers()
It always returns true.

Specified by:
storesMixedCaseIdentifiers in interface java.sql.DatabaseMetaData
Returns:
true

supportsMixedCaseQuotedIdentifiers

public boolean supportsMixedCaseQuotedIdentifiers()
It always returns false.

Specified by:
supportsMixedCaseQuotedIdentifiers in interface java.sql.DatabaseMetaData
Returns:
false

storesUpperCaseQuotedIdentifiers

public boolean storesUpperCaseQuotedIdentifiers()
It always returns false.

Specified by:
storesUpperCaseQuotedIdentifiers in interface java.sql.DatabaseMetaData
Returns:
false

storesLowerCaseQuotedIdentifiers

public boolean storesLowerCaseQuotedIdentifiers()
It always returns false.

Specified by:
storesLowerCaseQuotedIdentifiers in interface java.sql.DatabaseMetaData
Returns:
false

storesMixedCaseQuotedIdentifiers

public boolean storesMixedCaseQuotedIdentifiers()
It always returns true.

Specified by:
storesMixedCaseQuotedIdentifiers in interface java.sql.DatabaseMetaData
Returns:
true

getIdentifierQuoteString

public java.lang.String getIdentifierQuoteString()
It always returns double quotes (").

Specified by:
getIdentifierQuoteString in interface java.sql.DatabaseMetaData
Returns:
double quotes (")

getSQLKeywords

public java.lang.String getSQLKeywords()
It always returns empty string.

Specified by:
getSQLKeywords in interface java.sql.DatabaseMetaData
Returns:
empty string

getNumericFunctions

public java.lang.String getNumericFunctions()
It always returns empty string.

Specified by:
getNumericFunctions in interface java.sql.DatabaseMetaData
Returns:
empty string

getStringFunctions

public java.lang.String getStringFunctions()
It always returns empty string.

Specified by:
getStringFunctions in interface java.sql.DatabaseMetaData
Returns:
empty string

getSystemFunctions

public java.lang.String getSystemFunctions()
It always returns empty string.

Specified by:
getSystemFunctions in interface java.sql.DatabaseMetaData
Returns:
empty string

getTimeDateFunctions

public java.lang.String getTimeDateFunctions()
Specified by:
getTimeDateFunctions in interface java.sql.DatabaseMetaData
Returns:
See Also:
Date And Time Functions

getSearchStringEscape

public java.lang.String getSearchStringEscape()
Escape charactor is NOTHING. It always returns null.

Specified by:
getSearchStringEscape in interface java.sql.DatabaseMetaData
Returns:
null

getExtraNameCharacters

public java.lang.String getExtraNameCharacters()
It always returns empty string.

Specified by:
getExtraNameCharacters in interface java.sql.DatabaseMetaData
Returns:
empty string

supportsAlterTableWithAddColumn

public boolean supportsAlterTableWithAddColumn()
Supported by SQLite 3.0.0 or later. It always returns true.

Specified by:
supportsAlterTableWithAddColumn in interface java.sql.DatabaseMetaData
Returns:
true

supportsAlterTableWithDropColumn

public boolean supportsAlterTableWithDropColumn()
It always returns false.

Specified by:
supportsAlterTableWithDropColumn in interface java.sql.DatabaseMetaData
Returns:
false

supportsColumnAliasing

public boolean supportsColumnAliasing()
It always returns true.

Specified by:
supportsColumnAliasing in interface java.sql.DatabaseMetaData
Returns:
true

nullPlusNonNullIsNull

public boolean nullPlusNonNullIsNull()
It always returns true.

Specified by:
nullPlusNonNullIsNull in interface java.sql.DatabaseMetaData
Returns:
true

supportsConvert

public boolean supportsConvert()
It always returns false.

Specified by:
supportsConvert in interface java.sql.DatabaseMetaData
Returns:
false

supportsConvert

public boolean supportsConvert(int fromType,
                               int toType)
It always returns false.

Specified by:
supportsConvert in interface java.sql.DatabaseMetaData
Parameters:
fromType - ignored
toType - ignored
Returns:
false

supportsTableCorrelationNames

public boolean supportsTableCorrelationNames()
It always returns true.

Specified by:
supportsTableCorrelationNames in interface java.sql.DatabaseMetaData
Returns:
true

supportsDifferentTableCorrelationNames

public boolean supportsDifferentTableCorrelationNames()
It always returns false.

Specified by:
supportsDifferentTableCorrelationNames in interface java.sql.DatabaseMetaData
Returns:
false

supportsExpressionsInOrderBy

public boolean supportsExpressionsInOrderBy()
It always returns true.

Specified by:
supportsExpressionsInOrderBy in interface java.sql.DatabaseMetaData
Returns:
true

supportsOrderByUnrelated

public boolean supportsOrderByUnrelated()
It always returns true.

Specified by:
supportsOrderByUnrelated in interface java.sql.DatabaseMetaData
Returns:
true

supportsGroupBy

public boolean supportsGroupBy()
It always returns true.

Specified by:
supportsGroupBy in interface java.sql.DatabaseMetaData
Returns:
true

supportsGroupByUnrelated

public boolean supportsGroupByUnrelated()
It always returns true.

Specified by:
supportsGroupByUnrelated in interface java.sql.DatabaseMetaData
Returns:
true

supportsGroupByBeyondSelect

public boolean supportsGroupByBeyondSelect()
It always returns true.

Specified by:
supportsGroupByBeyondSelect in interface java.sql.DatabaseMetaData
Returns:
true

supportsLikeEscapeClause

public boolean supportsLikeEscapeClause()
It always returns true.

Specified by:
supportsLikeEscapeClause in interface java.sql.DatabaseMetaData
Returns:
true

supportsMultipleResultSets

public boolean supportsMultipleResultSets()
It always returns true.

Specified by:
supportsMultipleResultSets in interface java.sql.DatabaseMetaData
Returns:
true
See Also:
JdbcStatement.execute(String), JdbcStatement.getMoreResults(), JdbcStatement.getMoreResults(int)

supportsMultipleTransactions

public boolean supportsMultipleTransactions()
It always returns true.

Specified by:
supportsMultipleTransactions in interface java.sql.DatabaseMetaData
Returns:
true

supportsNonNullableColumns

public boolean supportsNonNullableColumns()
It always returns true.

Specified by:
supportsNonNullableColumns in interface java.sql.DatabaseMetaData
Returns:
true

supportsMinimumSQLGrammar

public boolean supportsMinimumSQLGrammar()
It always returns false.

Specified by:
supportsMinimumSQLGrammar in interface java.sql.DatabaseMetaData
Returns:
false

supportsCoreSQLGrammar

public boolean supportsCoreSQLGrammar()
It always returns false.

Specified by:
supportsCoreSQLGrammar in interface java.sql.DatabaseMetaData
Returns:
false

supportsExtendedSQLGrammar

public boolean supportsExtendedSQLGrammar()
It always returns false.

Specified by:
supportsExtendedSQLGrammar in interface java.sql.DatabaseMetaData
Returns:
false

supportsANSI92EntryLevelSQL

public boolean supportsANSI92EntryLevelSQL()
It always returns true.

Specified by:
supportsANSI92EntryLevelSQL in interface java.sql.DatabaseMetaData
Returns:
true
See Also:
sqlite - Unsupported Sql

supportsANSI92IntermediateSQL

public boolean supportsANSI92IntermediateSQL()
It always returns false.

Specified by:
supportsANSI92IntermediateSQL in interface java.sql.DatabaseMetaData
Returns:
false
See Also:
sqlite - Unsupported Sql

supportsANSI92FullSQL

public boolean supportsANSI92FullSQL()
It always returns false.

Specified by:
supportsANSI92FullSQL in interface java.sql.DatabaseMetaData
Returns:
false
See Also:
sqlite - Unsupported Sql

supportsIntegrityEnhancementFacility

public boolean supportsIntegrityEnhancementFacility()
It always returns false.

Specified by:
supportsIntegrityEnhancementFacility in interface java.sql.DatabaseMetaData
Returns:
false

supportsOuterJoins

public boolean supportsOuterJoins()
It always returns true.

Specified by:
supportsOuterJoins in interface java.sql.DatabaseMetaData
Returns:
true

supportsFullOuterJoins

public boolean supportsFullOuterJoins()
It always returns false.

Specified by:
supportsFullOuterJoins in interface java.sql.DatabaseMetaData
Returns:
false

supportsLimitedOuterJoins

public boolean supportsLimitedOuterJoins()
It always returns true.

Specified by:
supportsLimitedOuterJoins in interface java.sql.DatabaseMetaData
Returns:
true

getSchemaTerm

public java.lang.String getSchemaTerm()
Schema is not supported yet. It always returns null.

Specified by:
getSchemaTerm in interface java.sql.DatabaseMetaData
Returns:
null

getProcedureTerm

public java.lang.String getProcedureTerm()
Procedure is not supported yet. It always returns null.

Specified by:
getProcedureTerm in interface java.sql.DatabaseMetaData
Returns:
null

getCatalogTerm

public java.lang.String getCatalogTerm()
Catalog is not supported yet. It always returns null.

Specified by:
getCatalogTerm in interface java.sql.DatabaseMetaData
Returns:
null

isCatalogAtStart

public boolean isCatalogAtStart()
Catalog is not supported yet. It always returns false.

Specified by:
isCatalogAtStart in interface java.sql.DatabaseMetaData
Returns:
false

getCatalogSeparator

public java.lang.String getCatalogSeparator()
Catalog is not supported yet. It always returns null.

Specified by:
getCatalogSeparator in interface java.sql.DatabaseMetaData
Returns:
null

supportsSchemasInDataManipulation

public boolean supportsSchemasInDataManipulation()
It always returns false.

Specified by:
supportsSchemasInDataManipulation in interface java.sql.DatabaseMetaData
Returns:
false

supportsSchemasInProcedureCalls

public boolean supportsSchemasInProcedureCalls()
It always returns false.

Specified by:
supportsSchemasInProcedureCalls in interface java.sql.DatabaseMetaData
Returns:
false

supportsSchemasInTableDefinitions

public boolean supportsSchemasInTableDefinitions()
It always returns false.

Specified by:
supportsSchemasInTableDefinitions in interface java.sql.DatabaseMetaData
Returns:
false

supportsSchemasInIndexDefinitions

public boolean supportsSchemasInIndexDefinitions()
It always returns false.

Specified by:
supportsSchemasInIndexDefinitions in interface java.sql.DatabaseMetaData
Returns:
false

supportsSchemasInPrivilegeDefinitions

public boolean supportsSchemasInPrivilegeDefinitions()
It always returns false.

Specified by:
supportsSchemasInPrivilegeDefinitions in interface java.sql.DatabaseMetaData
Returns:
false

supportsCatalogsInDataManipulation

public boolean supportsCatalogsInDataManipulation()
It always returns false.

Specified by:
supportsCatalogsInDataManipulation in interface java.sql.DatabaseMetaData
Returns:
false

supportsCatalogsInProcedureCalls

public boolean supportsCatalogsInProcedureCalls()
It always returns false.

Specified by:
supportsCatalogsInProcedureCalls in interface java.sql.DatabaseMetaData
Returns:
false

supportsCatalogsInTableDefinitions

public boolean supportsCatalogsInTableDefinitions()
It always returns false.

Specified by:
supportsCatalogsInTableDefinitions in interface java.sql.DatabaseMetaData
Returns:
false

supportsCatalogsInIndexDefinitions

public boolean supportsCatalogsInIndexDefinitions()
It always returns false.

Specified by:
supportsCatalogsInIndexDefinitions in interface java.sql.DatabaseMetaData
Returns:
false

supportsCatalogsInPrivilegeDefinitions

public boolean supportsCatalogsInPrivilegeDefinitions()
It always returns false.

Specified by:
supportsCatalogsInPrivilegeDefinitions in interface java.sql.DatabaseMetaData
Returns:
false

supportsPositionedDelete

public boolean supportsPositionedDelete()
It always returns false.

Specified by:
supportsPositionedDelete in interface java.sql.DatabaseMetaData
Returns:
false

supportsPositionedUpdate

public boolean supportsPositionedUpdate()
It always returns false.

Specified by:
supportsPositionedUpdate in interface java.sql.DatabaseMetaData
Returns:
false

supportsSelectForUpdate

public boolean supportsSelectForUpdate()
It always returns false.

Specified by:
supportsSelectForUpdate in interface java.sql.DatabaseMetaData
Returns:
false

supportsStoredProcedures

public boolean supportsStoredProcedures()
It always returns false.

Specified by:
supportsStoredProcedures in interface java.sql.DatabaseMetaData
Returns:
false

supportsSubqueriesInComparisons

public boolean supportsSubqueriesInComparisons()
It always returns true.

Specified by:
supportsSubqueriesInComparisons in interface java.sql.DatabaseMetaData
Returns:
true

supportsSubqueriesInExists

public boolean supportsSubqueriesInExists()
It always returns true.

Specified by:
supportsSubqueriesInExists in interface java.sql.DatabaseMetaData
Returns:
true

supportsSubqueriesInIns

public boolean supportsSubqueriesInIns()
It always returns true.

Specified by:
supportsSubqueriesInIns in interface java.sql.DatabaseMetaData
Returns:
true

supportsSubqueriesInQuantifieds

public boolean supportsSubqueriesInQuantifieds()
It always returns false.

Specified by:
supportsSubqueriesInQuantifieds in interface java.sql.DatabaseMetaData
Returns:
false

supportsCorrelatedSubqueries

public boolean supportsCorrelatedSubqueries()
It always returns true.

Specified by:
supportsCorrelatedSubqueries in interface java.sql.DatabaseMetaData
Returns:
true

supportsUnion

public boolean supportsUnion()
It always returns true.

Specified by:
supportsUnion in interface java.sql.DatabaseMetaData
Returns:
true

supportsUnionAll

public boolean supportsUnionAll()
It always returns true.

Specified by:
supportsUnionAll in interface java.sql.DatabaseMetaData
Returns:
true

supportsOpenCursorsAcrossCommit

public boolean supportsOpenCursorsAcrossCommit()
It always returns false.

Specified by:
supportsOpenCursorsAcrossCommit in interface java.sql.DatabaseMetaData
Returns:
false

supportsOpenCursorsAcrossRollback

public boolean supportsOpenCursorsAcrossRollback()
It always returns false.

Specified by:
supportsOpenCursorsAcrossRollback in interface java.sql.DatabaseMetaData
Returns:
false

supportsOpenStatementsAcrossCommit

public boolean supportsOpenStatementsAcrossCommit()
It always returns false.

Specified by:
supportsOpenStatementsAcrossCommit in interface java.sql.DatabaseMetaData
Returns:
false

supportsOpenStatementsAcrossRollback

public boolean supportsOpenStatementsAcrossRollback()
It always returns false.

Specified by:
supportsOpenStatementsAcrossRollback in interface java.sql.DatabaseMetaData
Returns:
false

getMaxBinaryLiteralLength

public int getMaxBinaryLiteralLength()
It always returns 0.

Specified by:
getMaxBinaryLiteralLength in interface java.sql.DatabaseMetaData
Returns:
0

getMaxCharLiteralLength

public int getMaxCharLiteralLength()
It always returns 0.

Specified by:
getMaxCharLiteralLength in interface java.sql.DatabaseMetaData
Returns:
0

getMaxColumnNameLength

public int getMaxColumnNameLength()
It always returns 0.

Specified by:
getMaxColumnNameLength in interface java.sql.DatabaseMetaData
Returns:
0

getMaxColumnsInGroupBy

public int getMaxColumnsInGroupBy()
It always returns 0.

Specified by:
getMaxColumnsInGroupBy in interface java.sql.DatabaseMetaData
Returns:
0

getMaxColumnsInIndex

public int getMaxColumnsInIndex()
It always returns 0.

Specified by:
getMaxColumnsInIndex in interface java.sql.DatabaseMetaData
Returns:
0

getMaxColumnsInOrderBy

public int getMaxColumnsInOrderBy()
It always returns 0.

Specified by:
getMaxColumnsInOrderBy in interface java.sql.DatabaseMetaData
Returns:
0

getMaxColumnsInSelect

public int getMaxColumnsInSelect()
It always returns 0.

Specified by:
getMaxColumnsInSelect in interface java.sql.DatabaseMetaData
Returns:
0

getMaxColumnsInTable

public int getMaxColumnsInTable()
It always returns 0.

Specified by:
getMaxColumnsInTable in interface java.sql.DatabaseMetaData
Returns:
0

getMaxConnections

public int getMaxConnections()
It always returns 0.

Specified by:
getMaxConnections in interface java.sql.DatabaseMetaData
Returns:
0

getMaxCursorNameLength

public int getMaxCursorNameLength()
Cursor is not supported yet. It always returns 0.

Specified by:
getMaxCursorNameLength in interface java.sql.DatabaseMetaData
Returns:
0

getMaxIndexLength

public int getMaxIndexLength()
It always returns 0.

Specified by:
getMaxIndexLength in interface java.sql.DatabaseMetaData
Returns:
0

getMaxSchemaNameLength

public int getMaxSchemaNameLength()
Schema name is not supported yet. It always returns 0.

Specified by:
getMaxSchemaNameLength in interface java.sql.DatabaseMetaData
Returns:
0

getMaxProcedureNameLength

public int getMaxProcedureNameLength()
Procedure is not supported yet. It always returns 0.

Specified by:
getMaxProcedureNameLength in interface java.sql.DatabaseMetaData
Returns:
0

getMaxCatalogNameLength

public int getMaxCatalogNameLength()
Catalog is not supported yet. It always returns 0.

Specified by:
getMaxCatalogNameLength in interface java.sql.DatabaseMetaData
Returns:
0

getMaxRowSize

public int getMaxRowSize()
It always returns 0.

Specified by:
getMaxRowSize in interface java.sql.DatabaseMetaData
Returns:
0

doesMaxRowSizeIncludeBlobs

public boolean doesMaxRowSizeIncludeBlobs()
It always returns true.

Specified by:
doesMaxRowSizeIncludeBlobs in interface java.sql.DatabaseMetaData
Returns:
true

getMaxStatementLength

public int getMaxStatementLength()
It always returns 0.

Specified by:
getMaxStatementLength in interface java.sql.DatabaseMetaData
Returns:
0

getMaxStatements

public int getMaxStatements()
It always returns 0.

Specified by:
getMaxStatements in interface java.sql.DatabaseMetaData
Returns:
0

getMaxTableNameLength

public int getMaxTableNameLength()
It always returns 0.

Specified by:
getMaxTableNameLength in interface java.sql.DatabaseMetaData
Returns:
0

getMaxTablesInSelect

public int getMaxTablesInSelect()
It always returns 64.

Specified by:
getMaxTablesInSelect in interface java.sql.DatabaseMetaData
Returns:
64
See Also:
Maximum Number Of Tables In A Join

getMaxUserNameLength

public int getMaxUserNameLength()
User name is not supported yet. It always returns 0.

Specified by:
getMaxUserNameLength in interface java.sql.DatabaseMetaData
Returns:
0

getDefaultTransactionIsolation

public int getDefaultTransactionIsolation()
It always returns TRANSACTION_SERIALIZABLE.

Specified by:
getDefaultTransactionIsolation in interface java.sql.DatabaseMetaData
Returns:
java.sql.Connection.TRANSACTION_SERIALIZABLE
See Also:
PRAGMA read_uncommitted

supportsTransactions

public boolean supportsTransactions()
It always returns true.

Specified by:
supportsTransactions in interface java.sql.DatabaseMetaData
Returns:
true

supportsTransactionIsolationLevel

public boolean supportsTransactionIsolationLevel(int level)
Specified by:
supportsTransactionIsolationLevel in interface java.sql.DatabaseMetaData
Parameters:
level -
Returns:
true if level is java.sql.Connection.TRANSACTION_SERIALIZABLE.
See Also:
Pragma statements supported by SQLite:

supportsDataDefinitionAndDataManipulationTransactions

public boolean supportsDataDefinitionAndDataManipulationTransactions()
It always returns true.

Specified by:
supportsDataDefinitionAndDataManipulationTransactions in interface java.sql.DatabaseMetaData
Returns:
true

supportsDataManipulationTransactionsOnly

public boolean supportsDataManipulationTransactionsOnly()
It always returns false.

Specified by:
supportsDataManipulationTransactionsOnly in interface java.sql.DatabaseMetaData
Returns:
false

dataDefinitionCausesTransactionCommit

public boolean dataDefinitionCausesTransactionCommit()
It always returns false.

Specified by:
dataDefinitionCausesTransactionCommit in interface java.sql.DatabaseMetaData
Returns:
false

dataDefinitionIgnoredInTransactions

public boolean dataDefinitionIgnoredInTransactions()
It always returns false.

Specified by:
dataDefinitionIgnoredInTransactions in interface java.sql.DatabaseMetaData
Returns:
false

getProcedures

public java.sql.ResultSet getProcedures(java.lang.String catalog,
                                        java.lang.String schemaPattern,
                                        java.lang.String procedureNamePattern)
                                 throws java.sql.SQLException
Procedure is not suppoted yet. It always returns empty ResultSet.

Specified by:
getProcedures in interface java.sql.DatabaseMetaData
Parameters:
catalog - ignored
schemaPattern - ignored
procedureNamePattern - ignored
Returns:
empty ResultSet
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
Procedure is not suppoted yet. It always returns empty ResultSet.

Specified by:
getProcedureColumns in interface java.sql.DatabaseMetaData
Parameters:
catalog - ignored
schemaPattern - ignored
procedureNamePattern - ignored
Returns:
empty ResultSet
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
Specified by:
getTables in interface java.sql.DatabaseMetaData
Parameters:
catalog - ignored
schemaPattern - ignored
tableNamePattern -
types -
Returns:
Throws:
java.sql.SQLException

getSchemas

public java.sql.ResultSet getSchemas()
                              throws java.sql.SQLException
Retrieves th open database list.

Specified by:
getSchemas in interface java.sql.DatabaseMetaData
Returns:
Throws:
java.sql.SQLException

getCatalogs

public java.sql.ResultSet getCatalogs()
                               throws java.sql.SQLException
Catalog is not suppoted yet. It always returns empty ResultSet.

Specified by:
getCatalogs in interface java.sql.DatabaseMetaData
Returns:
empty ResultSet
Throws:
java.sql.SQLException

getTableTypes

public java.sql.ResultSet getTableTypes()
                                 throws java.sql.SQLException
It always returns "TABLE" and "VIEW".

Specified by:
getTableTypes in interface java.sql.DatabaseMetaData
Returns:
"TABLE" and "VIEW"
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
Specified by:
getColumns in interface java.sql.DatabaseMetaData
Parameters:
catalog - ignored
schemaPattern - ignored
tableNamePattern -
columnNamePattern -
Returns:
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
Not suppoted yet. It always returns empty ResultSet.

Specified by:
getColumnPrivileges in interface java.sql.DatabaseMetaData
Parameters:
catalog - ignored
schema - ignored
table - ignored
columnNamePattern - ignored
Returns:
empty ResultSet
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
Not suppoted yet. It always returns empty ResultSet.

Specified by:
getTablePrivileges in interface java.sql.DatabaseMetaData
Parameters:
catalog - ignored
schemaPattern - ignored
tableNamePattern - ignored
Returns:
empty ResultSet
Throws:
java.sql.SQLException

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
Specified by:
getBestRowIdentifier in interface java.sql.DatabaseMetaData
Parameters:
catalog - ignored
schema - ignored
table -
scope - ignored
nullable -
Returns:
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
Not suppoted yet. It always returns empty ResultSet.

Specified by:
getVersionColumns in interface java.sql.DatabaseMetaData
Parameters:
catalog - ignored
schema - ignored
table - ignored
Returns:
empty ResultSet
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
Specified by:
getPrimaryKeys in interface java.sql.DatabaseMetaData
Parameters:
catalog - ignored
schema - ignored
table -
Returns:
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
Specified by:
getImportedKeys in interface java.sql.DatabaseMetaData
Parameters:
catalog - ignored
schema - ignored
table -
Returns:
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
Specified by:
getExportedKeys in interface java.sql.DatabaseMetaData
Parameters:
catalog - ignored
schema - ignored
table -
Returns:
Throws:
java.sql.SQLException

getCrossReference

public java.sql.ResultSet getCrossReference(java.lang.String parentCatalog,
                                            java.lang.String parentSchema,
                                            java.lang.String parentTable,
                                            java.lang.String foreignCatalog,
                                            java.lang.String foreignSchema,
                                            java.lang.String foreignTable)
                                     throws java.sql.SQLException
Specified by:
getCrossReference in interface java.sql.DatabaseMetaData
Parameters:
parentCatalog - ignored
parentSchema - ignored
parentTable -
foreignCatalog - ignored
foreignSchema - ignored
foreignTable -
Returns:
Throws:
java.sql.SQLException

getTypeInfo

public java.sql.ResultSet getTypeInfo()
                               throws java.sql.SQLException
Specified by:
getTypeInfo in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException

getIndexInfo

public java.sql.ResultSet getIndexInfo(java.lang.String catalog,
                                       java.lang.String schema,
                                       java.lang.String table,
                                       boolean unique,
                                       boolean approximate)
                                throws java.sql.SQLException
Specified by:
getIndexInfo in interface java.sql.DatabaseMetaData
Parameters:
catalog - ignored
schema - ignored
table -
unique -
approximate - ignored
Returns:
Throws:
java.sql.SQLException

supportsResultSetType

public boolean supportsResultSetType(int type)
Supported type is ResultSet.TYPE_FORWARD_ONLY only.

Specified by:
supportsResultSetType in interface java.sql.DatabaseMetaData
Parameters:
type -
Returns:
true if type is java.sql.ResultSet.TYPE_FORWARD_ONLY.

supportsResultSetConcurrency

public boolean supportsResultSetConcurrency(int type,
                                            int concurrency)
Supported type is ResultSet.TYPE_FORWARD_ONLY and concurrency is ResultSet.CONCUR_READ_ONLY only.

Specified by:
supportsResultSetConcurrency in interface java.sql.DatabaseMetaData
Parameters:
type -
concurrency -
Returns:
true if type is java.sql.ResultSet.TYPE_FORWARD_ONLY and concurrency is java.sql.ResultSet.CONCUR_READ_ONLY.

ownUpdatesAreVisible

public boolean ownUpdatesAreVisible(int type)
It always returns false.

Specified by:
ownUpdatesAreVisible in interface java.sql.DatabaseMetaData
Parameters:
type - ignored
Returns:
false

ownDeletesAreVisible

public boolean ownDeletesAreVisible(int type)
It always returns false.

Specified by:
ownDeletesAreVisible in interface java.sql.DatabaseMetaData
Parameters:
type - ignored
Returns:
false

ownInsertsAreVisible

public boolean ownInsertsAreVisible(int type)
It always returns false.

Specified by:
ownInsertsAreVisible in interface java.sql.DatabaseMetaData
Parameters:
type - ignored
Returns:
false

othersUpdatesAreVisible

public boolean othersUpdatesAreVisible(int type)
It always returns false.

Specified by:
othersUpdatesAreVisible in interface java.sql.DatabaseMetaData
Parameters:
type - ignored
Returns:
false

othersDeletesAreVisible

public boolean othersDeletesAreVisible(int type)
It always returns false.

Specified by:
othersDeletesAreVisible in interface java.sql.DatabaseMetaData
Parameters:
type - ignored
Returns:
false

othersInsertsAreVisible

public boolean othersInsertsAreVisible(int type)
It always returns false.

Specified by:
othersInsertsAreVisible in interface java.sql.DatabaseMetaData
Parameters:
type - ignored
Returns:
false

updatesAreDetected

public boolean updatesAreDetected(int type)
It always returns false.

Specified by:
updatesAreDetected in interface java.sql.DatabaseMetaData
Parameters:
type - ignored
Returns:
false

deletesAreDetected

public boolean deletesAreDetected(int type)
It always returns false.

Specified by:
deletesAreDetected in interface java.sql.DatabaseMetaData
Parameters:
type - ignored
Returns:
false

insertsAreDetected

public boolean insertsAreDetected(int type)
It always returns false.

Specified by:
insertsAreDetected in interface java.sql.DatabaseMetaData
Parameters:
type - ignored
Returns:
false

supportsBatchUpdates

public boolean supportsBatchUpdates()
It always returns true.

Specified by:
supportsBatchUpdates in interface java.sql.DatabaseMetaData
Returns:
true

getUDTs

public java.sql.ResultSet getUDTs(java.lang.String catalog,
                                  java.lang.String schemaPattern,
                                  java.lang.String typeNamePattern,
                                  int[] types)
                           throws java.sql.SQLException
UDT is not supported yet. It always returns empty ResultSet.

Specified by:
getUDTs in interface java.sql.DatabaseMetaData
Parameters:
catalog - ignored
schemaPattern - ignored
typeNamePattern - ignored
types - ignored
Returns:
empty ResultSet
Throws:
java.sql.SQLException

getConnection

public java.sql.Connection getConnection()
Specified by:
getConnection in interface java.sql.DatabaseMetaData

supportsSavepoints

public boolean supportsSavepoints()
It always returns false.

Specified by:
supportsSavepoints in interface java.sql.DatabaseMetaData
Returns:
false

supportsNamedParameters

public boolean supportsNamedParameters()
It always returns true.

Specified by:
supportsNamedParameters in interface java.sql.DatabaseMetaData
Returns:
true

supportsMultipleOpenResults

public boolean supportsMultipleOpenResults()
CallableStatement is not supported yet. It always returns false.

Specified by:
supportsMultipleOpenResults in interface java.sql.DatabaseMetaData
Returns:
false

supportsGetGeneratedKeys

public boolean supportsGetGeneratedKeys()
Supported by sqlite3_last_insert_rowid() function. It always returns true.

Specified by:
supportsGetGeneratedKeys in interface java.sql.DatabaseMetaData
Returns:
true
See Also:
Last Insert Rowid

getSuperTypes

public java.sql.ResultSet getSuperTypes(java.lang.String catalog,
                                        java.lang.String schemaPattern,
                                        java.lang.String typeNamePattern)
                                 throws java.sql.SQLException
Not suppoted yet. It always returns empty ResultSet.

Specified by:
getSuperTypes in interface java.sql.DatabaseMetaData
Parameters:
catalog - ignored
schemaPattern - ignored
typeNamePattern - ignored
Returns:
empty ResultSe
Throws:
java.sql.SQLException

getSuperTables

public java.sql.ResultSet getSuperTables(java.lang.String catalog,
                                         java.lang.String schemaPattern,
                                         java.lang.String tableNamePattern)
                                  throws java.sql.SQLException
Not suppoted yet. It always returns empty ResultSet.

Specified by:
getSuperTables in interface java.sql.DatabaseMetaData
Parameters:
catalog - ignored
schemaPattern - ignored
tableNamePattern - ignored
Returns:
empty ResultSet
Throws:
java.sql.SQLException

getAttributes

public java.sql.ResultSet getAttributes(java.lang.String catalog,
                                        java.lang.String schemaPattern,
                                        java.lang.String typeNamePattern,
                                        java.lang.String attributeNamePattern)
                                 throws java.sql.SQLException
Not suppoted yet. It always returns empty ResultSet.

Specified by:
getAttributes in interface java.sql.DatabaseMetaData
Parameters:
catalog - ignored
schemaPattern - ignored
typeNamePattern - ignored
attributeNamePattern - ignored
Returns:
empty ResultSet
Throws:
java.sql.SQLException

supportsResultSetHoldability

public boolean supportsResultSetHoldability(int holdability)
Supported type is ResultSet.CLOSE_CURSORS_AT_COMMIT only.

Specified by:
supportsResultSetHoldability in interface java.sql.DatabaseMetaData
Parameters:
holdability -
Returns:
true if holdability is java.sql.ResultSet.CLOSE_CURSORS_AT_COMMIT.

getResultSetHoldability

public int getResultSetHoldability()
It always returns ResultSet.CLOSE_CURSORS_AT_COMMIT.

Specified by:
getResultSetHoldability in interface java.sql.DatabaseMetaData
Returns:
java.sql.CLOSE_CURSORS_AT_COMMIT
See Also:
JdbcStatement.getResultSetHoldability()

getDatabaseMajorVersion

public int getDatabaseMajorVersion()
invoke sqlite3_libversion_number() function.

Specified by:
getDatabaseMajorVersion in interface java.sql.DatabaseMetaData
Returns:
Returns the value of sqlite3_libversion_number() / 1000000

getDatabaseMinorVersion

public int getDatabaseMinorVersion()
invoke sqlite3_libversion_number() function.

Specified by:
getDatabaseMinorVersion in interface java.sql.DatabaseMetaData
Returns:
Returns the value of (sqlite3_libversion_number() % 1000000) / 1000

getJDBCMajorVersion

public int getJDBCMajorVersion()
It always returns 3.

Specified by:
getJDBCMajorVersion in interface java.sql.DatabaseMetaData
Returns:
3

getJDBCMinorVersion

public int getJDBCMinorVersion()
It always returns 0.

Specified by:
getJDBCMinorVersion in interface java.sql.DatabaseMetaData
Returns:
0

getSQLStateType

public int getSQLStateType()
It always returns sqlStateSQL99.

Specified by:
getSQLStateType in interface java.sql.DatabaseMetaData
Returns:
java.sql.DatabaseMetaData.sqlStateSQL99

locatorsUpdateCopy

public boolean locatorsUpdateCopy()
It always returns false.

Specified by:
locatorsUpdateCopy in interface java.sql.DatabaseMetaData
Returns:
false

supportsStatementPooling

public boolean supportsStatementPooling()
It always returns false.

Specified by:
supportsStatementPooling in interface java.sql.DatabaseMetaData
Returns:
false

getDatabaseList

public java.util.List<DatabaseList> getDatabaseList()
                                             throws java.sql.SQLException
execute 'PRAGMA database_list' query.

Returns:
list of DatabaseList
Throws:
java.sql.SQLException
See Also:
PRAGMA database_list;

getTableInfo

public java.util.List<TableInfo> getTableInfo(java.lang.String tableName)
                                       throws java.sql.SQLException
execute 'PRAGMA table_info(table-name)' query.

Parameters:
tableName -
Returns:
list of TableInfo
Throws:
java.sql.SQLException
See Also:
PRAGMA table_info(table-name);

getIndexList

public java.util.List<IndexList> getIndexList(java.lang.String tableName)
                                       throws java.sql.SQLException
execute 'PRAGMA index_list(table-name)' query.

Parameters:
tableName -
Returns:
list of IndexList
Throws:
java.sql.SQLException
See Also:
PRAGMA index_list(table-name);

getIndexInfo

public java.util.List<IndexInfo> getIndexInfo(java.lang.String indexName)
                                       throws java.sql.SQLException
execute 'PRAGMA index_info(index-name)' query.

Parameters:
indexName -
Returns:
list of IndexInfo
Throws:
java.sql.SQLException
See Also:
PRAGMA index_info(index-name);

getForeignKeyList

public java.util.List<ForeignKeyList> getForeignKeyList(java.lang.String tableName)
                                                 throws java.sql.SQLException
execute 'PRAGMA foreign_key_list(table-name)' query.

Parameters:
tableName -
Returns:
list of ForeignKeyList
Throws:
java.sql.SQLException
See Also:
PRAGMA foreign_key_list(table-name);

getColumnType

public static int getColumnType(int columnType)

getColumnClassName

public static java.lang.String getColumnClassName(int columnType)

getPrecision

public static int getPrecision(int columnType)

getScale

public static int getScale(int columnType)

getColumnDisplaySize

public static int getColumnDisplaySize(int columnType)

isSigned

public static boolean isSigned(int columnType)

getRadix

public static int getRadix(int columnType)