Package net.snowflake.client.core

Class SFJsonResultSet

java.lang.Object

net.snowflake.client.core.SFBaseResultSet

net.snowflake.client.core.SFJsonResultSet

Direct Known Subclasses:

SFFixedViewResultSet, SFResultSet

public abstract class SFJsonResultSet
extends SFBaseResultSet

Abstract class used to represent snowflake result set in json format

Field Summary

Fields

Modifier and Type	Field	Description
protected Converters	converters
protected com.fasterxml.jackson.databind.ObjectMapper	objectMapper

Fields inherited from class net.snowflake.client.core.SFBaseResultSet

isClosed, metaDataOfBinds, numberOfBinds, OBJECT_MAPPER, parameters, resultSetMetaData, resultSetSerializable, resultVersion, row, session, sessionTimeZone

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	SFJsonResultSet(TimeZone sessionTimeZone, Converters converters)

Method Summary

Modifier and Type	Method	Description
Date	convertToDate(Object object, TimeZone tz)
Time	convertToTime(Object object, int scale)
Timestamp	convertToTimestamp(Object object, int columnType, int columnSubType, TimeZone tz, int scale)
SQLInput	createSqlInputForColumn(Object input, Class<?> parentObjectClass, int columnIndex, SFBaseSession session, List<FieldMetadata> fields)
Array	getArray(int columnIndex)
BigDecimal	getBigDecimal(int columnIndex)
BigDecimal	getBigDecimal(int columnIndex, int scale)
boolean	getBoolean(int columnIndex)
byte	getByte(int columnIndex)
byte[]	getBytes(int columnIndex)
Converters	getConverters()
Date	getDate(int columnIndex)
Date	getDate(int columnIndex, TimeZone tz)
double	getDouble(int columnIndex)
Duration	getDuration(int columnIndex)
float	getFloat(int columnIndex)
int	getInt(int columnIndex)
long	getLong(int columnIndex)
Object	getObject(int columnIndex)
protected abstract Object	getObjectInternal(int columnIndex)	Given a column index, get current row's value as an object
Object	getObjectWithoutString(int columnIndex)
Period	getPeriod(int columnIndex)
short	getShort(int columnIndex)
String	getString(int columnIndex)
Time	getTime(int columnIndex)
Timestamp	getTimestamp(int columnIndex, TimeZone tz)

Methods inherited from class net.snowflake.client.core.SFBaseResultSet

absolute, close, convertStringToDate, convertStringToTime, convertStringToTimestamp, createJsonSqlInputForColumn, getJsonArray, getMetaData, getMetaDataOfBinds, getNumberOfBinds, getQueryId, getResultSetSerializables, getRow, getSession, getSessionTimezone, getSessionTimeZone, getStatementType, isAfterLast, isArrayBindSupported, isBeforeFirst, isClosed, isFirst, isLast, next, previous, relative, setSession, setStatementType, wasNull

Methods inherited from class java.lang.Object

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

Field Detail

converters

protected final Converters converters

objectMapper

protected final com.fasterxml.jackson.databind.ObjectMapper objectMapper

Constructor Detail

SFJsonResultSet

protected SFJsonResultSet(TimeZone sessionTimeZone,
                          Converters converters)

Method Detail

getObjectInternal

protected abstract Object getObjectInternal(int columnIndex)
                                     throws SFException

Given a column index, get current row's value as an object

Parameters:

columnIndex - index of columns

Returns:

an object

Throws:

SFException - raises if any error occurs

getObject

public Object getObject(int columnIndex)
                 throws SFException

Specified by:

getObject in class SFBaseResultSet

Throws:

SFException

getObjectWithoutString

@SnowflakeJdbcInternalApi
public Object getObjectWithoutString(int columnIndex)
                              throws SFException

Specified by:

getObjectWithoutString in class SFBaseResultSet

Throws:

SFException

getArray

public Array getArray(int columnIndex)
               throws SFException

