Package com.databricks.jdbc.api

Interface IDatabricksResultSet

All Superinterfaces:

AutoCloseable, ResultSet, Wrapper

All Known Implementing Classes:

DatabricksResultSet, EmptyResultSet

public interface IDatabricksResultSet
extends ResultSet

Extension to java.sql.ResultSet interface

Field Summary

Fields inherited from interface java.sql.ResultSet

CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE

Method Summary

Modifier and Type	Method	Description
Map<String,Object>	getMap(int columnIndex)	Retrieves the SQL `Map` from the specified column index in the result set.
Map<String,Object>	getMap(String columbLabel)
String	getStatementId()	Returns statement-Id of associated statement
com.databricks.sdk.service.sql.StatementStatus	getStatementStatus()	Fetches Statement status for underlying statement
Struct	getStruct(int columnIndex)	Retrieves the SQL `Struct` from the specified column index in the result set.
Struct	getStruct(String columnLabel)
long	getUpdateCount()	Returns update count for underlying statement execution.
boolean	hasUpdateCount()	Checks if there is an update count for underlying statement execution

Methods inherited from interface java.sql.ResultSet

absolute, afterLast, beforeFirst, cancelRowUpdates, clearWarnings, close, deleteRow, findColumn, first, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getConcurrency, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getFetchDirection, getFetchSize, getFloat, getFloat, getHoldability, getInt, getInt, getLong, getLong, getMetaData, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getObject, getObject, getRef, getRef, getRow, getRowId, getRowId, getShort, getShort, getSQLXML, getSQLXML, getStatement, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, insertRow, isAfterLast, isBeforeFirst, isClosed, isFirst, isLast, last, moveToCurrentRow, moveToInsertRow, next, previous, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setFetchDirection, setFetchSize, updateArray, updateArray, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateClob, updateClob, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, updateRef, updateRef, updateRow, updateRowId, updateRowId, updateShort, updateShort, updateSQLXML, updateSQLXML, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp, wasNull

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Method Detail

getStruct

Struct getStruct(String columnLabel)
          throws SQLException

Throws:

SQLException

getMap

Map<String,Object> getMap(String columbLabel)
                         throws SQLException

Throws:

SQLException

getStatementId

String getStatementId()

Returns statement-Id of associated statement

Returns:

statement-Id

getStatementStatus

com.databricks.sdk.service.sql.StatementStatus getStatementStatus()

Fetches Statement status for underlying statement

Returns:

statement status

getUpdateCount

long getUpdateCount()
             throws SQLException

Returns update count for underlying statement execution. Returns 0 for a query statement.

Returns:

update count

Throws:

SQLException

hasUpdateCount

boolean hasUpdateCount()
                throws SQLException

Checks if there is an update count for underlying statement execution

Returns:

true for DML commands

Throws:

SQLException

getMap

Map<String,Object> getMap(int columnIndex)
                         throws SQLException

Retrieves the SQL `Map` from the specified column index in the result set.

Parameters:

columnIndex - the index of the column in the result set (1-based)

Returns:

a `Map` if the column contains a map; `null` if the value is SQL `NULL`

Throws:

SQLException - if the column is not of `MAP` type or if any SQL error occurs

getStruct

Struct getStruct(int columnIndex)
          throws SQLException

Retrieves the SQL `Struct` from the specified column index in the result set.

Parameters:

columnIndex - the index of the column in the result set (1-based)

Returns:

a `Struct` object if the column contains a struct; `null` if the value is SQL `NULL`

Throws:

SQLException - if the column is not of `STRUCT` type or if any SQL error occurs