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) is not an error and has no substantial effect.
Changing a session to a SessionID in use by another HTTP request is an error.
Changing a session when a change is already pending results in the pending session being deleted and new pending session being created.
Changing a session with a pending session back to its original SessionID results in the pending session being deleted.
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].
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |