Re: How to know columns names in Derby database table
- From: Roedy Green <see_website@xxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 23 Sep 2007 10:41:47 GMT
On Sun, 23 Sep 2007 09:54:50 +0200, "Luis Angel Fdez. Fdez."
<laffdez@xxxxxxxxx> wrote, quoted or indirectly quoted someone who
said :
myRs = con.getMetaData().getColumns(null, null, "bornes", "%");
This is a quite tricky bit of code. I would try dumping some other
MetaData info out to make sure all is working.
The way I read the docs, the fourth parm must be the column name. That
is not logical given the name of the method. Also presume all is
case-sensitive.
ResultSet getColumns(String catalog,
String schemaPattern,
String tableNamePattern,
String columnNamePattern)
throws SQLException
Retrieves 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_CAT,TABLE_SCHEM, TABLE_NAME, and ORDINAL_POSITION.
Each column description has the following columns:
TABLE_CAT String => table catalog (may be null)
TABLE_SCHEM String => table schema (may be null)
TABLE_NAME String => table name
COLUMN_NAME String => column name
DATA_TYPE int => SQL type from java.sql.Types
TYPE_NAME String => Data source dependent type name, for a UDT the
type name is fully qualified
COLUMN_SIZE int => column size.
BUFFER_LENGTH is not used.
DECIMAL_DIGITS int => the number of fractional digits. Null is
returned for data types where DECIMAL_DIGITS is not applicable.
NUM_PREC_RADIX int => Radix (typically either 10 or 2)
NULLABLE int => is NULL allowed.
columnNoNulls - might not allow NULL values
columnNullable - definitely allows NULL values
columnNullableUnknown - nullability unknown
REMARKS String => comment describing column (may be null)
COLUMN_DEF String => default value for the column, which should be
interpreted as a string when the value is enclosed in single quotes
(may be null)
SQL_DATA_TYPE int => unused
SQL_DATETIME_SUB int => unused
CHAR_OCTET_LENGTH int => for char types the maximum number of bytes in
the column
ORDINAL_POSITION int => index of column in table (starting at 1)
IS_NULLABLE String => ISO rules are used to determine the nullability
for a column.
YES --- if the parameter can include NULLs
NO --- if the parameter cannot include NULLs
empty string --- if the nullability for the parameter is unknown
SCOPE_CATLOG String => catalog of table that is the scope of a
reference attribute (null if DATA_TYPE isn't REF)
SCOPE_SCHEMA String => schema of table that is the scope of a
reference attribute (null if the DATA_TYPE isn't REF)
SCOPE_TABLE String => table name that this the scope of a reference
attribure (null if the DATA_TYPE isn't REF)
SOURCE_DATA_TYPE short => source type of a distinct type or
user-generated Ref type, SQL type from java.sql.Types (null if
DATA_TYPE isn't DISTINCT or user-generated REF)
IS_AUTOINCREMENT String => Indicates whether this column is auto
incremented
YES --- if the column is auto incremented
NO --- if the column is not auto incremented
empty string --- if it cannot be determined whether the column is auto
incremented parameter is unknown
The COLUMN_SIZE column the specified column size for the given column.
For numeric data, this is the maximum precision. For character data,
this is the length in characters. For datetime datatypes, this is the
length in characters of the String representation (assuming the
maximum allowed precision of the fractional seconds component). For
binary data, this is the length in bytes. For the ROWID datatype, this
is the length in bytes. Null is returned for data types where the
column size is not applicable.
Parameters:
catalog - a catalog name; must match the catalog name as it is stored
in the database; "" retrieves those without a catalog; null means that
the catalog name should not be used to narrow the search
schemaPattern - a schema name pattern; must match the schema name as
it is stored in the database; "" retrieves those without a schema;
null means that the schema name should not be used to narrow the
search
tableNamePattern - a table name pattern; must match the table name as
it is stored in the database
columnNamePattern - a column name pattern; must match the column name
as it is stored in the database
Returns:
ResultSet - each row is a column description
Throws:
SQLException - if a database access error occurs
See Also:
getSearchStringEscape()
--
Roedy Green Canadian Mind Products
The Java Glossary
http://mindprod.com
.
- References:
- How to know columns names in Derby database table
- From: Luis Angel Fdez. Fdez.
- How to know columns names in Derby database table
- Prev by Date: Re: How to know columns names in Derby database table
- Next by Date: [SOLVED] Re: How to know columns names in Derby database table
- Previous by thread: Re: How to know columns names in Derby database table
- Next by thread: [SOLVED] Re: How to know columns names in Derby database table
- Index(es):
Relevant Pages
|
|
