Package Summary  Overview Summary

class:SQLOutputImpl [NONE]

  • All Implemented Interfaces:
    SQLOutput

    public class SQLOutputImpl
    extends Object
    implements SQLOutput
    
    The output stream for writing the attributes of a custom-mapped user-defined type (UDT) back to the database. The driver uses this interface internally, and its methods are never directly invoked by an application programmer.

    When an application calls the method PreparedStatement.setObject, the driver checks to see whether the value to be written is a UDT with a custom mapping. If it is, there will be an entry in a type map containing the Class object for the class that implements SQLData for this UDT. If the value to be written is an instance of SQLData, the driver will create an instance of SQLOutputImpl and pass it to the method SQLData.writeSQL. The method writeSQL in turn calls the appropriate SQLOutputImpl.writeXXX methods to write data from the SQLData object to the SQLOutputImpl output stream as the representation of an SQL user-defined type.

    Since:
    1.5

constructor:<init>(java.util.Vector,java.util.Map) [NONE]

  • SQLOutputImpl

    public SQLOutputImpl​(Vector<?> attributes,
                         Map<String,?> map)
                  throws SQLException
    
    Creates a new SQLOutputImpl object initialized with the given vector of attributes and type map. The driver will use the type map to determine which SQLData.writeSQL method to invoke. This method will then call the appropriate SQLOutputImpl writer methods in order and thereby write the attributes to the new output stream.
    Parameters:
    attributes - a Vector object containing the attributes of the UDT to be mapped to one or more objects in the Java programming language
    map - a java.util.Map object containing zero or more entries, with each entry consisting of 1) a String giving the fully qualified name of a UDT and 2) the Class object for the SQLData implementation that defines how the UDT is to be mapped
    Throws:
    SQLException - if the attributes or the map is a null value

method:writeString(java.lang.String) [NONE]

  • writeString

    public void writeString​(String x)
                     throws SQLException
    
    Writes a String in the Java programming language to this SQLOutputImpl object. The driver converts it to an SQL CHAR, VARCHAR, or LONGVARCHAR before returning it to the database.
    Specified by:
    writeString in interface SQLOutput
    Parameters:
    x - the value to pass to the database
    Throws:
    SQLException - if the SQLOutputImpl object is in use by a SQLData object attempting to write the attribute values of a UDT to the database.

method:writeBoolean(boolean) [NONE]

  • writeBoolean

    public void writeBoolean​(boolean x)
                      throws SQLException
    
    Writes a boolean in the Java programming language to this SQLOutputImpl object. The driver converts it to an SQL BIT before returning it to the database.
    Specified by:
    writeBoolean in interface SQLOutput
    Parameters:
    x - the value to pass to the database
    Throws:
    SQLException - if the SQLOutputImpl object is in use by a SQLData object attempting to write the attribute values of a UDT to the database.

method:writeByte(byte) [NONE]

  • writeByte

    public void writeByte​(byte x)
                   throws SQLException
    
    Writes a byte in the Java programming language to this SQLOutputImpl object. The driver converts it to an SQL BIT before returning it to the database.
    Specified by:
    writeByte in interface SQLOutput
    Parameters:
    x - the value to pass to the database
    Throws:
    SQLException - if the SQLOutputImpl object is in use by a SQLData object attempting to write the attribute values of a UDT to the database.

method:writeShort(short) [NONE]

  • writeShort

    public void writeShort​(short x)
                    throws SQLException
    
    Writes a short in the Java programming language to this SQLOutputImpl object. The driver converts it to an SQL SMALLINT before returning it to the database.
    Specified by:
    writeShort in interface SQLOutput
    Parameters:
    x - the value to pass to the database
    Throws:
    SQLException - if the SQLOutputImpl object is in use by a SQLData object attempting to write the attribute values of a UDT to the database.

