net.snowflake.client.core

Class SFSession

java.lang.Object

net.snowflake.client.core.SFSession

public class SFSession
extends Object

Snowflake session implementation

Author:

jhuang

Field Summary

Fields

Modifier and Type	Field and Description
static String	SF_HEADER_AUTHORIZATION
static String	SF_HEADER_BASIC_AUTHTYPE
static String	SF_HEADER_SNOWFLAKE_AUTHTYPE
static String	SF_HEADER_TOKEN_TAG
static String	SF_QUERY_REQUEST_ID

Constructor Summary

Constructors

Constructor and Description
SFSession()

Method Summary

Modifier and Type	Method and Description
void	addProperty(String propertyName, Object propertyValue) Add a property If a property is known for connection, add it to connection properties If not, add it as a dynamic session parameters Make sure a property is not added more than once and the number of properties does not exceed limit.
void	close() Close the connection
protected int	getAndIncrementSequenceId()
boolean	getAutoCommit()
Properties	getClientInfo()
String	getClientInfo(String name)
String	getDatabase()
int	getDatabaseMajorVersion()
int	getDatabaseMinorVersion()
String	getDatabaseVersion()
protected org.apache.http.client.HttpClient	getHttpClient()
protected int	getHttpClientConnectionTimeout()
protected int	getHttpClientSocketTimeout()
int	getInjectClientPause()
String	getInjectFileUploadFailure()
int	getInjectSocketTimeout()
boolean	getMetadataRequestUseConnectionCtx()
protected int	getNetworkTimeoutInMilli()
String	getNewClientForUpdate()
String	getRole()
boolean	getRsColumnCaseInsensitive()
String	getSchema()
protected String	getServerUrl()
protected String	getSessionToken() get session token
Object	getSFSessionProperty(String propertyName)
SnowflakeType	getTimestampMappedType()
protected void	heartbeat() Send heartbeat for the session
protected boolean	isClosed()
boolean	isEnableHeartbeat()
boolean	isExecuteReturnCountForDML()
protected boolean	isUseProxy()
void	open() Open a new database session
void	setAutoCommit(boolean autoCommit)
void	setClientInfo(Properties properties)
void	setClientInfo(String name, String value)
void	setDatabase(String database)
void	setEnableHeartbeat(boolean enableHeartbeat)
void	setExecuteReturnCountForDML(boolean executeReturnCountForDML)
void	setInjectClientPause(int injectClientPause)
void	setInjectedDelay(int delay)
void	setInjectFileUploadFailure(String fileToFail)
void	setInjectSocketTimeout(int injectSocketTimeout)
void	setMetadataRequestUseConnectionCtx(boolean enabled)
void	setRole(String role)
void	setRsColumnCaseInsensitive(boolean rsColumnCaseInsensitive)
void	setSchema(String schema)
void	setTimestampMappedType(SnowflakeType timestampMappedType)
protected void	startHeartbeatForThisSession() Start heartbeat for this session
protected void	stopHeartbeatForThisSession() Stop heartbeat for this session

Methods inherited from class java.lang.Object

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

Field Detail

SF_QUERY_REQUEST_ID

public static final String SF_QUERY_REQUEST_ID

See Also:

Constant Field Values

SF_HEADER_AUTHORIZATION

public static final String SF_HEADER_AUTHORIZATION

See Also:

Constant Field Values

SF_HEADER_BASIC_AUTHTYPE

public static final String SF_HEADER_BASIC_AUTHTYPE

See Also:

Constant Field Values

SF_HEADER_SNOWFLAKE_AUTHTYPE

public static final String SF_HEADER_SNOWFLAKE_AUTHTYPE

See Also:

Constant Field Values

SF_HEADER_TOKEN_TAG

public static final String SF_HEADER_TOKEN_TAG

See Also:

Constant Field Values

Constructor Detail

SFSession

public SFSession()

Method Detail

addProperty

public void addProperty(String propertyName,
                        Object propertyValue)
                 throws SFException

Add a property If a property is known for connection, add it to connection properties If not, add it as a dynamic session parameters Make sure a property is not added more than once and the number of properties does not exceed limit.

