Skip to Main Content
JDBC Pocket Reference
book

JDBC Pocket Reference

by Donald Bales
January 2003
Intermediate to advanced content levelIntermediate to advanced
176 pages
5h 3m
English
O'Reilly Media, Inc.
Content preview from JDBC Pocket Reference
DatabaseMetaData
68
|
JDBC Pocket Reference
ResultSet getBestRowIdentifier(String catalog, String schema,
String table, int scope, boolean nullable)
Returns a result set that defines which columns best uniquely
identify a row. The result set is defined as follows:
SCOPE
A short value that describes the actual scope of the result.
It is one of the following constants:
bestRowTemporary
bestRowTransaction
bestRowSession
COLUMN_NAME
The column name as a String
DATA_TYPE
A short from java.sql.Types
TYPE_NAME
The database-dependent name, or user-defined type
(UDT) name, as a
String value
COLUMN_SIZE
An int value that describes the precision of the data type
BUFFER_LENGTH
An int value that is not used in this method
DECIMAL_DIGITS
A short value that describes the scale of the data type
PSEUDO_COLUMN
A short value that indicates whether or not the column is
a pseudo column. It is one of the following constants:
bestRowUnknown
bestRowNotPseudo
bestRowPseudo
ResultSet getCatalogs( )
Returns a result set with one column, a String value that lists
the catalog names.
String getCatalogSeparator( )
Returns the separator used between catalog and table name.
String getCatalogTerm( )
Returns the database’s term for “catalog.”
DatabaseMetaData
The JDBC API
|
69
ResultSet getColumnPrivileges(String catalog, String schema,
String table, String ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Pro Couchbase Server, Second Edition

Pro Couchbase Server, Second Edition

David Ostrovsky, Mohammed Haji, Yaniv Rodenski
Pro Couchbase Server

Pro Couchbase Server

David Ostrovsky, Yaniv Rodenski

Publisher Resources

ISBN: 9780596528713