Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Summary of session connection properties and options

• SessionID  

  SELECT CONNECTION_PROPERTY('SessionID') INTO ses_id;

  Provides the current session ID within the current database context.

• SessionCreateTime  

  SELECT CONNECTION_PROPERTY('SessionCreateTime') INTO ses_create;

  Provides the timestamp of when the session was created.

• SessionLastTime  

  SELECT CONNECTION_PROPERTY('SessionLastTime') INTO ses_last;

  Provides timestamp of when the session was released by the last request.

• http_session_timeout  

  SELECT CONNECTION_PROPERTY('http_session_timeout') INTO ses_timeout;

  Fetches the current session timeout in units of minutes.

• 'SessionID','value'  

  CALL sa_set_http_option( 'SessionID', 'my_app_session_1' )

  Create or change a session context for the current HTTP request. Returns an error if my_app_session_1 is owned by another HTTP request.

• 'SessionID', NULL  

  CALL sa_set_http_option('SessionID', NULL )

  If the request comes from the session creator, the current session is deleted immediately; otherwise, the session is marked for deletion. Deleting a session when the request has no session is not an error and has no effect.
  Changing a session to a SessionID of the current session (has no pending session) - Not an error, no operation.
  Changing a session to a SessionID in use by another HTTP request - Error.
  Changing a session when a change is already pending - delete pending session, create new pending session.
  Changing a session with a pending session back to its original SessionID - delete pending session.

• http_session_timeout  

  SET TEMPORARY OPTION PUBLIC.http_session_timeout=100;

  Sets the current HTTP session timeout (in minutes). The default is 30 and the range is 1 to 525600 minutes (365 days) .
  See http_session_timeout option [database].