com.ddtek.jxtr
Interface JXTRResultSet

public interface JXTRResultSet

A JXTRResultSet object implements a result set like view for the information returned by executing a jXTransformer query.

Consider the following query:

 select
     e.EmpId,
     xml_element('names',
       xml_element('first-name', e.FirstName),
       xml_element('last-name', e.LastName)),
     xml_element('dates',
       xml_element('start-of-contract',e.HireDate
       xml_element('end-of-contract',e.EndDate))
    from Employees e
 

Executing this query with JXTRQuery.executeQuery() will return a JXTRResulSet object. This result set object will have three columns: the first is a regular JDBC integer column, while the second and third columns are XML typed columns (see JXTRQuery.XMLTYPE). The contents of these columns can be extracted using the methods defined in JXTRColInfo.

Moving to the next row is done by invoking next().

It is important to note that JXTRResultSet implements a read only and forward only type of result set. Furthermore, column values must be retrieved in sequence (left to right).

Method Summary
void	clearWarnings()           Clears all the warnings reported on this object.
void	close()           Closes all JDBC resources associated with this result set.
int	findColumn(java.lang.String columnName)           Maps the specified ResultSet column name to its ResultSet column index.
java.io.InputStream	getAsciiStream(int columnIndex)           Gets the value of the designated column in the current row of this JXTRResultSet as an AsciiStream.
java.io.InputStream	getAsciiStream(java.lang.String columnName)           Gets the value of the designated column in the current row of this JXTRResultSet as an AsciiStream.
java.math.BigDecimal	getBigDecimal(int columnIndex)           Gets the value of the designated column in the current row of this JXTRResultSet as a BigDecimal.
java.math.BigDecimal	getBigDecimal(int columnIndex, int scale)           Gets the value of the designated column in the current row of this JXTRResultSet as a BigDecimal.
java.math.BigDecimal	getBigDecimal(java.lang.String columnName)           Gets the value of the designated column in the current row of this JXTRResultSet as a BigDecimal.
java.math.BigDecimal	getBigDecimal(java.lang.String columnName, int scale)           Gets the value of the designated column in the current row of this JXTRResultSet as a BigDecimal.
java.io.InputStream	getBinaryStream(int columnIndex)           Gets the value of the designated column in the current row of this JXTRResultSet as a BinaryStream.
java.io.InputStream	getBinaryStream(java.lang.String columnName)           Gets the value of the designated column in the current row of this JXTRResultSet as a BinaryStream.
java.sql.Blob	getBlob(int columnIndex)           Gets the value of the designated column in the current row of this JXTRResultSet as a Blob.
java.sql.Blob	getBlob(java.lang.String columnName)           Gets the value of the designated column in the current row of this JXTRResultSet as a Blob.
boolean	getBoolean(int columnIndex)           Gets the value of the designated column in the current row of this JXTRResultSet as a boolean.
boolean	getBoolean(java.lang.String columnName)           Gets the value of the designated column in the current row of this JXTRResultSet as a boolean.
byte	getByte(int columnIndex)           Gets the value of the designated column in the current row of this JXTRResultSet as a byte.
byte	getByte(java.lang.String columnName)           Gets the value of the designated column in the current row of this JXTRResultSet as a byte.
byte[]	getBytes(int columnIndex)           Gets the value of the designated column in the current row of this JXTRResultSet as a byte array.
byte[]	getBytes(java.lang.String columnName)           Gets the value of the designated column in the current row of this JXTRResultSet as a byte array.
java.io.Reader	getCharacterStream(int columnIndex)           Gets the value of the designated column in the current row of this JXTRResultSet as a CharacterStream.
java.io.Reader	getCharacterStream(java.lang.String columnName)           Gets the value of the designated column in the current row of this JXTRResultSet as a CharacterStream.
java.sql.Clob	getClob(int columnIndex)           Gets the value of the designated column in the current row of this JXTRResultSet as a Clob.
java.sql.Clob	getClob(java.lang.String columnName)           Gets the value of the designated column in the current row of this JXTRResultSet as a Clob.
java.sql.Date	getDate(int columnIndex)           Gets the value of the designated column in the current row of this JXTRResultSet as a Date.
java.sql.Date	getDate(int columnIndex, java.util.Calendar calendar)           Gets the value of the designated column in the current row of this JXTRResultSet as a Date.
java.sql.Date	getDate(java.lang.String columnName)           Gets the value of the designated column in the current row of this JXTRResultSet as a Date.
java.sql.Date	getDate(java.lang.String columnName, java.util.Calendar calendar)           Gets the value of the designated column in the current row of this JXTRResultSet as a Date.
double	getDouble(int columnIndex)           Gets the value of the designated column in the current row of this JXTRResultSet as a double.
double	getDouble(java.lang.String columnName)           Gets the value of the designated column in the current row of this JXTRResultSet as a double.
float	getFloat(int columnIndex)           Gets the value of the designated column in the current row of this JXTRResultSet as a float.
float	getFloat(java.lang.String columnName)           Gets the value of the designated column in the current row of this JXTRResultSet as a float.
int	getInt(int columnIndex)           Gets the value of the designated column in the current row of this JXTRResultSet as an int.
int	getInt(java.lang.String columnName)           Gets the value of the designated column in the current row of this JXTRResultSet as an int.
long	getLong(int columnIndex)           Gets the value of the designated column in the current row of this JXTRResultSet as a long.
long	getLong(java.lang.String columnName)           Gets the value of the designated column in the current row of this JXTRResultSet as a long.
JXTRResultSetMetaData	getMetaData()           Retrieves the meta data object associated with this result set.
java.lang.Object	getObject(int columnIndex)           Gets the value of the designated column in the current row of this JXTRResultSet as a Java Object.
java.lang.Object	getObject(java.lang.String columnName)           Gets the value of the designated column in the current row of this JXTRResultSet as a Java Object.
short	getShort(int columnIndex)           Gets the value of the designated column in the current row of this JXTRResultSet as a short.
short	getShort(java.lang.String columnName)           Gets the value of the designated column in the current row of this JXTRResultSet as a short.
java.lang.String	getString(int columnIndex)           Gets the value of the designated column in the current row of this JXTRResultSet as a String.
java.lang.String	getString(java.lang.String columnName)           Gets the value of the designated column in the current row of this JXTRResultSet as a String.
java.sql.Time	getTime(int columnIndex)           Gets the value of the designated column in the current row of this JXTRResultSet as a Time.
java.sql.Time	getTime(int columnIndex, java.util.Calendar calendar)           Gets the value of the designated column in the current row of this JXTRResultSet as a Time.
java.sql.Time	getTime(java.lang.String columnName)           Gets the value of the designated column in the current row of this JXTRResultSet as a Time.
java.sql.Time	getTime(java.lang.String columnName, java.util.Calendar calendar)           Gets the value of the designated column in the current row of this JXTRResultSet as a Time.
java.sql.Timestamp	getTimestamp(int columnIndex)           Gets the value of the designated column in the current row of this JXTRResultSet as a Timestamp.
java.sql.Timestamp	getTimestamp(int columnIndex, java.util.Calendar calendar)           Gets the value of the designated column in the current row of this JXTRResultSet as a Timestamp.
java.sql.Timestamp	getTimestamp(java.lang.String columnName)           Gets the value of the designated column in the current row of this JXTRResultSet as a Timestamp.
java.sql.Timestamp	getTimestamp(java.lang.String columnName, java.util.Calendar calendar)           Gets the value of the designated column in the current row of this JXTRResultSet as a Timestamp.
JXTRWarning	getWarnings()           Retrieves the first warning reported by calls on this object.
boolean	next()           Move to the next row.
boolean	wasNull()           Reports whether the last column that was read had a value of SQL NULL.

 

Method Detail

close

public void close()
           throws JXTRException

Closes all JDBC resources associated with this result set.

JXTRException

next

public boolean next()
             throws JXTRException

Move to the next row. The method returns true when a row is retrieved and false when the end of the result set is reached.

JXTRException

wasNull

public boolean wasNull()
                throws JXTRException

Reports whether the last column that was read had a value of SQL NULL. Note that you first must call one of the get methods on a column to try to read its value and then call the method wasNull to determine if the value that was read is SQL NULL.

Currently, this method always returns false for columns of type JXTRQuery.XML_TYPE.

Returns:

true if the last column value read was SQL NULL and false otherwise

Throws:

JXTRException

getMetaData

public JXTRResultSetMetaData getMetaData()
                                  throws JXTRException

Retrieves the meta data object associated with this result set.

Returns:

The meta data associated with this result set.

JXTRException

See Also:

JXTRResultSetMetaData

findColumn

public int findColumn(java.lang.String columnName)
               throws JXTRException

Maps the specified ResultSet column name to its ResultSet column index.

Parameters:

columnName - Name of the column

Returns:

int The columnIndex

Throws:

JXTRException - if a database error occurs or the columnName is invalid

getObject

public java.lang.Object getObject(int columnIndex)
                           throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a Java Object.

This method returns the value of the column as a Java object. The type of the Java object will be the default Java object type corresponding to the column's SQL type, or com.ddtek.jxtr.JXTRColInfo for XML columns. If the value is a SQL NULL, the driver returns a Java null.

Parameters:

columnIndex - 1 based column index.

Returns:

a java.lang.Object, holding the columns value or null

Throws:

JXTRException

getByte

public byte getByte(int columnIndex)
             throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a byte.

This method returns the value of the column as a byte. If the column's SQL type doesn't correspond to a byte, the method will try to convert it. To check if the column is SQL NULL, wasNull() must be called.

Parameters:

columnIndex - 1 based column index.

Returns:

columns value

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getShort

public short getShort(int columnIndex)
               throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a short.

This method returns the value of the column as a short. If the column's SQL type doesn't correspond to a short, the method will try to convert it. To check if the column value is SQL NULL, wasNull() must be called.

Parameters:

columnIndex - 1 based column index.

Returns:

columns value

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getInt

public int getInt(int columnIndex)
           throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as an int.

This method returns the value of the column as a int. If the column's SQL type doesn't correspond to a int, the method will try to convert it. To check if the column value is SQL NULL, wasNull() must be called.

Parameters:

columnIndex - 1 based column index.

Returns:

columns value

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getLong

public long getLong(int columnIndex)
             throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a long.

This method returns the value of the column as a long. If the column's SQL type doesn't correspond to a long, the method will try to convert it. To check if the column value is SQL NULL, wasNull() must be called.

Parameters:

columnIndex - 1 based column index.

Returns:

columns value

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getFloat

public float getFloat(int columnIndex)
               throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a float.

This method returns the value of the column as a float. If the column's SQL type doesn't correspond to a float, the method will try to convert it. To check if the column value is SQL NULL, wasNull() must be called.

Parameters:

columnIndex - 1 based column index.

Returns:

columns value

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getDouble

public double getDouble(int columnIndex)
                 throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a double.

This method returns the value of the column as a double. If the column's SQL type doesn't correspond to a double, the method will try to convert it. To check if the column value is SQL NULL, wasNull() must be called.

Parameters:

columnIndex - 1 based column index.

Returns:

columns value

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getBigDecimal

public java.math.BigDecimal getBigDecimal(int columnIndex)
                                   throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a BigDecimal.

This method returns the value of the column as a BigDecimal. If the column's SQL type doesn't correspond to a BigDecimal, the method will try to convert it. If the value is a SQL NULL, the driver returns a Java null.

Parameters:

columnIndex - 1 based column index.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getBigDecimal

public java.math.BigDecimal getBigDecimal(int columnIndex,
                                          int scale)
                                   throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a BigDecimal.

This method returns the value of the column as a BigDecimal. If the column's SQL type doesn't correspond to a BigDecimal, the method will try to convert it. If the value is a SQL NULL, the driver returns a Java null.

Parameters:

columnIndex - 1 based column index.

scale - the number of digits of the decimal point.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getBoolean

public boolean getBoolean(int columnIndex)
                   throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a boolean.

This method returns the value of the column as a boolean. If the column's SQL type doesn't correspond to a boolean, the method will try to convert it. To check if the column value is SQL NULL, wasNull() must be called.

Parameters:

columnIndex - 1 based column index.

Returns:

columns value

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getString

public java.lang.String getString(int columnIndex)
                           throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a String.

This method returns the value of the column as a String. If the value is a SQL NULL, the driver returns a Java null.

Parameters:

columnIndex - 1 based column index.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getBytes

public byte[] getBytes(int columnIndex)
                throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a byte array.

This method returns the value of the column as a byte array. If the value is a SQL NULL, the driver returns a Java null.

Parameters:

columnIndex - 1 based column index.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getDate

public java.sql.Date getDate(int columnIndex)
                      throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a Date.

This method returns the value of the column as a Date. If the value is a SQL NULL, the driver returns a Java null.

Parameters:

columnIndex - 1 based column index.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getDate

public java.sql.Date getDate(int columnIndex,
                             java.util.Calendar calendar)
                      throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a Date.

This method returns the value of the column as a Date. If the value is a SQL NULL, the driver returns a Java null. This method uses the specified calendar to construct an appropriate millisecond value for the date if the underlying database does not store timezone information.

Parameters:

columnIndex - 1 based column index.

calendar - Calendar object used in the date construction.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getTime

public java.sql.Time getTime(int columnIndex)
                      throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a Time.

This method returns the value of the column as a Time. If the value is a SQL NULL, the driver returns a Java null.

Parameters:

columnIndex - 1 based column index.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getTime

public java.sql.Time getTime(int columnIndex,
                             java.util.Calendar calendar)
                      throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a Time.

This method returns the value of the column as a Time. If the value is a SQL NULL, the driver returns a Java null. This method uses the specified calendar to construct an appropriate millisecond value for the date if the underlying database does not store timezone information.

Parameters:

columnIndex - 1 based column index.

calendar - Calendar object used in the time construction.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getTimestamp

public java.sql.Timestamp getTimestamp(int columnIndex)
                                throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a Timestamp.

This method returns the value of the column as a Timestamp. If the value is a SQL NULL, the driver returns a Java null.

Parameters:

columnIndex - 1 based column index.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getTimestamp

public java.sql.Timestamp getTimestamp(int columnIndex,
                                       java.util.Calendar calendar)
                                throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a Timestamp.

This method returns the value of the column as a Timestamp. If the value is a SQL NULL, the driver returns a Java null. This method uses the specified calendar to construct an appropriate millisecond value for the date if the underlying database does not store timezone information.

Parameters:

columnIndex - 1 based column index.

calendar - Calendar object used in the timestamp construction.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getAsciiStream

public java.io.InputStream getAsciiStream(int columnIndex)
                                   throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as an AsciiStream.

This method returns the value of the column as an AsciiStream. If the value is a SQL NULL, the driver returns a Java null.

Parameters:

columnIndex - 1 based column index.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getBinaryStream

public java.io.InputStream getBinaryStream(int columnIndex)
                                    throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a BinaryStream.

This method returns the value of the column as a BinaryStream. If the value is a SQL NULL, the driver returns a Java null.

Parameters:

columnIndex - 1 based column index.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getCharacterStream

public java.io.Reader getCharacterStream(int columnIndex)
                                  throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a CharacterStream.

This method returns the value of the column as a CharacterStream. If the value is a SQL NULL, the driver returns a Java null.

Parameters:

columnIndex - 1 based column index.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getClob

public java.sql.Clob getClob(int columnIndex)
                      throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a Clob.

This method returns the value of the column as a Clob. If the value is a SQL NULL, the driver returns a Java null.

Parameters:

columnIndex - 1 based column index.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getBlob

public java.sql.Blob getBlob(int columnIndex)
                      throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a Blob.

This method returns the value of the column as a Blob. If the value is a SQL NULL, the driver returns a Java null.

Parameters:

columnIndex - 1 based column index.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getObject

public java.lang.Object getObject(java.lang.String columnName)
                           throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a Java Object.

This method returns the value of the column as a Java object. The type of the Java object will be the default Java object type corresponding to the column's SQL type, or com.ddtek.jxtr.JXTRColInfo, for XML columns. If the value is a SQL NULL, the driver returns a Java null.

Parameters:

columnName - Name of the column.

Returns:

a java.lang.Object, holding the columns value or null

Throws:

JXTRException

getByte

public byte getByte(java.lang.String columnName)
             throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a byte.

This method returns the value of the column as a byte. If the column's SQL type doesn't correspond to a byte, the method will try to convert it. To check if the column value is SQL NULL, wasNull() must be called.

Parameters:

columnName - Name of the column.

Returns:

columns value

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getShort

public short getShort(java.lang.String columnName)
               throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a short.

This method returns the value of the column as a short. If the column's SQL type doesn't correspond to a short, the method will try to convert it. To check if the column value is SQL NULL, wasNull() must be called.

Parameters:

columnName - Name of the column.

Returns:

columns value

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getInt

public int getInt(java.lang.String columnName)
           throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as an int.

This method returns the value of the column as an int. If the column's SQL type doesn't correspond to an int, the method will try to convert it. To check if the column value is SQL NULL, wasNull() must be called.

Parameters:

columnName - Name of the column.

Returns:

columns value

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getLong

public long getLong(java.lang.String columnName)
             throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a long.

This method returns the value of the column as a long. If the column's SQL type doesn't correspond to a long, the method will try to convert it. To check if the column value is SQL NULL, wasNull() must be called.

Parameters:

columnName - Name of the column.

Returns:

columns value

Throws:

JXTRException - if a convertion is not supported or fails

Since:

2.0

getFloat

public float getFloat(java.lang.String columnName)
               throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a float.

This method returns the value of the column as a float. If the column's SQL type doesn't correspond to a float, the method will try to convert it. To check if the column value is SQL NULL, wasNull() must be called.

Parameters:

columnName - Name of the column.

Returns:

columns value

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getDouble

public double getDouble(java.lang.String columnName)
                 throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a double.

This method returns the value of the column as a double. If the column's SQL type doesn't correspond to a double, the method will try to convert it. To check if the column value is SQL NULL, wasNull() must be called.

Parameters:

columnName - Name of the column.

Returns:

columns value

Throws:

JXTRException - if a convertion is not supported or fails

Since:

2.0

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String columnName)
                                   throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a BigDecimal.

