-
- All Known Implementing Classes:
- SerialRef
public interface Ref
The mapping in the Java programming language of an SQLREF
value, which is a reference to an SQL structured type value in the database.SQL
REF
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 SQL
REF
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.A
Ref
object can be stored in the database using thePreparedStatement.setRef
method.All methods on the
Ref
interface must be fully implemented if the JDBC driver supports the data type.- Since:
- 1.2
- See Also:
Struct
-
-
Method Summary
Methods Modifier and Type Method and Description String
getBaseTypeName()
Retrieves the fully-qualified SQL name of the SQL structured type that thisRef
object references.Object
getObject()
Retrieves the SQL structured type instance referenced by thisRef
object.Object
getObject(Map<String,Class<?>> map)
Retrieves the referenced object and maps it to a Java type using the given type map.void
setObject(Object value)
Sets the structured type value that thisRef
object references to the given instance ofObject
.
-
-
-
Method Detail
-
getBaseTypeName
String getBaseTypeName() throws SQLException
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 occursSQLFeatureNotSupportedException
- if the JDBC driver does not support this method- Since:
- 1.2
-
getObject
Object getObject(Map<String,Class<?>> map) throws SQLException
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 Java
Object
that is the custom mapping for the SQL structured type to which thisRef
object refers - Throws:
SQLException
- if a database access error occursSQLFeatureNotSupportedException
- if the JDBC driver does not support this method- Since:
- 1.4
- See Also:
setObject(java.lang.Object)
-
getObject
Object getObject() throws SQLException
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 Java
Object
that is the mapping for the SQL structured type to which thisRef
object refers - Throws:
SQLException
- if a database access error occursSQLFeatureNotSupportedException
- if the JDBC driver does not support this method- Since:
- 1.4
- See Also:
setObject(java.lang.Object)
-
setObject
void setObject(Object value) throws SQLException
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 occursSQLFeatureNotSupportedException
- if the JDBC driver does not support this method- Since:
- 1.4
- See Also:
getObject()
,getObject(Map)
,PreparedStatement.setObject(int, Object)
,CallableStatement.setObject(String, Object)
-
-
Document created the 11/06/2005, last modified the 04/03/2020
Source of the printed document:https://www.gaudry.be/en/java-api-rf-java/sql/ref.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.