org.hsqldb.jdbc.JDBCRowId Maven / Gradle / Ivy
Show all versions of hsqldb Show documentation
/* Copyright (c) 2001-2024, The HSQL Development Group
* All rights reserved.
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions are met:
*
* Redistributions of source code must retain the above copyright notice, this
* list of conditions and the following disclaimer.
*
* Redistributions in binary form must reproduce the above copyright notice,
* this list of conditions and the following disclaimer in the documentation
* and/or other materials provided with the distribution.
*
* Neither the name of the HSQL Development Group nor the names of its
* contributors may be used to endorse or promote products derived from this
* software without specific prior written permission.
*
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
* IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
* ARE DISCLAIMED. IN NO EVENT SHALL HSQL DEVELOPMENT GROUP, HSQLDB.ORG,
* OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
* EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
* PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
* LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
* ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
* SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/
package org.hsqldb.jdbc;
import org.hsqldb.error.ErrorCode;
import org.hsqldb.lib.StringConverter;
import java.io.IOException;
import java.sql.RowId;
import java.sql.SQLException;
import java.util.Arrays;
/**
* 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 {@code ResultSet}, {@code CallableStatement},
* and {@code PreparedStatement}, such as {@code getRowId} and {@code setRowId}
* allow a programmer to access a SQL {@code ROWID} value. The {@code RowId}
* interface provides a method
* for representing the value of the {@code ROWID} as a byte array or as a
* {@code String}.
*
* The method {@code getRowIdLifetime} in the interface {@code DatabaseMetaData},
* can be used
* to determine if a {@code RowId} object remains valid for the duration of the transaction in
* which the {@code RowId} was created, the duration of the session in which
* the {@code 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, {@code getRowIdLifetime} specifies the duration of a {@code 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 {@code RowId} interface must be fully implemented if the
* JDBC driver supports the data type.
*
* @see java.sql.DatabaseMetaData
* @since JDK 1.6, HSQLDB 2.0
* @author Campbell Burnet (campbell-burnet@users dot sourceforge.net)
*/
public final class JDBCRowId implements RowId {
private int hash;
// ------------------------- Internal Implementation -----------------------
private final byte[] id;
/**
* Constructs a new JDBCRowId instance wrapping the given octet sequence.
*
* This constructor may be used internally to retrieve result set values as
* RowId objects, yet it also may need to be public to allow access from
* other packages. As such (in the interest of efficiency) this object
* maintains a reference to the given octet sequence rather than making a
* copy; special care should be taken by external clients never to use this
* constructor with a byte array object that may later be modified
* externally.
*
* @param id the octet sequence representing the Rowid value
* @throws SQLException if the argument is null
*/
public JDBCRowId(final byte[] id) throws SQLException {
if (id == null) {
throw JDBCUtil.nullArgument("id");
}
this.id = id;
}
/**
* Constructs a new JDBCRowId instance whose internal octet sequence
* is a copy of the octet sequence of the given RowId object.
*
* @param id the octet sequence representing the Rowid value
* @throws SQLException if the argument is null
*/
public JDBCRowId(RowId id) throws SQLException {
this(id.getBytes());
}
/**
* Constructs a new JDBCRowId instance whose internal octet sequence
* is that represented by the given hexadecimal character sequence.
* @param hex the hexadecimal character sequence from which to derive
* the internal octet sequence
* @throws java.sql.SQLException if the argument is null or is not a valid
* hexadecimal character sequence
*/
public JDBCRowId(final String hex) throws SQLException {
if (hex == null) {
throw JDBCUtil.nullArgument("hex");
}
try {
this.id = StringConverter.hexStringToByteArray(hex);
} catch (IOException e) {
throw JDBCUtil.sqlException(
ErrorCode.JDBC_INVALID_ARGUMENT,
"hex: " + e);
// .illegalHexadecimalCharacterSequenceArgumentException("hex", e);
}
}
/**
* Compares this {@code RowId} to the specified object. The result is
* {@code true} if and only if the argument is not null and is a RowId
* object that represents the same ROWID as this object.
*
* It is important
* to consider both the origin and the valid lifetime of a {@code RowId}
* when comparing it to another {@code RowId}. If both are valid, and
* both are from the same table on the same data source, then if they are equal
* they identify
* the same row; if one or more is no longer guaranteed to be valid, or if
* they originate from different data sources, or different tables on the
* same data source, they may be equal but still
* not identify the same row.
*
* @param obj the {@code Object} to compare this {@code RowId} object
* against.
* @return true if the {@code RowId}s are equal; false otherwise
* @since JDK 1.6, HSQLDB 2.0
*/
public boolean equals(Object obj) {
return (obj instanceof JDBCRowId)
&& Arrays.equals(this.id, ((JDBCRowId) obj).id);
}
/**
* Returns an array of bytes representing the value of the SQL {@code ROWID}
* designated by this {@code java.sql.RowId} object.
*
* @return an array of bytes, whose length is determined by the driver supplying
* the connection, representing the value of the ROWID designated by this
* java.sql.RowId object.
*/
public byte[] getBytes() {
return id.clone();
}
/**
* Returns a String representing the value of the SQL ROWID designated by this
* {@code java.sql.RowId} object.
*
* Like {@code java.sql.Date.toString()}
* returns the contents of its DATE as the {@code String} "2004-03-17"
* rather than as DATE literal in SQL (which would have been the {@code String}
* DATE "2004-03-17"), toString()
* returns the contents of its ROWID in a form specific to the driver supplying
* the connection, and possibly not as a {@code ROWID} literal.
*
* @return a String whose format is determined by the driver supplying the
* connection, representing the value of the {@code ROWID} designated
* by this {@code java.sql.RowId} object.
*/
public String toString() {
return StringConverter.byteArrayToHexString(id);
}
/**
* Returns a hash code value of this {@code RowId} object.
*
* @return a hash code for the {@code RowId}
*/
public int hashCode() {
if (hash == 0) {
hash = Arrays.hashCode(id);
}
return hash;
}
/**
* Direct access to id bytes for subclassing.
*
* @return direct reference to id bytes.
*/
Object id() {
return id;
}
}