This method returns the value of the column as a BigDecimal. If the column's SQL type doesn't correspond to a BigDecimal, the method will try to convert it. If the value is a SQL NULL, the driver returns a Java null.

Parameters:

columnName - Name of the column.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String columnName,
                                          int scale)
                                   throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a BigDecimal.

This method returns the value of the column as a BigDecimal. If the column's SQL type doesn't correspond to a BigDecimal, the method will try to convert it. If the value is a SQL NULL, the driver returns a Java null.

Parameters:

columnName - Name of the column.

scale - Number of digits of the decimal point.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getBoolean

public boolean getBoolean(java.lang.String columnName)
                   throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a boolean.

This method returns the value of the column as a boolean. If the column's SQL type doesn't correspond to a boolean, the method will try to convert it. To check if the column value is SQL NULL, wasNull() must be called.

Parameters:

columnName - Name of the column.

Returns:

columns value

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getString

public java.lang.String getString(java.lang.String columnName)
                           throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a String.

This method returns the value of the column as a String. If the value is a SQL NULL, the driver returns a Java null.

Parameters:

columnName - Name of the column.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getBytes

public byte[] getBytes(java.lang.String columnName)
                throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a byte array.

This method returns the value of the column as a byte array. If the value is a SQL NULL, the driver returns a Java null.

