{"action":"created","comment":{"url":"https://api.github.com/repos/eclipse/jetty.project/pulls/comments/74867395","id":74867395,"diff_hunk":"@@ -0,0 +1,114 @@\n+//  ========================================================================\n+//  Copyright (c) 1995-2016 Mort Bay Consulting Pty. Ltd.\n+//  ========================================================================\n+//  All rights reserved. This program and the accompanying materials\n+//  are made available under the terms of the Eclipse Public License v1.0\n+//  and Apache License v2.0 which accompanies this distribution.\n+//\n+//      The Eclipse Public License is available at\n+//      http://www.eclipse.org/legal/epl-v10.html\n+//\n+//      The Apache License v2.0 is available at\n+//      http://www.opensource.org/licenses/apache2.0.php\n+//\n+//  You may elect to redistribute this code under either of these licenses.\n+//  ========================================================================\n+\n+[[configuring-sessions-jdbc]]\n+\n+=== Configuring JDBC Clustering\n+\n+When using the Jetty distribution, you will first need to enable the `session-store-jdbc` link:#startup-modules[module] for your link:#startup-base-and-home[Jetty base] using the `--add-to-start` argument on the command line.\n+\n+[source, screen, subs=\"{sub-order}\"]\n+----\n+$ java -jar ../start.jar --add-to-start=session-store-jdbc\n+INFO : server          initialised (transitively) in ${jetty.base}/start.d/server.ini\n+INFO : sessions        initialised (transitively) in ${jetty.base}/start.d/sessions.ini\n+INFO : session-store-jdbc initialised in ${jetty.base}/start.d/session-store-jdbc.ini\n+INFO : Base directory was modified\n+----\n+\n+Doing this enables the JDBC Session module and any dependent modules or files needed for it to run on the server.\n+The example above is running an fresh `{$jetty.base}` with nothing enabled.\n+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.\n+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}`.\n+\n+Opening the `start.d/session-store-jdbc.ini` will show a list of all the configurable options for the JDBC module:\n+\n+[source, screen, subs=\"{sub-order}\"]\n+----\n+# ---------------------------------------\n+# Module: session-store-jdbc\n+# Enables JDBC peristent/distributed session storage.\n+# ---------------------------------------\n+--module=session-store-jdbc\n+\n+##\n+##JDBC Session properties\n+##\n+\n+#jetty.session.gracePeriod.seconds=3600\n+\n+## Connection type:Datasource\n+db-connection-type=datasource\n+#jetty.session.datasourceName=/jdbc/sessions\n+\n+## Connection type:driver\n+#db-connection-type=driver\n+#jetty.session.driverClass=\n+#jetty.session.driverUrl=\n+\n+## Session table schema\n+#jetty.sessionTableSchema.accessTimeColumn=accessTime\n+#jetty.sessionTableSchema.contextPathColumn=contextPath\n+#jetty.sessionTableSchema.cookieTimeColumn=cookieTime\n+#jetty.sessionTableSchema.createTimeColumn=createTime\n+#jetty.sessionTableSchema.expiryTimeColumn=expiryTime\n+#jetty.sessionTableSchema.lastAccessTimeColumn=lastAccessTime\n+#jetty.sessionTableSchema.lastSavedTimeColumn=lastSavedTime\n+#jetty.sessionTableSchema.idColumn=sessionId\n+#jetty.sessionTableSchema.lastNodeColumn=lastNode\n+#jetty.sessionTableSchema.virtualHostColumn=virtualHost\n+#jetty.sessionTableSchema.maxIntervalColumn=maxInterval\n+#jetty.sessionTableSchema.mapColumn=map\n+#jetty.sessionTableSchema.table=JettySessions\n+----\n+\n+jetty.session.gracePeriod.seconds::\n+\n+db-connection-type::\n+jetty.session.datasourceName::\n+\n+db-connection-type::\n+jetty.session.driverClass::\n+jetty.session.driverUrl::\n+\n+jetty.sessionTableSchema.accessTimeColumn::\n+jetty.sessionTableSchema.contextPathColumn::\n+jetty.sessionTableSchema.cookieTimeColumn::\n+jetty.sessionTableSchema.createTimeColumn::\n+jetty.sessionTableSchema.expiryTimeColumn::\n+jetty.sessionTableSchema.lastAccessTimeColumn::\n+jetty.sessionTableSchema.lastSavedTimeColumn::\n+jetty.sessionTableSchema.idColumn::\n+jetty.sessionTableSchema.lastNodeColumn::\n+jetty.sessionTableSchema.virtualHostColumn::\n+jetty.sessionTableSchema.maxIntervalColumn::\n+jetty.sessionTableSchema.mapColumn::\n+jetty.sessionTableSchema.table::\n+","path":"jetty-documentation/src/main/asciidoc/administration/sessions/session-configuration-jdbc.adoc","position":100,"original_position":100,"commit_id":"405de2db8fc9cf64d88b46457b7de98d6b4e9ee2","original_commit_id":"405de2db8fc9cf64d88b46457b7de98d6b4e9ee2","user":{"login":"WalkerWatch","id":1237580,"avatar_url":"https://avatars.githubusercontent.com/u/1237580?v=3","gravatar_id":"","url":"https://api.github.com/users/WalkerWatch","html_url":"https://github.com/WalkerWatch","followers_url":"https://api.github.com/users/WalkerWatch/followers","following_url":"https://api.github.com/users/WalkerWatch/following{/other_user}","gists_url":"https://api.github.com/users/WalkerWatch/gists{/gist_id}","starred_url":"https://api.github.com/users/WalkerWatch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/WalkerWatch/subscriptions","organizations_url":"https://api.github.com/users/WalkerWatch/orgs","repos_url":"https://api.github.com/users/WalkerWatch/repos","events_url":"https://api.github.com/users/WalkerWatch/events{/privacy}","received_events_url":"https://api.github.com/users/WalkerWatch/received_events","type":"User","site_admin":false},"body":"They are, yeah. I left them in temporarily in case we wanted to draw anything from them.","created_at":"2016-08-16T02:15:29Z","updated_at":"2016-08-16T02:15:29Z","html_url":"https://github.com/eclipse/jetty.project/pull/838#discussion_r74867395","pull_request_url":"https://api.github.com/repos/eclipse/jetty.project/pulls/838","_links":{"self":{"href":"https://api.github.com/repos/eclipse/jetty.project/pulls/comments/74867395"},"html":{"href":"https://github.com/eclipse/jetty.project/pull/838#discussion_r74867395"},"pull_request":{"href":"https://api.github.com/repos/eclipse/jetty.project/pulls/838"}}},"pull_request":{"url":"https://api.github.com/repos/eclipse/jetty.project/pulls/838","id":81152359,"html_url":"https://github.com/eclipse/jetty.project/pull/838","diff_url":"https://github.com/eclipse/jetty.project/pull/838.diff","patch_url":"https://github.com/eclipse/jetty.project/pull/838.patch","issue_url":"https://api.github.com/repos/eclipse/jetty.project/issues/838","number":838,"state":"open","locked":false,"title":"Sessions redux rough drafts.","user":{"login":"WalkerWatch","id":1237580,"avatar_url":"https://avatars.githubusercontent.com/u/1237580?v=3","gravatar_id":"","url":"https://api.github.com/users/WalkerWatch","html_url":"https://github.com/WalkerWatch","followers_url":"https://api.github.com/users/WalkerWatch/followers","following_url":"https://api.github.com/users/WalkerWatch/following{/other_user}","gists_url":"https://api.github.com/users/WalkerWatch/gists{/gist_id}","starred_url":"https://api.github.com/users/WalkerWatch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/WalkerWatch/subscriptions","organizations_url":"https://api.github.com/users/WalkerWatch/orgs","repos_url":"https://api.github.com/users/WalkerWatch/repos","events_url":"https://api.github.com/users/WalkerWatch/events{/privacy}","received_events_url":"https://api.github.com/users/WalkerWatch/received_events","type":"User","site_admin":false},"body":"Signed-off-by: WalkerWatch <ctwalker@gmail.com>\r\n\r\nAlpha version of doc updates for Sessions. These only focus on distribution implementations. @janbartel Can you help weigh in on the different options in the ini files for the modules? \r\n\r\nI will continue to push updates to this PR.","created_at":"2016-08-12T17:12:00Z","updated_at":"2016-08-16T02:15:29Z","closed_at":null,"merged_at":null,"merge_commit_sha":"2a663c05bfde75460040f3067ed5f9bf4024109d","assignee":null,"assignees":[],"milestone":null,"commits_url":"https://api.github.com/repos/eclipse/jetty.project/pulls/838/commits","review_comments_url":"https://api.github.com/repos/eclipse/jetty.project/pulls/838/comments","review_comment_url":"https://api.github.com/repos/eclipse/jetty.project/pulls/comments{/number}","comments_url":"https://api.github.com/repos/eclipse/jetty.project/issues/838/comments","statuses_url":"https://api.github.com/repos/eclipse/jetty.project/statuses/405de2db8fc9cf64d88b46457b7de98d6b4e9ee2","head":{"label":"WalkerWatch:docupdates/Sessions","ref":"docupdates/Sessions","sha":"405de2db8fc9cf64d88b46457b7de98d6b4e9ee2","user":{"login":"WalkerWatch","id":1237580,"avatar_url":"https://avatars.githubusercontent.com/u/1237580?v=3","gravatar_id":"","url":"https://api.github.com/users/WalkerWatch","html_url":"https://github.com/WalkerWatch","followers_url":"https://api.github.com/users/WalkerWatch/followers","following_url":"https://api.github.com/users/WalkerWatch/following{/other_user}","gists_url":"https://api.github.com/users/WalkerWatch/gists{/gist_id}","starred_url":"https://api.github.com/users/WalkerWatch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/WalkerWatch/subscriptions","organizations_url":"https://api.github.com/users/WalkerWatch/orgs","repos_url":"https://api.github.com/users/WalkerWatch/repos","events_url":"https://api.github.com/users/WalkerWatch/events{/privacy}","received_events_url":"https://api.github.com/users/WalkerWatch/received_events","type":"User","site_admin":false},"repo":{"id":63431196,"name":"jetty.project","full_name":"WalkerWatch/jetty.project","owner":{"login":"WalkerWatch","id":1237580,"avatar_url":"https://avatars.githubusercontent.com/u/1237580?v=3","gravatar_id":"","url":"https://api.github.com/users/WalkerWatch","html_url":"https://github.com/WalkerWatch","followers_url":"https://api.github.com/users/WalkerWatch/followers","following_url":"https://api.github.com/users/WalkerWatch/following{/other_user}","gists_url":"https://api.github.com/users/WalkerWatch/gists{/gist_id}","starred_url":"https://api.github.com/users/WalkerWatch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/WalkerWatch/subscriptions","organizations_url":"https://api.github.com/users/WalkerWatch/orgs","repos_url":"https://api.github.com/users/WalkerWatch/repos","events_url":"https://api.github.com/users/WalkerWatch/events{/privacy}","received_events_url":"https://api.github.com/users/WalkerWatch/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/WalkerWatch/jetty.project","description":"Eclipse Jetty - Web Container & Clients - supports HTTP/2, HTTP/1.1, HTTP/1.0, websocket, servlets, and more","fork":true,"url":"https://api.github.com/repos/WalkerWatch/jetty.project","forks_url":"https://api.github.com/repos/WalkerWatch/jetty.project/forks","keys_url":"https://api.github.com/repos/WalkerWatch/jetty.project/keys{/key_id}","collaborators_url":"https://api.github.com/repos/WalkerWatch/jetty.project/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/WalkerWatch/jetty.project/teams","hooks_url":"https://api.github.com/repos/WalkerWatch/jetty.project/hooks","issue_events_url":"https://api.github.com/repos/WalkerWatch/jetty.project/issues/events{/number}","events_url":"https://api.github.com/repos/WalkerWatch/jetty.project/events","assignees_url":"https://api.github.com/repos/WalkerWatch/jetty.project/assignees{/user}","branches_url":"https://api.github.com/repos/WalkerWatch/jetty.project/branches{/branch}","tags_url":"https://api.github.com/repos/WalkerWatch/jetty.project/tags","blobs_url":"https://api.github.com/repos/WalkerWatch/jetty.project/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/WalkerWatch/jetty.project/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/WalkerWatch/jetty.project/git/refs{/sha}","trees_url":"https://api.github.com/repos/WalkerWatch/jetty.project/git/trees{/sha}","statuses_url":"https://api.github.com/repos/WalkerWatch/jetty.project/statuses/{sha}","languages_url":"https://api.github.com/repos/WalkerWatch/jetty.project/languages","stargazers_url":"https://api.github.com/repos/WalkerWatch/jetty.project/stargazers","contributors_url":"https://api.github.com/repos/WalkerWatch/jetty.project/contributors","subscribers_url":"https://api.github.com/repos/WalkerWatch/jetty.project/subscribers","subscription_url":"https://api.github.com/repos/WalkerWatch/jetty.project/subscription","commits_url":"https://api.github.com/repos/WalkerWatch/jetty.project/commits{/sha}","git_commits_url":"https://api.github.com/repos/WalkerWatch/jetty.project/git/commits{/sha}","comments_url":"https://api.github.com/repos/WalkerWatch/jetty.project/comments{/number}","issue_comment_url":"https://api.github.com/repos/WalkerWatch/jetty.project/issues/comments{/number}","contents_url":"https://api.github.com/repos/WalkerWatch/jetty.project/contents/{+path}","compare_url":"https://api.github.com/repos/WalkerWatch/jetty.project/compare/{base}...{head}","merges_url":"https://api.github.com/repos/WalkerWatch/jetty.project/merges","archive_url":"https://api.github.com/repos/WalkerWatch/jetty.project/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/WalkerWatch/jetty.project/downloads","issues_url":"https://api.github.com/repos/WalkerWatch/jetty.project/issues{/number}","pulls_url":"https://api.github.com/repos/WalkerWatch/jetty.project/pulls{/number}","milestones_url":"https://api.github.com/repos/WalkerWatch/jetty.project/milestones{/number}","notifications_url":"https://api.github.com/repos/WalkerWatch/jetty.project/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/WalkerWatch/jetty.project/labels{/name}","releases_url":"https://api.github.com/repos/WalkerWatch/jetty.project/releases{/id}","deployments_url":"https://api.github.com/repos/WalkerWatch/jetty.project/deployments","created_at":"2016-07-15T15:14:40Z","updated_at":"2016-07-15T15:14:51Z","pushed_at":"2016-08-15T18:02:19Z","git_url":"git://github.com/WalkerWatch/jetty.project.git","ssh_url":"git@github.com:WalkerWatch/jetty.project.git","clone_url":"https://github.com/WalkerWatch/jetty.project.git","svn_url":"https://github.com/WalkerWatch/jetty.project","homepage":"https://www.eclipse.org/jetty","size":87502,"stargazers_count":0,"watchers_count":0,"language":"Java","has_issues":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"jetty-9.3.x"}},"base":{"label":"eclipse:jetty-9.4.x","ref":"jetty-9.4.x","sha":"c5a277079022ed199346549b0e534369c602568d","user":{"login":"eclipse","id":56974,"avatar_url":"https://avatars.githubusercontent.com/u/56974?v=3","gravatar_id":"","url":"https://api.github.com/users/eclipse","html_url":"https://github.com/eclipse","followers_url":"https://api.github.com/users/eclipse/followers","following_url":"https://api.github.com/users/eclipse/following{/other_user}","gists_url":"https://api.github.com/users/eclipse/gists{/gist_id}","starred_url":"https://api.github.com/users/eclipse/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/eclipse/subscriptions","organizations_url":"https://api.github.com/users/eclipse/orgs","repos_url":"https://api.github.com/users/eclipse/repos","events_url":"https://api.github.com/users/eclipse/events{/privacy}","received_events_url":"https://api.github.com/users/eclipse/received_events","type":"Organization","site_admin":false},"repo":{"id":2045207,"name":"jetty.project","full_name":"eclipse/jetty.project","owner":{"login":"eclipse","id":56974,"avatar_url":"https://avatars.githubusercontent.com/u/56974?v=3","gravatar_id":"","url":"https://api.github.com/users/eclipse","html_url":"https://github.com/eclipse","followers_url":"https://api.github.com/users/eclipse/followers","following_url":"https://api.github.com/users/eclipse/following{/other_user}","gists_url":"https://api.github.com/users/eclipse/gists{/gist_id}","starred_url":"https://api.github.com/users/eclipse/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/eclipse/subscriptions","organizations_url":"https://api.github.com/users/eclipse/orgs","repos_url":"https://api.github.com/users/eclipse/repos","events_url":"https://api.github.com/users/eclipse/events{/privacy}","received_events_url":"https://api.github.com/users/eclipse/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/eclipse/jetty.project","description":"Eclipse Jetty - Web Container & Clients - supports HTTP/2, HTTP/1.1, HTTP/1.0, websocket, servlets, and more","fork":false,"url":"https://api.github.com/repos/eclipse/jetty.project","forks_url":"https://api.github.com/repos/eclipse/jetty.project/forks","keys_url":"https://api.github.com/repos/eclipse/jetty.project/keys{/key_id}","collaborators_url":"https://api.github.com/repos/eclipse/jetty.project/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/eclipse/jetty.project/teams","hooks_url":"https://api.github.com/repos/eclipse/jetty.project/hooks","issue_events_url":"https://api.github.com/repos/eclipse/jetty.project/issues/events{/number}","events_url":"https://api.github.com/repos/eclipse/jetty.project/events","assignees_url":"https://api.github.com/repos/eclipse/jetty.project/assignees{/user}","branches_url":"https://api.github.com/repos/eclipse/jetty.project/branches{/branch}","tags_url":"https://api.github.com/repos/eclipse/jetty.project/tags","blobs_url":"https://api.github.com/repos/eclipse/jetty.project/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/eclipse/jetty.project/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/eclipse/jetty.project/git/refs{/sha}","trees_url":"https://api.github.com/repos/eclipse/jetty.project/git/trees{/sha}","statuses_url":"https://api.github.com/repos/eclipse/jetty.project/statuses/{sha}","languages_url":"https://api.github.com/repos/eclipse/jetty.project/languages","stargazers_url":"https://api.github.com/repos/eclipse/jetty.project/stargazers","contributors_url":"https://api.github.com/repos/eclipse/jetty.project/contributors","subscribers_url":"https://api.github.com/repos/eclipse/jetty.project/subscribers","subscription_url":"https://api.github.com/repos/eclipse/jetty.project/subscription","commits_url":"https://api.github.com/repos/eclipse/jetty.project/commits{/sha}","git_commits_url":"https://api.github.com/repos/eclipse/jetty.project/git/commits{/sha}","comments_url":"https://api.github.com/repos/eclipse/jetty.project/comments{/number}","issue_comment_url":"https://api.github.com/repos/eclipse/jetty.project/issues/comments{/number}","contents_url":"https://api.github.com/repos/eclipse/jetty.project/contents/{+path}","compare_url":"https://api.github.com/repos/eclipse/jetty.project/compare/{base}...{head}","merges_url":"https://api.github.com/repos/eclipse/jetty.project/merges","archive_url":"https://api.github.com/repos/eclipse/jetty.project/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/eclipse/jetty.project/downloads","issues_url":"https://api.github.com/repos/eclipse/jetty.project/issues{/number}","pulls_url":"https://api.github.com/repos/eclipse/jetty.project/pulls{/number}","milestones_url":"https://api.github.com/repos/eclipse/jetty.project/milestones{/number}","notifications_url":"https://api.github.com/repos/eclipse/jetty.project/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/eclipse/jetty.project/labels{/name}","releases_url":"https://api.github.com/repos/eclipse/jetty.project/releases{/id}","deployments_url":"https://api.github.com/repos/eclipse/jetty.project/deployments","created_at":"2011-07-14T01:11:57Z","updated_at":"2016-08-15T18:10:21Z","pushed_at":"2016-08-15T23:04:17Z","git_url":"git://github.com/eclipse/jetty.project.git","ssh_url":"git@github.com:eclipse/jetty.project.git","clone_url":"https://github.com/eclipse/jetty.project.git","svn_url":"https://github.com/eclipse/jetty.project","homepage":"https://www.eclipse.org/jetty","size":109004,"stargazers_count":952,"watchers_count":952,"language":"Java","has_issues":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":687,"mirror_url":null,"open_issues_count":254,"forks":687,"open_issues":254,"watchers":952,"default_branch":"jetty-9.3.x"}},"_links":{"self":{"href":"https://api.github.com/repos/eclipse/jetty.project/pulls/838"},"html":{"href":"https://github.com/eclipse/jetty.project/pull/838"},"issue":{"href":"https://api.github.com/repos/eclipse/jetty.project/issues/838"},"comments":{"href":"https://api.github.com/repos/eclipse/jetty.project/issues/838/comments"},"review_comments":{"href":"https://api.github.com/repos/eclipse/jetty.project/pulls/838/comments"},"review_comment":{"href":"https://api.github.com/repos/eclipse/jetty.project/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/eclipse/jetty.project/pulls/838/commits"},"statuses":{"href":"https://api.github.com/repos/eclipse/jetty.project/statuses/405de2db8fc9cf64d88b46457b7de98d6b4e9ee2"}}}}
{"actor":{"display_login":"WalkerWatch"}}