method:writeInt(int) [NONE]

  • writeInt

    public void writeInt​(int x)
                  throws SQLException
    
    Writes an int in the Java programming language to this SQLOutputImpl object. The driver converts it to an SQL INTEGER before returning it to the database.
    Specified by:
    writeInt in interface SQLOutput
    Parameters:
    x - the value to pass to the database
    Throws:
    SQLException - if the SQLOutputImpl object is in use by a SQLData object attempting to write the attribute values of a UDT to the database.

method:writeLong(long) [NONE]

  • writeLong

    public void writeLong​(long x)
                   throws SQLException
    
    Writes a long in the Java programming language to this SQLOutputImpl object. The driver converts it to an SQL BIGINT before returning it to the database.
    Specified by:
    writeLong in interface SQLOutput
    Parameters:
    x - the value to pass to the database
    Throws:
    SQLException - if the SQLOutputImpl object is in use by a SQLData object attempting to write the attribute values of a UDT to the database.

method:writeFloat(float) [NONE]

  • writeFloat

    public void writeFloat​(float x)
                    throws SQLException
    
    Writes a float in the Java programming language to this SQLOutputImpl object. The driver converts it to an SQL REAL before returning it to the database.
    Specified by:
    writeFloat in interface SQLOutput
    Parameters:
    x - the value to pass to the database
    Throws:
    SQLException - if the SQLOutputImpl object is in use by a SQLData object attempting to write the attribute values of a UDT to the database.

method:writeDouble(double) [NONE]

  • writeDouble

    public void writeDouble​(double x)
                     throws SQLException
    
    Writes a double in the Java programming language to this SQLOutputImpl object. The driver converts it to an SQL DOUBLE before returning it to the database.
    Specified by:
    writeDouble in interface SQLOutput
    Parameters:
    x - the value to pass to the database
    Throws:
    SQLException - if the SQLOutputImpl object is in use by a SQLData object attempting to write the attribute values of a UDT to the database.

method:writeBigDecimal(java.math.BigDecimal) [NONE]

  • writeBigDecimal

    public void writeBigDecimal​(BigDecimal x)
                         throws SQLException
    
    Writes a java.math.BigDecimal object in the Java programming language to this SQLOutputImpl object. The driver converts it to an SQL NUMERIC before returning it to the database.
    Specified by:
    writeBigDecimal in interface SQLOutput
    Parameters:
    x - the value to pass to the database
    Throws:
    SQLException - if the SQLOutputImpl object is in use by a SQLData object attempting to write the attribute values of a UDT to the database.

method:writeBytes(byte[]) [NONE]

  • writeBytes

    public void writeBytes​(byte[] x)
                    throws SQLException
    
    Writes an array of bytes in the Java programming language to this SQLOutputImpl object. The driver converts it to an SQL VARBINARY or LONGVARBINARY before returning it to the database.
    Specified by:
    writeBytes in interface SQLOutput
    Parameters:
    x - the value to pass to the database
    Throws:
    SQLException - if the SQLOutputImpl object is in use by a SQLData object attempting to write the attribute values of a UDT to the database.

method:writeDate(java.sql.Date) [NONE]

  • writeDate

    public void writeDate​(Date x)
                   throws SQLException
    
    Writes a java.sql.Date object in the Java programming language to this SQLOutputImpl object. The driver converts it to an SQL DATE before returning it to the database.
    Specified by:
    writeDate in interface SQLOutput
    Parameters:
    x - the value to pass to the database
    Throws:
    SQLException - if the SQLOutputImpl object is in use by a SQLData object attempting to write the attribute values of a UDT to the database.

method:writeTime(java.sql.Time) [NONE]

  • writeTime

    public void writeTime​(Time x)
                   throws SQLException
    
    Writes a java.sql.Time object in the Java programming language to this SQLOutputImpl object. The driver converts it to an SQL TIME before returning it to the database.
    Specified by:
    writeTime in interface SQLOutput
    Parameters:
    x - the value to pass to the database
    Throws:
    SQLException - if the SQLOutputImpl object is in use by a SQLData object attempting to write the attribute values of a UDT to the database.

