Column | Data Type | Description |
SESSION_ID | INTEGER, NOT NULL | A unique ID that identifies this session. The system function CURSESSIONID( ) returns the session ID associated with the connection. Refer to "Functions" in the DataDirect Connect Series for JDBC Reference for more information about the CURSESSIONID() system function. |
CONNECTED | DATETIME, NOT NULL | The date and time the session was established. |
USERNAME | VARCHAR (128), NOT NULL | The name of the embedded database that the session is using. |
IS_ADMIN | BOOLEAN | For internal use only. |
AUTOCOMMIT | BOOLEAN, NOT NULL | For future use. |
READONLY | BOOLEAN, NOT NULL | True if the connection is in read-only mode. The READONLY status is based on whether the connection has been explicitly set to read-only mode by the ReadOnly connection option or the Connection.setReadOnly() method. |
MAX_ROWS | INTEGER, NOT NULL | For future use. |
LAST_IDENTITY | BIGINT, NULLABLE | For future use. |
TRANSACTION_SIZE | INTEGER, NOT NULL | For future use. |
CURRENT_SCHEMA | VARCHAR (128), NOT NULL | The current schema for the session. The current schema may be changed using the ALTER SESSION SET CURRENT_SCHEMA statement. |
STMT_CALL_LIMIT | INTEGER, NOT NULL | The maximum number of Web service calls that the driver uses in attempting to execute a query to a remote data source. The statement call limit for the session may be changed via the ALTER SESSION SET STMT_CALL_LIMIT statement. |