The representation (mapping) in the Java programming language of an SQL ROWID value. An SQL ROWID is a built-in type, a value of which can be thought of as an address for its identified row in a database table. Whether that address is logical or, in any respects, physical is determined by its originating data source.
Methods in the interfaces ResultSet
, CallableStatement
, and PreparedStatement
, such as getRowId
and setRowId
allow a programmer to access a SQL ROWID
value. The RowId
interface provides a method for representing the value of the ROWID
as a byte array or as a String
.
The method getRowIdLifetime
in the interface DatabaseMetaData
, can be used to determine if a RowId
object remains valid for the duration of the transaction in which the RowId
was created, the duration of the session in which the RowId
was created, or, effectively, for as long as its identified row is not deleted. In addition to specifying the duration of its valid lifetime outside its originating data source, getRowIdLifetime
specifies the duration of a ROWID
value's valid lifetime within its originating data source. In this, it differs from a large object, because there is no limit on the valid lifetime of a large object within its originating data source.
All methods on the RowId
interface must be fully implemented if the JDBC driver supports the data type.