org.sqlite.jdbc
Class JdbcResultSetMetaData

java.lang.Object
  extended by org.sqlite.jdbc.JdbcResultSetMetaData
All Implemented Interfaces:
java.sql.ResultSetMetaData

public class JdbcResultSetMetaData
extends java.lang.Object
implements java.sql.ResultSetMetaData


Field Summary
 
Fields inherited from interface java.sql.ResultSetMetaData
columnNoNulls, columnNullable, columnNullableUnknown
 
Constructor Summary
JdbcResultSetMetaData(Statement stmt)
           
 
Method Summary
 java.lang.String getCatalogName(int column)
          It always returns empty string.
 java.lang.String getColumnClassName(int column)
          invoke getSQLiteColumnType(int) and org.sqlite.jdbc.JdbcDatabaseMetaData#getColumnClassName(int) method.
 int getColumnCount()
          invoke org.sqlite.Statement#getColumnCount() method.
 int getColumnDisplaySize(int column)
          invoke getSQLiteColumnType(int) and org.sqlite.jdbc.JdbcDatabaseMetaData#getColumnDisplaySize(int) method.
 java.lang.String getColumnLabel(int column)
          invoke org.sqlite.Statement#getColumnLabel(int) method.
 ColumnMetaData getColumnMetaData(int column)
          invoke org.sqlite.Database#getColumnMetaData(String, String, String) method.
 java.lang.String getColumnName(int column)
          invoke org.sqlite.Statement#getColumnName(int) method.
 int getColumnType(int column)
          invoke getSQLiteColumnType(int) and org.sqlite.jdbc.JdbcDatabaseMetaData#getColumnType(int) method.
 java.lang.String getColumnTypeName(int column)
          invoke org.sqlite.Statement#getColumnTypeName(int) method.
 java.lang.String getDatabaseName(int column)
          Get the designated column's table's database name.
 int getPrecision(int column)
          invoke getSQLiteColumnType(int) and org.sqlite.jdbc.JdbcDatabaseMetaData#getPrecision(int) method.
 int getScale(int column)
          invoke getSQLiteColumnType(int) and org.sqlite.jdbc.JdbcDatabaseMetaData#getScale(int) method.
 java.lang.String getSchemaName(int column)
          invoke getDatabaseName(int) method.
 int getSQLiteColumnType(int column)
          invoke org.sqlite.Statement#getColumnType(int) and org.sqlite.Statement#getColumnTypeName(int) method.
 java.lang.String getTableName(int column)
          invoke org.sqlite.Statement#getColumnTableName(int) method.
 boolean isAutoIncrement(int column)
          Returns the value of org.sqlite.schema.ColumnMetaData.isAutoIncrement.
 boolean isCaseSensitive(int column)
          Returns true when the value of org.sqlite.schema.ColumnMetaData.collationSequenceName is 'NOCASE'.
 boolean isCurrency(int column)
          It always returns false.
 boolean isDefinitelyWritable(int column)
          It always returns false.
 int isNullable(int column)
          Returns columnNoNulls if org.sqlite.schema.ColumnMetaData.isNotNull is true.
 boolean isReadOnly(int column)
          It always returns true.
 boolean isSearchable(int column)
          It always returns true.
 boolean isSigned(int column)
          invoke getSQLiteColumnType(int) and org.sqlite.jdbc.JdbcDatabaseMetaData#isSigned(int) method.
 boolean isWritable(int column)
          It always returns false.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

JdbcResultSetMetaData

public JdbcResultSetMetaData(Statement stmt)
Method Detail

getColumnCount

public int getColumnCount()
                   throws java.sql.SQLException
invoke org.sqlite.Statement#getColumnCount() method.

Specified by:
getColumnCount in interface java.sql.ResultSetMetaData
Returns:
Throws:
java.sql.SQLException
See Also:
Statement.getColumnCount()

isAutoIncrement

public boolean isAutoIncrement(int column)
                        throws java.sql.SQLException
Returns the value of org.sqlite.schema.ColumnMetaData.isAutoIncrement.

Specified by:
isAutoIncrement in interface java.sql.ResultSetMetaData
Parameters:
column - the first column is 1, the second is 2, ...
Returns:
Throws:
java.sql.SQLException
See Also:
getColumnMetaData(int), ColumnMetaData.isAutoIncrement

isCaseSensitive

public boolean isCaseSensitive(int column)
                        throws java.sql.SQLException
Returns true when the value of org.sqlite.schema.ColumnMetaData.collationSequenceName is 'NOCASE'.