Overrides:

getArray in class SFBaseResultSet

Throws:

SFException

getString

public String getString(int columnIndex)
                 throws SFException

Specified by:

getString in class SFBaseResultSet

Throws:

SFException

getBoolean

public boolean getBoolean(int columnIndex)
                   throws SFException

Specified by:

getBoolean in class SFBaseResultSet

Throws:

SFException

getByte

public byte getByte(int columnIndex)
             throws SFException

Specified by:

getByte in class SFBaseResultSet

Throws:

SFException

getPeriod

public Period getPeriod(int columnIndex)
                 throws SFException

Specified by:

getPeriod in class SFBaseResultSet

Throws:

SFException

getDuration

public Duration getDuration(int columnIndex)
                     throws SFException

Specified by:

getDuration in class SFBaseResultSet

Throws:

SFException

getShort

public short getShort(int columnIndex)
               throws SFException

Specified by:

getShort in class SFBaseResultSet

Throws:

SFException

getInt

public int getInt(int columnIndex)
           throws SFException

Specified by:

getInt in class SFBaseResultSet

Throws:

SFException

getLong

public long getLong(int columnIndex)
             throws SFException

Specified by:

getLong in class SFBaseResultSet

Throws:

SFException

getBigDecimal

public BigDecimal getBigDecimal(int columnIndex)
                         throws SFException

Specified by:

getBigDecimal in class SFBaseResultSet

Throws:

SFException

getBigDecimal

public BigDecimal getBigDecimal(int columnIndex,
                                int scale)
                         throws SFException

Specified by:

getBigDecimal in class SFBaseResultSet

Throws:

SFException

getTime

public Time getTime(int columnIndex)
             throws SFException

Specified by:

getTime in class SFBaseResultSet

Throws:

SFException

getTimestamp

public Timestamp getTimestamp(int columnIndex,
                              TimeZone tz)
                       throws SFException

Specified by:

getTimestamp in class SFBaseResultSet

Throws:

SFException

getFloat

public float getFloat(int columnIndex)
               throws SFException

Specified by:

getFloat in class SFBaseResultSet

Throws:

SFException

getDouble

public double getDouble(int columnIndex)
                 throws SFException

Specified by:

getDouble in class SFBaseResultSet

Throws:

SFException

getBytes

public byte[] getBytes(int columnIndex)
                throws SFException

Specified by:

getBytes in class SFBaseResultSet

Throws:

SFException

getDate

public Date getDate(int columnIndex)
             throws SFException

Throws:

SFException

getDate

public Date getDate(int columnIndex,
                    TimeZone tz)
             throws SFException

Specified by:

getDate in class SFBaseResultSet

Throws:

SFException

createSqlInputForColumn

@SnowflakeJdbcInternalApi
public SQLInput createSqlInputForColumn(Object input,
                                        Class<?> parentObjectClass,
                                        int columnIndex,
                                        SFBaseSession session,
                                        List<FieldMetadata> fields)

Overrides:

createSqlInputForColumn in class SFBaseResultSet

convertToDate

@SnowflakeJdbcInternalApi
public Date convertToDate(Object object,
                          TimeZone tz)
                   throws SFException

Overrides:

convertToDate in class SFBaseResultSet

Throws:

SFException

convertToTime

@SnowflakeJdbcInternalApi
public Time convertToTime(Object object,
                          int scale)
                   throws SFException

Overrides:

convertToTime in class SFBaseResultSet

Throws:

SFException

convertToTimestamp

@SnowflakeJdbcInternalApi
public Timestamp convertToTimestamp(Object object,
                                    int columnType,
                                    int columnSubType,
                                    TimeZone tz,
                                    int scale)
                             throws SFException

Overrides:

convertToTimestamp in class SFBaseResultSet

Throws:

SFException

getConverters

@SnowflakeJdbcInternalApi
public Converters getConverters()

Overrides:

getConverters in class SFBaseResultSet