method:writeTimestamp(java.sql.Timestamp) [NONE]

  • writeTimestamp

    public void writeTimestamp​(Timestamp x)
                        throws SQLException
    
    Writes a java.sql.Timestamp object in the Java programming language to this SQLOutputImpl object. The driver converts it to an SQL TIMESTAMP before returning it to the database.
    Specified by:
    writeTimestamp in interface SQLOutput
    Parameters:
    x - the value to pass to the database
    Throws:
    SQLException - if the SQLOutputImpl object is in use by a SQLData object attempting to write the attribute values of a UDT to the database.

method:writeCharacterStream(java.io.Reader) [NONE]

  • writeCharacterStream

    public void writeCharacterStream​(Reader x)
                              throws SQLException
    
    Writes a stream of Unicode characters to this SQLOutputImpl object. The driver will do any necessary conversion from Unicode to the database CHAR format.
    Specified by:
    writeCharacterStream in interface SQLOutput
    Parameters:
    x - the value to pass to the database
    Throws:
    SQLException - if the SQLOutputImpl object is in use by a SQLData object attempting to write the attribute values of a UDT to the database.

method:writeAsciiStream(java.io.InputStream) [NONE]

  • writeAsciiStream

    public void writeAsciiStream​(InputStream x)
                          throws SQLException
    
    Writes a stream of ASCII characters to this SQLOutputImpl object. The driver will do any necessary conversion from ASCII to the database CHAR format.
    Specified by:
    writeAsciiStream in interface SQLOutput
    Parameters:
    x - the value to pass to the database
    Throws:
    SQLException - if the SQLOutputImpl object is in use by a SQLData object attempting to write the attribute values of a UDT to the database.

method:writeBinaryStream(java.io.InputStream) [NONE]

  • writeBinaryStream

    public void writeBinaryStream​(InputStream x)
                           throws SQLException
    
    Writes a stream of uninterpreted bytes to this SQLOutputImpl object.
    Specified by:
    writeBinaryStream in interface SQLOutput
    Parameters:
    x - the value to pass to the database
    Throws:
    SQLException - if the SQLOutputImpl object is in use by a SQLData object attempting to write the attribute values of a UDT to the database.

method:writeObject(java.sql.SQLData) [NONE]

  • writeObject

    public void writeObject​(SQLData x)
                     throws SQLException
    
    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 SQLOutputImpl.writeXXX 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 SQLOutputImpl output stream in the same order in which they were listed in the SQL definition of the user-defined type.

    Specified by:
    writeObject in interface SQLOutput
    Parameters:
    x - the object representing data of an SQL structured or distinct type
    Throws:
    SQLException - if the SQLOutputImpl object is in use by a SQLData object attempting to write the attribute values of a UDT to the database.

method:writeRef(java.sql.Ref) [NONE]

  • writeRef

    public void writeRef​(Ref x)
                  throws SQLException
    
    Writes a Ref object in the Java programming language to this SQLOutputImpl object. The driver converts it to a serializable SerialRef SQL REF value before returning it to the database.
    Specified by:
    writeRef in interface SQLOutput
    Parameters:
    x - an object representing an SQL REF value
    Throws:
    SQLException - if the SQLOutputImpl object is in use by a SQLData object attempting to write the attribute values of a UDT to the database.

method:writeBlob(java.sql.Blob) [NONE]

  • writeBlob

    public void writeBlob​(Blob x)
                   throws SQLException
    
    Writes a Blob object in the Java programming language to this SQLOutputImpl object. The driver converts it to a serializable SerialBlob SQL BLOB value before returning it to the database.
    Specified by:
    writeBlob in interface SQLOutput
    Parameters:
    x - an object representing an SQL BLOB value
    Throws:
    SQLException - if the SQLOutputImpl object is in use by a SQLData object attempting to write the attribute values of a UDT to the database.

method:writeClob(java.sql.Clob) [NONE]

  • writeClob

    public void writeClob​(Clob x)
                   throws SQLException
    
    Writes a Clob object in the Java programming language to this SQLOutputImpl object. The driver converts it to a serializable SerialClob SQL CLOB value before returning it to the database.
    Specified by:
    writeClob in interface SQLOutput
    Parameters:
    x - an object representing an SQL CLOB value
    Throws:
    SQLException - if the SQLOutputImpl object is in use by a SQLData object attempting to write the attribute values of a UDT to the database.

method:writeStruct(java.sql.Struct) [NONE]

  • writeStruct

    public void writeStruct​(Struct x)
                     throws SQLException
    
    Writes a Struct object in the Java programming language to this SQLOutputImpl object. The driver converts this value to an SQL structured type before returning it to the database.

    This method should be used when an SQL structured type has been mapped to a Struct object in the Java programming language (the standard mapping). The method writeObject should be used if an SQL structured type has been custom mapped to a class in the Java programming language.

    Specified by:
    writeStruct in interface SQLOutput
    Parameters:
    x - an object representing the attributes of an SQL structured type
    Throws:
    SQLException - if the SQLOutputImpl object is in use by a SQLData object attempting to write the attribute values of a UDT to the database.

method:writeArray(java.sql.Array) [NONE]

  • writeArray

    public void writeArray​(Array x)
                    throws SQLException
    
    Writes an Array object in the Java programming language to this SQLOutputImpl object. The driver converts this value to a serializable SerialArray SQL ARRAY value before returning it to the database.
    Specified by:
    writeArray in interface SQLOutput
    Parameters:
    x - an object representing an SQL ARRAY value
    Throws:
    SQLException - if the SQLOutputImpl object is in use by a SQLData object attempting to write the attribute values of a UDT to the database.

method:writeURL(java.net.URL) [NONE]

  • writeURL

    public void writeURL​(URL url)
                  throws SQLException
    
    Writes an java.sql.Type.DATALINK object in the Java programming language to this SQLOutputImpl object. The driver converts this value to a serializable SerialDatalink SQL DATALINK value before return it to the database.
    Specified by:
    writeURL in interface SQLOutput
    Parameters:
    url - an object representing a SQL DATALINK value
    Throws:
    SQLException - if the SQLOutputImpl object is in use by a SQLData object attempting to write the attribute values of a UDT to the database.

method:writeNString(java.lang.String) [NONE]

  • writeNString

    public void writeNString​(String x)
                      throws SQLException
    
    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.
    Specified by:
    writeNString in interface SQLOutput
    Parameters:
    x - the value to pass to the database
    Throws:
    SQLException - if a database access error occurs
    Since:
    1.6

method:writeNClob(java.sql.NClob) [NONE]

  • writeNClob

    public void writeNClob​(NClob x)
                    throws SQLException
    
    Writes an SQL NCLOB value to the stream.
    Specified by:
    writeNClob in interface SQLOutput
    Parameters:
    x - a NClob object representing data of an SQL NCLOB value
    Throws:
    SQLException - if a database access error occurs
    Since:
    1.6

method:writeRowId(java.sql.RowId) [NONE]

  • writeRowId

    public void writeRowId​(RowId x)
                    throws SQLException
    
    Writes an SQL ROWID value to the stream.
    Specified by:
    writeRowId in interface SQLOutput
    Parameters:
    x - a RowId object representing data of an SQL ROWID value
    Throws:
    SQLException - if a database access error occurs
    Since:
    1.6

method:writeSQLXML(java.sql.SQLXML) [NONE]

  • writeSQLXML

    public void writeSQLXML​(SQLXML x)
                     throws SQLException
    
    Writes an SQL XML value to the stream.
    Specified by:
    writeSQLXML in interface SQLOutput
    Parameters:
    x - a SQLXML object representing data of an SQL XML value
    Throws:
    SQLException - if a database access error occurs
    Since:
    1.6

© 2019 Oracle Corporation and/or its affiliates