Specified by:
isCaseSensitive in interface java.sql.ResultSetMetaData
Parameters:
column - the first column is 1, the second is 2, ...
Returns:
True when Collation Sequences is 'NOCASE'. When it is not 'NOCASE', false is returned.
Throws:
java.sql.SQLException
See Also:
getColumnMetaData(int), ColumnMetaData.collationSequenceName

isSearchable

public boolean isSearchable(int column)
                     throws java.sql.SQLException
It always returns true.

Specified by:
isSearchable in interface java.sql.ResultSetMetaData
Parameters:
column - the first column is 1, the second is 2, ...
Returns:
true
Throws:
java.sql.SQLException
See Also:
JdbcDatabaseMetaData.getTypeInfo()

isCurrency

public boolean isCurrency(int column)
                   throws java.sql.SQLException
It always returns false.

Specified by:
isCurrency in interface java.sql.ResultSetMetaData
Parameters:
column - the first column is 1, the second is 2, ...
Returns:
false
Throws:
java.sql.SQLException

isNullable

public int isNullable(int column)
               throws java.sql.SQLException
Returns columnNoNulls if org.sqlite.schema.ColumnMetaData.isNotNull is true.

Specified by:
isNullable in interface java.sql.ResultSetMetaData
Parameters:
column - the first column is 1, the second is 2, ...
Returns:
columnNoNulls if org.sqlite.schema.ColumnMetaData.isNotNull is true.
Throws:
java.sql.SQLException
See Also:
getColumnMetaData(int), ColumnMetaData.isNotNull

isSigned

public boolean isSigned(int column)
                 throws java.sql.SQLException
invoke getSQLiteColumnType(int) and org.sqlite.jdbc.JdbcDatabaseMetaData#isSigned(int) method.

Specified by:
isSigned in interface java.sql.ResultSetMetaData
Parameters:
column - the first column is 1, the second is 2, ...
Returns:
Throws:
java.sql.SQLException
See Also:
getSQLiteColumnType(int), JdbcDatabaseMetaData.isSigned(int), JdbcDatabaseMetaData.getTypeInfo()

getColumnDisplaySize

public int getColumnDisplaySize(int column)
                         throws java.sql.SQLException
invoke getSQLiteColumnType(int) and org.sqlite.jdbc.JdbcDatabaseMetaData#getColumnDisplaySize(int) method.

Specified by:
getColumnDisplaySize in interface java.sql.ResultSetMetaData
Parameters:
column - the first column is 1, the second is 2, ...
Returns:
Throws:
java.sql.SQLException
See Also:
getSQLiteColumnType(int), JdbcDatabaseMetaData.getColumnDisplaySize(int), org.hsqldb.Types#getMaxDisplaySize(int)

getColumnLabel

public java.lang.String getColumnLabel(int column)
                                throws java.sql.SQLException
invoke org.sqlite.Statement#getColumnLabel(int) method.

Specified by:
getColumnLabel in interface java.sql.ResultSetMetaData
Parameters:
column - the first column is 1, the second is 2, ...
Returns:
Throws:
java.sql.SQLException
See Also:
Statement.getColumnLabel(int)

getColumnName

public java.lang.String getColumnName(int column)
                               throws java.sql.SQLException
invoke org.sqlite.Statement#getColumnName(int) method.

Specified by:
getColumnName in interface java.sql.ResultSetMetaData
Parameters:
column - the first column is 1, the second is 2, ...
Returns:
Throws:
java.sql.SQLException
See Also:
Statement.getColumnName(int)

getSchemaName

public java.lang.String getSchemaName(int column)
                               throws java.sql.SQLException
invoke getDatabaseName(int) method.

Specified by:
getSchemaName in interface java.sql.ResultSetMetaData
Parameters:
column - the first column is 1, the second is 2, ...
Returns:
database name
Throws:
java.sql.SQLException
See Also:
getDatabaseName(int)

getPrecision

public int getPrecision(int column)
                 throws java.sql.SQLException
invoke getSQLiteColumnType(int) and org.sqlite.jdbc.JdbcDatabaseMetaData#getPrecision(int) method.

Specified by:
getPrecision in interface java.sql.ResultSetMetaData
Parameters:
column - the first column is 1, the second is 2, ...
Returns:
Throws:
java.sql.SQLException
See Also:
getSQLiteColumnType(int), JdbcDatabaseMetaData.getPrecision(int), JdbcDatabaseMetaData.getTypeInfo()

getScale

public int getScale(int column)
             throws java.sql.SQLException
invoke getSQLiteColumnType(int) and org.sqlite.jdbc.JdbcDatabaseMetaData#getScale(int) method.

