Session

An occurrence of a user interacting with a database through the use of SQL statements.

An occurrence of a user interacting with a database through the use of SQL statements. You can start a session using vsql or a JDBC application. When a database is configured for TLS/SSL security in server mode, incoming client requests do verify the certificate of the server, but the server does not verify the clients. In OpenText™ Analytics Database, the server is the database server and the client is any database user who logs into the database. The database client user may log in to the database directly in a command window, or may connect to the database server via the Management Console running in a browser. The scope of a session is the same as that of a connection. Connecting to the database starts a session and exiting ends it.

Session-scoped data is preserved beyond the lifetime of a single transaction. Terminating a session truncates a table and deletes all rows.