Element Summary

ElementDescriptionClass
datasource-storeA 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-storeThis DB Session store obtains DB connections directly from the JDBC Driver.org.josso.gateway.session.service.store.db.JdbcSessionStore

Element Detail

Element: datasource-store

AttributeTypeDescription
deleteAllDmlxs:stringThe SQL Query used to remove ALL sessions from the store.
deleteDmlxs:stringThe SQL Query used to remove a session from the store.
dsJndiNamexs:stringSets the JNDI name of the DS associated to this Store.
insertDmlxs:stringThe SQL Query used to add a new session to the store.
keysQueryxs:stringThe SQL Query used to retrieve all session ids. The first column for each row in the result set must be the session id.
loadAllQueryxs:stringThe 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

loadByLastAccessTimeQueryxs:stringThe 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

loadByUserNameQueryxs:stringThe 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

loadByValidQueryxs:stringThe 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

loadQueryxs:stringThe 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 = ?

sizeQueryxs:stringThe 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.
updateDmlxs:stringThe SQL Query used to add a new session to the store.

Element: jdbc-store

AttributeTypeDescription
connectionNamexs:string
connectionPasswordxs:string
connectionURLxs:string
deleteAllDmlxs:stringThe SQL Query used to remove ALL sessions from the store.
deleteDmlxs:stringThe SQL Query used to remove a session from the store.
driverNamexs:string
insertDmlxs:stringThe SQL Query used to add a new session to the store.
keysQueryxs:stringThe SQL Query used to retrieve all session ids. The first column for each row in the result set must be the session id.
loadAllQueryxs:stringThe 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

loadByLastAccessTimeQueryxs:stringThe 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

loadByUserNameQueryxs:stringThe 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

loadByValidQueryxs:stringThe 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

loadQueryxs:stringThe 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 = ?

sizeQueryxs:stringThe 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.
updateDmlxs:stringThe SQL Query used to add a new session to the store.