Specified by:
getScale in interface java.sql.ResultSetMetaData
Parameters:
column - the first column is 1, the second is 2, ...
Returns:
Throws:
java.sql.SQLException
See Also:
getSQLiteColumnType(int), JdbcDatabaseMetaData.getScale(int)

getTableName

public java.lang.String getTableName(int column)
                              throws java.sql.SQLException
invoke org.sqlite.Statement#getColumnTableName(int) method.

Specified by:
getTableName in interface java.sql.ResultSetMetaData
Parameters:
column - the first column is 1, the second is 2, ...
Returns:
Throws:
java.sql.SQLException
See Also:
Statement.getColumnTableName(int)

getCatalogName

public java.lang.String getCatalogName(int column)
                                throws java.sql.SQLException
It always returns empty string.

Specified by:
getCatalogName in interface java.sql.ResultSetMetaData
Parameters:
column - the first column is 1, the second is 2, ...
Returns:
empty string
Throws:
java.sql.SQLException

getColumnType

public int getColumnType(int column)
                  throws java.sql.SQLException
invoke getSQLiteColumnType(int) and org.sqlite.jdbc.JdbcDatabaseMetaData#getColumnType(int) method.

Specified by:
getColumnType in interface java.sql.ResultSetMetaData
Parameters:
column - the first column is 1, the second is 2, ...
Returns:
Throws:
java.sql.SQLException
See Also:
getSQLiteColumnType(int), JdbcDatabaseMetaData.getColumnType(int)

getColumnTypeName

public java.lang.String getColumnTypeName(int column)
                                   throws java.sql.SQLException
invoke org.sqlite.Statement#getColumnTypeName(int) method.

Specified by:
getColumnTypeName in interface java.sql.ResultSetMetaData
Parameters:
column - the first column is 1, the second is 2, ...
Returns:
Throws:
java.sql.SQLException
See Also:
Statement.getColumnTypeName(int)

isReadOnly

public boolean isReadOnly(int column)
                   throws java.sql.SQLException
It always returns true.

Specified by:
isReadOnly in interface java.sql.ResultSetMetaData
Parameters:
column - the first column is 1, the second is 2, ...
Returns:
true
Throws:
java.sql.SQLException

isWritable

public boolean isWritable(int column)
                   throws java.sql.SQLException
It always returns false.

Specified by:
isWritable in interface java.sql.ResultSetMetaData
Parameters:
column - the first column is 1, the second is 2, ...
Returns:
false
Throws:
java.sql.SQLException

isDefinitelyWritable

public boolean isDefinitelyWritable(int column)
                             throws java.sql.SQLException
It always returns false.

Specified by:
isDefinitelyWritable in interface java.sql.ResultSetMetaData
Parameters:
column - the first column is 1, the second is 2, ...
Returns:
false
Throws:
java.sql.SQLException

getColumnClassName

public java.lang.String getColumnClassName(int column)
                                    throws java.sql.SQLException
invoke getSQLiteColumnType(int) and org.sqlite.jdbc.JdbcDatabaseMetaData#getColumnClassName(int) method.

Specified by:
getColumnClassName in interface java.sql.ResultSetMetaData
Parameters:
column - the first column is 1, the second is 2, ...
Returns:
Throws:
java.sql.SQLException
See Also:
getSQLiteColumnType(int), JdbcDatabaseMetaData.getColumnClassName(int)

getSQLiteColumnType

public int getSQLiteColumnType(int column)
                        throws java.sql.SQLException
invoke org.sqlite.Statement#getColumnType(int) and org.sqlite.Statement#getColumnTypeName(int) method.

Parameters:
column - the first column is 1, the second is 2, ...
Returns:
Throws:
java.sql.SQLException
See Also:
Statement.getColumnType(int), Statement.getColumnTypeName(int), Datatypes In SQLite Version 3 - 2. Column Affinity

getDatabaseName

public java.lang.String getDatabaseName(int column)
                                 throws java.sql.SQLException
Get the designated column's table's database name.

Parameters:
column - the first column is 1, the second is 2, ...
Returns:
Throws:
java.sql.SQLException
See Also:
Statement.getColumnDatabaseName(int)

getColumnMetaData

public ColumnMetaData getColumnMetaData(int column)
                                 throws java.sql.SQLException
invoke org.sqlite.Database#getColumnMetaData(String, String, String) method.

Parameters:
column - the first column is 1, the second is 2, ...
Returns:
Throws:
java.sql.SQLException
See Also:
Database.getColumnMetaData(String, String, String)