Element Summary

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

Element Detail

Element: datasource-store

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.

Element: jdbc-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.