SQLOutput
interface SQLOutput
| java.sql.SQLOutput |
The output stream for writing the attributes of a user-defined type back to the database. This interface, used only for custom mapping, is used by the driver, and its methods are never directly invoked by a programmer.
When an object of a class implementing the interface SQLData is passed as an argument to an SQL statement, the JDBC driver calls the method SQLData.getSQLType to determine the kind of SQL datum being passed to the database. The driver then creates an instance of SQLOutput and passes it to the method SQLData.writeSQL. The method writeSQL in turn calls the appropriate SQLOutput writer methods writeBoolean, writeCharacterStream, and so on) to write data from the SQLData object to the SQLOutput output stream as the representation of an SQL user-defined type.
Summary
| Public methods | |
|---|---|
| abstract Unit |
writeArray(x: Array!)Writes an SQL |
| abstract Unit |
Writes the next attribute to the stream as a stream of ASCII characters. |
| abstract Unit |
Writes the next attribute to the stream as a java. |
| abstract Unit |
Writes the next attribute to the stream as a stream of uninterpreted bytes. |
| abstract Unit |
Writes an SQL |
| abstract Unit |
writeBoolean(x: Boolean)Writes the next attribute to the stream as a Java boolean. |
| abstract Unit |
Writes the next attribute to the stream as a Java byte. |
| abstract Unit |
writeBytes(x: ByteArray!)Writes the next attribute to the stream as an array of bytes. |
| abstract Unit |
Writes the next attribute to the stream as a stream of Unicode characters. |
| abstract Unit |
Writes an SQL |
| abstract Unit |
Writes the next attribute to the stream as a java. |
| abstract Unit |
writeDouble(x: Double)Writes the next attribute to the stream as a Java double. |
| abstract Unit |
writeFloat(x: Float)Writes the next attribute to the stream as a Java float. |
| abstract Unit |
Writes the next attribute to the stream as a Java int. |
| abstract Unit |
Writes the next attribute to the stream as a Java long. |
| abstract Unit |
writeNClob(x: NClob!)Writes an SQL |
| abstract Unit |
writeNString(x: String!)Writes the next attribute to the stream as a |
| abstract Unit |
writeObject(x: SQLData!)Writes to the stream the data contained in the given |
| abstract Unit |
Writes an SQL |
| abstract Unit |
writeRowId(x: RowId!)Writes an SQL |
| abstract Unit |
writeSQLXML(x: SQLXML!)Writes an SQL |
| abstract Unit |
writeShort(x: Short)Writes the next attribute to the stream as a Java short. |
| abstract Unit |
writeString(x: String!)Writes the next attribute to the stream as a |
| abstract Unit |
writeStruct(x: Struct!)Writes an SQL structured type value to the stream. |
| abstract Unit |
Writes the next attribute to the stream as a java. |
| abstract Unit |
writeTimestamp(x: Timestamp!)Writes the next attribute to the stream as a java. |
| abstract Unit |
Writes a SQL |
Public methods
writeArray
abstract fun writeArray(x: Array!): Unit
Writes an SQL ARRAY value to the stream.
| Parameters | |
|---|---|
x |
Array!: an Array object representing data of an SQL ARRAY type |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |
writeAsciiStream
abstract fun writeAsciiStream(x: InputStream!): Unit
Writes the next attribute to the stream as a stream of ASCII characters.
| Parameters | |
|---|---|
x |
InputStream!: the value to pass to the database |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |
writeBigDecimal
abstract fun writeBigDecimal(x: BigDecimal!): Unit
Writes the next attribute to the stream as a java.math.BigDecimal object. Writes the next attribute to the stream as a String in the Java programming language.
| Parameters | |
|---|---|
x |
BigDecimal!: the value to pass to the database |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |
writeBinaryStream
abstract fun writeBinaryStream(x: InputStream!): Unit
Writes the next attribute to the stream as a stream of uninterpreted bytes.
| Parameters | |
|---|---|
x |
InputStream!: the value to pass to the database |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |
writeBlob
abstract fun writeBlob(x: Blob!): Unit
Writes an SQL BLOB value to the stream.
| Parameters | |
|---|---|
x |
Blob!: a Blob object representing data of an SQL BLOB value |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |
writeBoolean
abstract fun writeBoolean(x: Boolean): Unit
Writes the next attribute to the stream as a Java boolean. Writes the next attribute to the stream as a String in the Java programming language.
| Parameters | |
|---|---|
x |
Boolean: the value to pass to the database |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |
writeByte
abstract fun writeByte(x: Byte): Unit
Writes the next attribute to the stream as a Java byte. Writes the next attribute to the stream as a String in the Java programming language.
| Parameters | |
|---|---|
x |
Byte: the value to pass to the database |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |
writeBytes
abstract fun writeBytes(x: ByteArray!): Unit
Writes the next attribute to the stream as an array of bytes. Writes the next attribute to the stream as a String in the Java programming language.
| Parameters | |
|---|---|
x |
ByteArray!: the value to pass to the database |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |
writeCharacterStream
abstract fun writeCharacterStream(x: Reader!): Unit
Writes the next attribute to the stream as a stream of Unicode characters.
| Parameters | |
|---|---|
x |
Reader!: the value to pass to the database |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |
writeClob
abstract fun writeClob(x: Clob!): Unit
Writes an SQL CLOB value to the stream.
| Parameters | |
|---|---|
x |
Clob!: a Clob object representing data of an SQL CLOB value |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |
writeDate
abstract fun writeDate(x: Date!): Unit
Writes the next attribute to the stream as a java.sql.Date object. Writes the next attribute to the stream as a java.sql.Date object in the Java programming language.
| Parameters | |
|---|---|
x |
Date!: the value to pass to the database |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |
writeDouble
abstract fun writeDouble(x: Double): Unit
Writes the next attribute to the stream as a Java double. Writes the next attribute to the stream as a String in the Java programming language.
| Parameters | |
|---|---|
x |
Double: the value to pass to the database |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |
writeFloat
abstract fun writeFloat(x: Float): Unit
Writes the next attribute to the stream as a Java float. Writes the next attribute to the stream as a String in the Java programming language.
| Parameters | |
|---|---|
x |
Float: the value to pass to the database |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |
writeInt
abstract fun writeInt(x: Int): Unit
Writes the next attribute to the stream as a Java int. Writes the next attribute to the stream as a String in the Java programming language.
| Parameters | |
|---|---|
x |
Int: the value to pass to the database |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |
writeLong
abstract fun writeLong(x: Long): Unit
Writes the next attribute to the stream as a Java long. Writes the next attribute to the stream as a String in the Java programming language.
| Parameters | |
|---|---|
x |
Long: the value to pass to the database |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |
writeNClob
abstract fun writeNClob(x: NClob!): Unit
Writes an SQL NCLOB value to the stream.
| Parameters | |
|---|---|
x |
NClob!: a NClob object representing data of an SQL NCLOB value |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |
writeNString
abstract fun writeNString(x: String!): Unit
Writes the next attribute to the stream as a String in the Java programming language. The driver converts this to a SQL NCHAR or NVARCHAR or LONGNVARCHAR value (depending on the argument's size relative to the driver's limits on NVARCHAR values) when it sends it to the stream.
| Parameters | |
|---|---|
x |
String!: the value to pass to the database |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |
writeObject
abstract fun writeObject(x: SQLData!): Unit
Writes to the stream the data contained in the given SQLData object. When the SQLData object is null, this method writes an SQL NULL to the stream. Otherwise, it calls the SQLData.writeSQL method of the given object, which writes the object's attributes to the stream. The implementation of the method SQLData.writeSQ calls the appropriate SQLOutput writer method(s) for writing each of the object's attributes in order. The attributes must be read from an SQLInput input stream and written to an SQLOutput output stream in the same order in which they were listed in the SQL definition of the user-defined type.
| Parameters | |
|---|---|
x |
SQLData!: the object representing data of an SQL structured or distinct type |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |
writeRef
abstract fun writeRef(x: Ref!): Unit
Writes an SQL REF value to the stream.
| Parameters | |
|---|---|
x |
Ref!: a Ref object representing data of an SQL REF value |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |
writeRowId
abstract fun writeRowId(x: RowId!): Unit
Writes an SQL ROWID value to the stream.
| Parameters | |
|---|---|
x |
RowId!: a RowId object representing data of an SQL ROWID value |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |
writeSQLXML
abstract fun writeSQLXML(x: SQLXML!): Unit
Writes an SQL XML value to the stream.
| Parameters | |
|---|---|
x |
SQLXML!: a SQLXML object representing data of an SQL XML value |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs, the java.xml.transform.Result, Writer or OutputStream has not been closed for the SQLXML object or if there is an error processing the XML value. The getCause method of the exception may provide a more detailed exception, for example, if the stream does not contain valid XML. |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |
writeShort
abstract fun writeShort(x: Short): Unit
Writes the next attribute to the stream as a Java short. Writes the next attribute to the stream as a String in the Java programming language.
| Parameters | |
|---|---|
x |
Short: the value to pass to the database |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |
writeString
abstract fun writeString(x: String!): Unit
Writes the next attribute to the stream as a String in the Java programming language.
| Parameters | |
|---|---|
x |
String!: the value to pass to the database |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |
writeStruct
abstract fun writeStruct(x: Struct!): Unit
Writes an SQL structured type value to the stream.
| Parameters | |
|---|---|
x |
Struct!: a Struct object representing data of an SQL structured type |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |
writeTime
abstract fun writeTime(x: Time!): Unit
Writes the next attribute to the stream as a java.sql.Time object. Writes the next attribute to the stream as a java.sql.Date object in the Java programming language.
| Parameters | |
|---|---|
x |
Time!: the value to pass to the database |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |
writeTimestamp
abstract fun writeTimestamp(x: Timestamp!): Unit
Writes the next attribute to the stream as a java.sql.Timestamp object. Writes the next attribute to the stream as a java.sql.Date object in the Java programming language.
| Parameters | |
|---|---|
x |
Timestamp!: the value to pass to the database |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |
writeURL
abstract fun writeURL(x: URL!): Unit
Writes a SQL DATALINK value to the stream.
| Parameters | |
|---|---|
x |
URL!: a java.net.URL object representing the data of SQL DATALINK type |
| Exceptions | |
|---|---|
java.sql.SQLException |
if a database access error occurs |
java.sql.SQLFeatureNotSupportedException |
if the JDBC driver does not support this method |