public interface SQLData
SQLDatainterface will be entered in the appropriate
Connectionobject's type map along with the SQL name of the UDT for which it is a custom mapping.
will define a field for each attribute of an SQL structured type or a
single field for an SQL
DISTINCT type. When the UDT is
retrieved from a data source with the
method, it will be mapped as an instance of this class. A programmer
can operate on this class instance just as on any other object in the
Java programming language and then store any changes made to it by
which will map it back to the SQL type.
It is expected that the implementation of the class for a custom
mapping will be done by a tool. In a typical implementation, the
programmer would simply supply the name of the SQL UDT, the name of
the class to which it is being mapped, and the names of the fields to
which each of the attributes of the UDT is to be mapped. The tool will use
this information to implement the
SQLData.writeSQL methods. The
calls the appropriate
SQLInput methods to read
each attribute from an
SQLInput object, and the
writeSQL method calls
to write each attribute back to the data source via an
An application programmer will not normally call
directly, and the
are called internally by
SQLData methods, not by application code.
|Modifier and Type||Method||Description|
Returns the fully-qualified name of the SQL user-defined type that this object represents.
Populates this object with data read from the database.
Writes this object to the given SQL data stream, converting it back to its SQL value in the data source.
String getSQLTypeName() throws SQLException
void readSQL(SQLInput stream, String typeName) throws SQLException
readSQLthen assigns the data to appropriate fields or elements (of this or other objects). Specifically, it must call the appropriate reader method (
SQLInput.readBigDecimal, and so on) method(s) to do the following: for a distinct type, read its single data element; for a structured type, read a value for each attribute of the SQL type.
SQLInputreader method on the stream.
SQLInputobject from which to read the data for the value that is being custom mapped
typeName- the SQL type name of the value on the data stream
SQLException- if there is a database access error
SQLFeatureNotSupportedException- if the JDBC driver does not support this method
void writeSQL(SQLOutput stream) throws SQLException
SQLOutputwriter method(s) (
writeString, and so on) to do the following: for a Distinct Type, write its single data element; for a Structured Type, write a value for each attribute of the SQL type.
Submit a bug or feature
For further API reference and developer documentation, see Java SE Documentation. That documentation contains more detailed, developer-targeted descriptions, with conceptual overviews, definitions of terms, workarounds, and working code examples.
Copyright © 1993, 2017, Oracle and/or its affiliates. 500 Oracle Parkway
Redwood Shores, CA 94065 USA. All rights reserved.