org.teiid.script.io

Class ResultSetReader

java.lang.Object

java.io.Reader

org.teiid.script.io.StringLineReader

org.teiid.script.io.ResultSetReader

All Implemented Interfaces:

Closeable, AutoCloseable, Readable

public class ResultSetReader
extends StringLineReader

This object wraps/extends a SQL ResultSet object as Reader object. Once the ResultSet can read as reader then it can be persisted, printed or compared easily without lot of code hassle of walking it every time.

PS: remember this is a Reader not InputStream, so all the fields read going to be converted to strings before they returned.

Since:

4.3

Field Summary

Fields inherited from class java.io.Reader

lock

Constructor Summary

Constructors

Constructor and Description
ResultSetReader(ResultSet in)
ResultSetReader(ResultSet in, String delimiter)

Method Summary

Modifier and Type	Method and Description
void	close()
int	getRowCount()
protected String	nextLine() Get the next line of results from the ResultSet.
static String	prettyPrint(SQLXML xml)
static String	resultSetMetaDataToString(ResultSetMetaData metadata, String delimiter) Get the first line from the result set.

Methods inherited from class org.teiid.script.io.StringLineReader

read

Methods inherited from class java.io.Reader

mark, markSupported, read, read, read, ready, reset, skip

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

ResultSetReader

public ResultSetReader(ResultSet in)

ResultSetReader

public ResultSetReader(ResultSet in,
                       String delimiter)

Method Detail

close

public void close()
           throws IOException

Specified by:

close in interface Closeable

Specified by:

close in interface AutoCloseable

Overrides:

close in class StringLineReader

Throws:

IOException

Since:

4.3

See Also:

Reader.close()

nextLine

protected String nextLine()
                   throws IOException

Get the next line of results from the ResultSet. The first line will be the metadata of the resultset and then followed by the result rows. Each row will be returned as one line.

Specified by:

nextLine in class StringLineReader

Returns:

next result line from result set.

Throws:

IOException

getRowCount

public int getRowCount()

resultSetMetaDataToString

public static String resultSetMetaDataToString(ResultSetMetaData metadata,
                                               String delimiter)
                                        throws SQLException

Get the first line from the result set. This is the resultset metadata line where we gather the column names and their types.

Returns:

Throws:

SQLException

prettyPrint

public static String prettyPrint(SQLXML xml)
                          throws SQLException

Throws:

SQLException