| Element | Description | Class |
|---|---|---|
| datasource-store | A DB session store that uses a DataSource to obtain connections to the DB server. The only configuration property specific to this implementation is the datasource JNDI name. See DbSessionStore for more configuration details. | org.josso.gateway.session.service.store.db.DataSourceSessionStore |
| jdbc-store | This DB Session store obtains DB connections directly from the JDBC Driver. | org.josso.gateway.session.service.store.db.JdbcSessionStore |
| Attribute | Type | Description |
|---|---|---|
| deleteAllDml | xs:string | The SQL Query used to remove ALL sessions from the store. |
| deleteDml | xs:string | The SQL Query used to remove a session from the store. |
| dsJndiName | xs:string | Sets the JNDI name of the DS associated to this Store. |
| insertDml | xs:string | The SQL Query used to add a new session to the store. |
| keysQuery | xs:string | The SQL Query used to retrieve all session ids. The first column for each row in the result set must be the session id. |
| loadAllQuery | xs:string | The SQL Query used to load all sessions from the store.
The columns in the result set must be in the following order : sessionId, userName, creationTime, lastAccessTime, accessCount, maxInactiveInterval, valid |
| loadByLastAccessTimeQuery | xs:string | The SQL Query used to load all sessions last accessed before the given date.
The columns in the result set must be in the following order : sessionId, userName, creationTime, lastAccessTime, accessCount, maxInactiveInterval, valid |
| loadByUserNameQuery | xs:string | The SQL Query used to load all sessions associated to a given user.
The columns in the result set must be in the following order : sessionId, userName, creationTime, lastAccessTime, accessCount, maxInactiveInterval, valid |
| loadByValidQuery | xs:string | The SQL Query used to load all sessions whose valid property is equals to the given valid.
The columns in the result set must be in the following order : sessionId, userName, creationTime, lastAccessTime, accessCount, maxInactiveInterval, valid |
| loadQuery | xs:string | The SQL Query used to load one session from the store based on its id.
The columns in the result set must be in the following order : sessionId, userName, creationTime, lastAccessTime, accessCount, maxInactiveInterval, valid example : SELECT sessionId, userName, creationTime, lastAccessTime, accessCount, maxInactiveInterval, valid FROM JOSSO_SESSION WHERE sessionId = ? |
| sizeQuery | xs:string | The SQL query used to retrieve the number of sessions in the store. The first column of the first row in the result set must be the number of sessions. |
| updateDml | xs:string | The SQL Query used to add a new session to the store. |
| Attribute | Type | Description |
|---|---|---|
| connectionName | xs:string | |
| connectionPassword | xs:string | |
| connectionURL | xs:string | |
| deleteAllDml | xs:string | The SQL Query used to remove ALL sessions from the store. |
| deleteDml | xs:string | The SQL Query used to remove a session from the store. |
| driverName | xs:string | |
| insertDml | xs:string | The SQL Query used to add a new session to the store. |
| keysQuery | xs:string | The SQL Query used to retrieve all session ids. The first column for each row in the result set must be the session id. |
| loadAllQuery | xs:string | The SQL Query used to load all sessions from the store.
The columns in the result set must be in the following order : sessionId, userName, creationTime, lastAccessTime, accessCount, maxInactiveInterval, valid |
| loadByLastAccessTimeQuery | xs:string | The SQL Query used to load all sessions last accessed before the given date.
The columns in the result set must be in the following order : sessionId, userName, creationTime, lastAccessTime, accessCount, maxInactiveInterval, valid |
| loadByUserNameQuery | xs:string | The SQL Query used to load all sessions associated to a given user.
The columns in the result set must be in the following order : sessionId, userName, creationTime, lastAccessTime, accessCount, maxInactiveInterval, valid |
| loadByValidQuery | xs:string | The SQL Query used to load all sessions whose valid property is equals to the given valid.
The columns in the result set must be in the following order : sessionId, userName, creationTime, lastAccessTime, accessCount, maxInactiveInterval, valid |
| loadQuery | xs:string | The SQL Query used to load one session from the store based on its id.
The columns in the result set must be in the following order : sessionId, userName, creationTime, lastAccessTime, accessCount, maxInactiveInterval, valid example : SELECT sessionId, userName, creationTime, lastAccessTime, accessCount, maxInactiveInterval, valid FROM JOSSO_SESSION WHERE sessionId = ? |
| sizeQuery | xs:string | The SQL query used to retrieve the number of sessions in the store. The first column of the first row in the result set must be the number of sessions. |
| updateDml | xs:string | The SQL Query used to add a new session to the store. |