Parameters:

propertyName - property name

propertyValue - property value

Throws:

SFException - exception raised from Snowflake components

getServerUrl

protected String getServerUrl()

open

public void open()
          throws SFException,
                 SnowflakeSQLException

Open a new database session

Throws:

SFException - this is a runtime exception

SnowflakeSQLException - exception raised from Snowfalke components

getHttpClient

protected org.apache.http.client.HttpClient getHttpClient()

getNewClientForUpdate

public String getNewClientForUpdate()

getDatabaseVersion

public String getDatabaseVersion()

getDatabaseMajorVersion

public int getDatabaseMajorVersion()

getDatabaseMinorVersion

public int getDatabaseMinorVersion()

getSessionToken

protected String getSessionToken()

get session token

Returns:

session token

close

public void close()
           throws SFException,
                  SnowflakeSQLException

Close the connection

Throws:

SnowflakeSQLException - if failed to close the connection

SFException - if failed to close the connection

startHeartbeatForThisSession

protected void startHeartbeatForThisSession()

Start heartbeat for this session

stopHeartbeatForThisSession

protected void stopHeartbeatForThisSession()

Stop heartbeat for this session

heartbeat

protected void heartbeat()
                  throws SFException,
                         SQLException

Send heartbeat for the session

Throws:

SFException - exception raised from Snowflake

SQLException - exception raised from SQL generic layers

setClientInfo

public void setClientInfo(Properties properties)
                   throws SQLClientInfoException

Throws:

SQLClientInfoException

setClientInfo

public void setClientInfo(String name,
                          String value)
                   throws SQLClientInfoException

Throws:

SQLClientInfoException

getClientInfo

public Properties getClientInfo()

getClientInfo

public String getClientInfo(String name)

getSFSessionProperty

public Object getSFSessionProperty(String propertyName)

setInjectedDelay

public void setInjectedDelay(int delay)

getInjectSocketTimeout

public int getInjectSocketTimeout()

setInjectSocketTimeout

public void setInjectSocketTimeout(int injectSocketTimeout)

setInjectFileUploadFailure

public void setInjectFileUploadFailure(String fileToFail)

getInjectFileUploadFailure

public String getInjectFileUploadFailure()

getNetworkTimeoutInMilli

protected int getNetworkTimeoutInMilli()

isClosed

protected boolean isClosed()

getInjectClientPause

public int getInjectClientPause()

setInjectClientPause

public void setInjectClientPause(int injectClientPause)

getHttpClientConnectionTimeout

protected int getHttpClientConnectionTimeout()

getHttpClientSocketTimeout

protected int getHttpClientSocketTimeout()

isUseProxy

protected boolean isUseProxy()

getAndIncrementSequenceId

protected int getAndIncrementSequenceId()

setExecuteReturnCountForDML

public void setExecuteReturnCountForDML(boolean executeReturnCountForDML)

isExecuteReturnCountForDML

public boolean isExecuteReturnCountForDML()

isEnableHeartbeat

public boolean isEnableHeartbeat()

setEnableHeartbeat

public void setEnableHeartbeat(boolean enableHeartbeat)

getAutoCommit

public boolean getAutoCommit()

setAutoCommit

public void setAutoCommit(boolean autoCommit)

setRsColumnCaseInsensitive

public void setRsColumnCaseInsensitive(boolean rsColumnCaseInsensitive)

getRsColumnCaseInsensitive

public boolean getRsColumnCaseInsensitive()

getDatabase

public String getDatabase()

setDatabase

public void setDatabase(String database)

getSchema

public String getSchema()

setSchema

public void setSchema(String schema)

getRole

public String getRole()

setRole

public void setRole(String role)

setMetadataRequestUseConnectionCtx

public void setMetadataRequestUseConnectionCtx(boolean enabled)

getMetadataRequestUseConnectionCtx

public boolean getMetadataRequestUseConnectionCtx()

getTimestampMappedType

public SnowflakeType getTimestampMappedType()

setTimestampMappedType

public void setTimestampMappedType(SnowflakeType timestampMappedType)