Using the URL to manage a session

In a URL session state management system, the client application or web browser provides the session ID in a URL.

Example

The following example illustrates unique session ID creation within an HTTP web server SQL function where session IDs can be provided by a URL only:

CREATE OR REPLACE FUNCTION set_session()
RETURNS LONG VARCHAR
BEGIN
    DECLARE session_id LONG VARCHAR;
    DECLARE tm TIMESTAMP;
    SET tm=now(*);
    SET session_id = 'session_' ||
    CONVERT( VARCHAR, SECONDS(tm)*1000+DATEPART(millisecond,tm));
    CALL sa_set_http_option('SessionID', session_id);
    SELECT CONNECTION_PROPERTY( 'SessionID' ) INTO session_id;
    RETURN( session_id );
END;

The SessionID is represented as an empty string if the session_id is not defined for the connection, making a sessionless connection.

The sa_set_http_option system procedure returns an error if the session_id is owned by another HTTP request. For more information about error codes, see Web service error code reference.

Using the URL to manage a session

Example

See also