Parameters:

columnName - Name of the column.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getDate

public java.sql.Date getDate(java.lang.String columnName)
                      throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a Date.

This method returns the value of the column as a Date. If the value is a SQL NULL, the driver returns a Java null.

Parameters:

columnName - Name of the column.

Returns:

columns value or null

Throws:

JXTRException - if a convertion is not supported or fails

Since:

2.0

getDate

public java.sql.Date getDate(java.lang.String columnName,
                             java.util.Calendar calendar)
                      throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a Date.

This method returns the value of the column as a Date. If the value is a SQL NULL, the driver returns a Java null. This method uses the specified calendar to construct an appropriate millisecond value for the date if the underlying database does not store timezone information.

Parameters:

columnName - Name of the column.

calendar - Calendar object used in the date construction.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getTime

public java.sql.Time getTime(java.lang.String columnName)
                      throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a Time.

This method returns the value of the column as a Time. If the value is a SQL NULL, the driver returns a Java null.

Parameters:

columnName - Name of the column.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getTime

public java.sql.Time getTime(java.lang.String columnName,
                             java.util.Calendar calendar)
                      throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a Time.

This method returns the value of the column as a Time. If the value is a SQL NULL, the driver returns a Java null. This method uses the specified calendar to construct an appropriate millisecond value for the date if the underlying database does not store timezone information.

