SQLInput JDK 1.6)

public Array readArray () throws SQLException

Reads an SQL ARRAY value from the stream and returns it as an Array object in the Java programming language.

Reads an SQL ARRAY value from the stream and returns it as an
Array object in the Java programming language.
Returns: an Array object representing data of the SQL ARRAY value at the head of the stream; null if the value read is SQL NULL
Throws:
- SQLException - if a database access error occurs
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.2

public InputStream readAsciiStream () throws SQLException

Reads the next attribute in the stream and returns it as a stream of ASCII characters.

Reads the next attribute in the stream and returns it as a stream of ASCII characters.
Returns: the attribute; if the value is SQL NULL, returns null
Throws:
- SQLException - if a database access error occurs
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.2

public BigDecimal readBigDecimal () throws SQLException

Reads the next attribute in the stream and returns it as a java.math.BigDecimal object in the Java programming language.

Reads the next attribute in the stream and returns it as a java.math.BigDecimal
object in the Java programming language.
Returns: the attribute; if the value is SQL NULL, returns null
Throws:
- SQLException - if a database access error occurs
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.2

public InputStream readBinaryStream () throws SQLException

Reads the next attribute in the stream and returns it as a stream of uninterpreted bytes.

Reads the next attribute in the stream and returns it as a stream of uninterpreted
bytes.
Returns: the attribute; if the value is SQL NULL, returns null
Throws:
- SQLException - if a database access error occurs
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.2

public Blob readBlob () throws SQLException

Reads an SQL BLOB value from the stream and returns it as a Blob object in the Java programming language.

Reads an SQL BLOB value from the stream and returns it as a
Blob object in the Java programming language.
Returns: a Blob object representing data of the SQL BLOB value at the head of the stream; null if the value read is SQL NULL
Throws:
- SQLException - if a database access error occurs
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.2

public boolean readBoolean () throws SQLException

Reads the next attribute in the stream and returns it as a boolean in the Java programming language.

Reads the next attribute in the stream and returns it as a boolean
in the Java programming language.
Returns: the attribute; if the value is SQL NULL, returns false
Throws:
- SQLException - if a database access error occurs
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.2

public byte readByte () throws SQLException

Reads the next attribute in the stream and returns it as a byte in the Java programming language.

Reads the next attribute in the stream and returns it as a byte
in the Java programming language.
Returns: the attribute; if the value is SQL NULL, returns 0
Throws:
- SQLException - if a database access error occurs
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.2

public byte readBytes () throws SQLException

Reads the next attribute in the stream and returns it as an array of bytes in the Java programming language.

Reads the next attribute in the stream and returns it as an array of bytes
in the Java programming language.
Returns: the attribute; if the value is SQL NULL, returns null
Throws:
- SQLException - if a database access error occurs
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.2

public Reader readCharacterStream () throws SQLException

Reads the next attribute in the stream and returns it as a stream of Unicode characters.

Reads the next attribute in the stream and returns it as a stream of Unicode characters.
Returns: the attribute; if the value is SQL NULL, returns null
Throws:
- SQLException - if a database access error occurs
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.2

public Clob readClob () throws SQLException

Reads an SQL CLOB value from the stream and returns it as a Clob object in the Java programming language.

Reads an SQL CLOB value from the stream and returns it as a
Clob object in the Java programming language.
Returns: a Clob object representing data of the SQL CLOB value at the head of the stream; null if the value read is SQL NULL
Throws:
- SQLException - if a database access error occurs
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.2

public Date readDate () throws SQLException

Reads the next attribute in the stream and returns it as a java.sql.Date object.

Reads the next attribute in the stream and returns it as a java.sql.Date object.
Returns: the attribute; if the value is SQL NULL, returns null
Throws:
- SQLException - if a database access error occurs
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.2

public double readDouble () throws SQLException

Reads the next attribute in the stream and returns it as a double in the Java programming language.

Reads the next attribute in the stream and returns it as a double
in the Java programming language.
Returns: the attribute; if the value is SQL NULL, returns 0
Throws:
- SQLException - if a database access error occurs
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.2

public float readFloat () throws SQLException

Reads the next attribute in the stream and returns it as a float in the Java programming language.

Reads the next attribute in the stream and returns it as a float
in the Java programming language.
Returns: the attribute; if the value is SQL NULL, returns 0
Throws:
- SQLException - if a database access error occurs
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.2

public int readInt () throws SQLException

Reads the next attribute in the stream and returns it as an int in the Java programming language.

Reads the next attribute in the stream and returns it as an int
in the Java programming language.
Returns: the attribute; if the value is SQL NULL, returns 0
Throws:
- SQLException - if a database access error occurs
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.2

public long readLong () throws SQLException

Reads the next attribute in the stream and returns it as a long in the Java programming language.

Reads the next attribute in the stream and returns it as a long
in the Java programming language.
Returns: the attribute; if the value is SQL NULL, returns 0
Throws:
- SQLException - if a database access error occurs
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.2

public NClob readNClob () throws SQLException

Reads an SQL NCLOB value from the stream and returns it as a NClob object in the Java programming language.

Reads an SQL NCLOB value from the stream and returns it as a
NClob object in the Java programming language.
Returns: a NClob object representing data of the SQL NCLOB value at the head of the stream; null if the value read is SQL NULL
Throws:
- SQLException - if a database access error occurs
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.6

public String readNString () throws SQLException

Reads the next attribute in the stream and returns it as a String in the Java programming language.

Reads the next attribute in the stream and returns it as a String
in the Java programming language. It is intended for use when
accessing NCHAR,NVARCHAR
and LONGNVARCHAR columns.
Returns: the attribute; if the value is SQL NULL, returns null
Throws:
- SQLException - if a database access error occurs
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.6

public Object readObject () throws SQLException

Reads the datum at the head of the stream and returns it as an Object in the Java programming language.

Reads the datum at the head of the stream and returns it as an Object in the Java programming language. The actual type of the object returned is determined by the default type mapping, and any customizations present in this stream's type map.

A type map is registered with the stream by the JDBC driver before the stream is passed to the application.

When the datum at the head of the stream is an SQL NULL, the method returns null. If the datum is an SQL structured or distinct type, it determines the SQL type of the datum at the head of the stream. If the stream's type map has an entry for that SQL type, the driver constructs an object of the appropriate class and calls the method SQLData.readSQL on that object, which reads additional data from the stream, using the protocol described for that method.
Returns: the datum at the head of the stream as an Object in the Java programming language;null if the datum is SQL NULL
Throws:
- SQLException - if a database access error occurs
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.2

public Ref readRef () throws SQLException

Reads an SQL REF value from the stream and returns it as a Ref object in the Java programming language.

Reads an SQL REF value from the stream and returns it as a
Ref object in the Java programming language.
Returns: a Ref object representing the SQL REF value at the head of the stream; null if the value read is SQL NULL
Throws:
- SQLException - if a database access error occurs
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.2

public RowId readRowId () throws SQLException

Reads an SQL ROWID value from the stream and returns it as a RowId object in the Java programming language.

Reads an SQL ROWID value from the stream and returns it as a
RowId object in the Java programming language.
Returns: a RowId object representing data of the SQL ROWID value at the head of the stream; null if the value read is SQL NULL
Throws:
- SQLException - if a database access error occurs
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.6

public short readShort () throws SQLException

Reads the next attribute in the stream and returns it as a short in the Java programming language.

Reads the next attribute in the stream and returns it as a short
in the Java programming language.
Returns: the attribute; if the value is SQL NULL, returns 0
Throws:
- SQLException - if a database access error occurs
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.2

public SQLXML readSQLXML () throws SQLException

Reads an SQL XML value from the stream and returns it as a SQLXML object in the Java programming language.

Reads an SQL XML value from the stream and returns it as a
SQLXML object in the Java programming language.
Returns: a SQLXML object representing data of the SQL XML value at the head of the stream; null if the value read is SQL NULL
Throws:
- SQLException - if a database access error occurs
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.6

public String readString () throws SQLException

Reads the next attribute in the stream and returns it as a String in the Java programming language.

Reads the next attribute in the stream and returns it as a String
in the Java programming language.
Returns: the attribute; if the value is SQL NULL, returns null
Throws:
- SQLException - if a database access error occurs
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.2

public Time readTime () throws SQLException

Reads the next attribute in the stream and returns it as a java.sql.Time object.

Reads the next attribute in the stream and returns it as a java.sql.Time object.
Returns: the attribute; if the value is SQL NULL, returns null
Throws:
- SQLException - if a database access error occurs
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.2

public Timestamp readTimestamp () throws SQLException

Reads the next attribute in the stream and returns it as a java.sql.Timestamp object.

Reads the next attribute in the stream and returns it as a java.sql.Timestamp object.
Returns: the attribute; if the value is SQL NULL, returns null
Throws:
- SQLException - if a database access error occurs
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.2

public URL readURL () throws SQLException

Reads an SQL DATALINK value from the stream and returns it as a java.net.URL object in the Java programming language.

Reads an SQL DATALINK value from the stream and returns it as a
java.net.URL object in the Java programming language.
Returns: a java.net.URL object.
Throws:
- SQLException - if a database access error occurs, or if a URL is malformed
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.4

public boolean wasNull () throws SQLException

Retrieves whether the last value read was SQL NULL.

Retrieves whether the last value read was SQL NULL.
Returns: true if the most recently read SQL value was SQL NULL; false otherwise
Throws:
- SQLException - if a database access error occurs
- SQLFeatureNotSupportedException - if the JDBC driver does not support this method
Since: 1.2