Interface Ref

All Known Implementing Classes:
SerialRef
public interfaceRef
The mapping in the Java programming language of an SQLREF value, which is a reference to an SQL structured type value in the database.

SQLREF values are stored in a table that contains instances of a referenceable SQL structured type, and eachREF value is a unique identifier for one instance in that table. An SQLREF value may be used in place of the SQL structured type it references, either as a column value in a table or an attribute value in a structured type.

Because an SQLREF value is a logical pointer to an SQL structured type, aRef object is by default also a logical pointer. Thus, retrieving an SQLREF value as aRef object does not materialize the attributes of the structured type on the client.

ARef object can be stored in the database using thePreparedStatement.setRef method.

All methods on theRef interface must be fully implemented if the JDBC driver supports the data type.

Since:
1.2
See Also:

  • Method Summary

    Modifier and Type
    Method
    Description
    Retrieves the fully-qualified SQL name of the SQL structured type that thisRef object references.
    Retrieves the SQL structured type instance referenced by thisRef object.
    Retrieves the referenced object and maps it to a Java type using the given type map.
    void
    Sets the structured type value that thisRef object references to the given instance ofObject.

  • Method Details

    • getBaseTypeName

      String getBaseTypeName() throwsSQLException
      Retrieves the fully-qualified SQL name of the SQL structured type that thisRef object references.
      Returns:
      the fully-qualified SQL name of the referenced SQL structured type
      Throws:
      SQLException - if a database access error occurs
      SQLFeatureNotSupportedException - if the JDBC driver does not support this method
      Since:
      1.2

    • getObject

      Object getObject(Map<String,Class<?>> map) throwsSQLException
      Retrieves the referenced object and maps it to a Java type using the given type map.
      Parameters:
      map - ajava.util.Map object that contains the mapping to use (the fully-qualified name of the SQL structured type being referenced and the class object forSQLData implementation to which the SQL structured type will be mapped)
      Returns:
      a JavaObject that is the custom mapping for the SQL structured type to which thisRef object refers
      Throws:
      SQLException - if a database access error occurs
      SQLFeatureNotSupportedException - if the JDBC driver does not support this method
      Since:
      1.4
      See Also:

    • getObject

      Object getObject() throwsSQLException
      Retrieves the SQL structured type instance referenced by thisRef object. If the connection's type map has an entry for the structured type, the instance will be custom mapped to the Java class indicated in the type map. Otherwise, the structured type instance will be mapped to aStruct object.
      Returns:
      a JavaObject that is the mapping for the SQL structured type to which thisRef object refers
      Throws:
      SQLException - if a database access error occurs
      SQLFeatureNotSupportedException - if the JDBC driver does not support this method
      Since:
      1.4
      See Also:

    • setObject

      void setObject(Object value) throwsSQLException
      Sets the structured type value that thisRef object references to the given instance ofObject. The driver converts this to an SQL structured type when it sends it to the database.
      Parameters:
      value - anObject representing the SQL structured type instance that thisRef object will reference
      Throws:
      SQLException - if a database access error occurs
      SQLFeatureNotSupportedException - if the JDBC driver does not support this method
      Since:
      1.4
      See Also: