![]() Version: 9.4.4.v20170414 |
private support for your internal/customer projects ... custom extensions and distributions ... versioned snapshots for indefinite support ... scalability guidance for your apps and Ajax/Comet projects ... development services for sponsored feature development
When using the Jetty distribution, you will first need to enable the session-store-jdbc
module for your Jetty base using the --add-to-start
argument on the command line.
$ java -jar ../start.jar --create-startd INFO : Base directory was modified $ java -jar ../start.jar --add-to-start=session-store-jdbc INFO : server transitively enabled, ini template available with --add-to-start=server INFO : sessions transitively enabled, ini template available with --add-to-start=sessions INFO : sessions/jdbc/datasource dynamic dependency of session-store-jdbc INFO : session-store-jdbc initialized in ${jetty.base}/start.d/session-store-jdbc.ini INFO : Base directory was modified
Doing this enables the JDBC Session module and any dependent modules or files needed for it to run on the server.
The example above is running an fresh ${jetty.base}
with nothing enabled.
When the --add-to-start
argument was added to the command line, it enabled the the session-store-jdbc
module as well as the sessions
and server
modules, which are required for JDBC session management to operate.
In addition to adding these modules to the classpath of the server it also added several ini configuration files to the start.d
directory of the ${jetty.base}
.
Opening the start.d/session-store-jdbc.ini
will show a list of all the configurable options for the JDBC module:
# --------------------------------------- # Module: session-store-jdbc # Enables JDBC peristent/distributed session storage. # --------------------------------------- --module=session-store-jdbc ## ##JDBC Session properties ## #jetty.session.gracePeriod.seconds=3600 ## Connection type:Datasource db-connection-type=datasource #jetty.session.jdbc.datasourceName=/jdbc/sessions ## Connection type:driver #db-connection-type=driver #jetty.session.jdbc.driverClass= #jetty.session.jdbc.driverUrl= ## Session table schema #jetty.session.jdbc.schema.accessTimeColumn=accessTime #jetty.session.jdbc.schema.contextPathColumn=contextPath #jetty.session.jdbc.schema.cookieTimeColumn=cookieTime #jetty.session.jdbc.schema.createTimeColumn=createTime #jetty.session.jdbc.schema.expiryTimeColumn=expiryTime #jetty.session.jdbc.schema.lastAccessTimeColumn=lastAccessTime #jetty.session.jdbc.schema.lastSavedTimeColumn=lastSavedTime #jetty.session.jdbc.schema.idColumn=sessionId #jetty.session.jdbc.schema.lastNodeColumn=lastNode #jetty.session.jdbc.schema.virtualHostColumn=virtualHost #jetty.session.jdbc.schema.maxIntervalColumn=maxInterval #jetty.session.jdbc.schema.mapColumn=map #jetty.session.jdbc.schema.table=JettySessions
datasource
or driver
depending on the type of connection being used.com.mysql.jdbc.Driver
jdbc:mysql://127.0.0.1:3306/sessions?user=sessionsadmin
.The jetty.sessionTableSchema
values represent the names for the columns in the JDBC database and can be changed to suit your environment.