Parameters:

columnName - Name of the column.

calendar - Calendar object used in the time construction.

Returns:

columns value or null

Throws:

JXTRException - if a convertion is not supported or fails

Since:

2.0

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String columnName)
                                throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a Timestamp.

This method returns the value of the column as a Timestamp. If the value is a SQL NULL, the driver returns a Java null.

Parameters:

columnName - Name of the column.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String columnName,
                                       java.util.Calendar calendar)
                                throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a Timestamp.

This method returns the value of the column as a Timestamp. If the value is a SQL NULL, the driver returns a Java null. This method uses the specified calendar to construct an appropriate millisecond value for the date if the underlying database does not store timezone information.

Parameters:

columnName - Name of the column.

calendar - Calendar object used in the timestamp construction.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getAsciiStream

public java.io.InputStream getAsciiStream(java.lang.String columnName)
                                   throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as an AsciiStream.

This method returns the value of the column as an AsciiStream. If the value is a SQL NULL, the driver returns a Java null.

Parameters:

columnName - Name of the column.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getBinaryStream

public java.io.InputStream getBinaryStream(java.lang.String columnName)
                                    throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a BinaryStream.

This method returns the value of the column as a BinaryStream. If the value is a SQL NULL, the driver returns a Java null.

Parameters:

columnName - Name of the column.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getCharacterStream

public java.io.Reader getCharacterStream(java.lang.String columnName)
                                  throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a CharacterStream.

This method returns the value of the column as a CharacterStream. If the value is a SQL NULL, the driver returns a Java null.

Parameters:

columnName - Name of the column.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getClob

public java.sql.Clob getClob(java.lang.String columnName)
                      throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a Clob.

This method returns the value of the column as a Clob. If the value is a SQL NULL, the driver returns a Java null.

Parameters:

columnName - Name of the column.

Returns:

columns value or null

Throws:

JXTRException - if a conversion is not supported or fails

Since:

2.0

getBlob

public java.sql.Blob getBlob(java.lang.String columnName)
                      throws JXTRException

Gets the value of the designated column in the current row of this JXTRResultSet as a Blob.

This method returns the value of the column as a Blob. If the value is a SQL NULL, the driver returns a Java null.

Parameters:

columnName - Name of the column.

Returns:

columns value or null

Throws:

JXTRException - if a convertion is not supported or fails

Since:

2.0

getWarnings

public JXTRWarning getWarnings()
                        throws JXTRException

Retrieves the first warning reported by calls on this object. Subsequent warnings are chained to this JXTRWarning object.

The warning chain is automatically cleared each time a new row is read. This method cannot be called on a closed JXTRResultSet object; doing so will cause an JXTRException to be thrown.

Note: This warning chain only covers warnings caused by JXTRResultSet methods. Any warning caused by JXTRQuery methods are chained on the JXTRQuery object.

Throws:

JXTRException - if this method is called on a closed object.

clearWarnings

public void clearWarnings()
                   throws JXTRException

Clears all the warnings reported on this object. After a call to this method, the method getWarnings will return null until a new warning is reported for this object.

Throws:

JXTRException - if an error occurs when clearing the warnings.