{"action":"created","comment":{"url":"https://api.github.com/repos/jenkinsci/database-plugin/pulls/comments/35200883","id":35200883,"diff_hunk":"@@ -14,6 +14,9 @@ f.entry(field:\"username\", title:_(\"Username\")) {\n f.entry(field:\"password\", title:_(\"Password\")) {\n     f.password()\n }\n+f.entry(field:\"validationQuery\", title:_(\"Validation Query\")) {\n+  f.textarea()\n+}\n f.advanced {","path":"src/main/resources/org/jenkinsci/plugins/database/AbstractRemoteDatabase/config.groovy","position":7,"original_position":7,"commit_id":"bd09678023d09cfb84c8cc24b4f583cfab6a128d","original_commit_id":"bd09678023d09cfb84c8cc24b4f583cfab6a128d","user":{"login":"uhafner","id":503338,"avatar_url":"https://avatars.githubusercontent.com/u/503338?v=3","gravatar_id":"","url":"https://api.github.com/users/uhafner","html_url":"https://github.com/uhafner","followers_url":"https://api.github.com/users/uhafner/followers","following_url":"https://api.github.com/users/uhafner/following{/other_user}","gists_url":"https://api.github.com/users/uhafner/gists{/gist_id}","starred_url":"https://api.github.com/users/uhafner/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/uhafner/subscriptions","organizations_url":"https://api.github.com/users/uhafner/orgs","repos_url":"https://api.github.com/users/uhafner/repos","events_url":"https://api.github.com/users/uhafner/events{/privacy}","received_events_url":"https://api.github.com/users/uhafner/received_events","type":"User","site_admin":false},"body":"Can you add a help text on how to use this query?","created_at":"2015-07-22T10:51:08Z","updated_at":"2015-07-22T10:51:08Z","html_url":"https://github.com/jenkinsci/database-plugin/pull/1#discussion_r35200883","pull_request_url":"https://api.github.com/repos/jenkinsci/database-plugin/pulls/1","_links":{"self":{"href":"https://api.github.com/repos/jenkinsci/database-plugin/pulls/comments/35200883"},"html":{"href":"https://github.com/jenkinsci/database-plugin/pull/1#discussion_r35200883"},"pull_request":{"href":"https://api.github.com/repos/jenkinsci/database-plugin/pulls/1"}}},"pull_request":{"url":"https://api.github.com/repos/jenkinsci/database-plugin/pulls/1","id":21200244,"html_url":"https://github.com/jenkinsci/database-plugin/pull/1","diff_url":"https://github.com/jenkinsci/database-plugin/pull/1.diff","patch_url":"https://github.com/jenkinsci/database-plugin/pull/1.patch","issue_url":"https://api.github.com/repos/jenkinsci/database-plugin/issues/1","number":1,"state":"open","locked":false,"title":"JENKINS-24697 Add support for a validation query to prevent plugins getting a bad database handle returned","user":{"login":"davidvanlaatum","id":1491158,"avatar_url":"https://avatars.githubusercontent.com/u/1491158?v=3","gravatar_id":"","url":"https://api.github.com/users/davidvanlaatum","html_url":"https://github.com/davidvanlaatum","followers_url":"https://api.github.com/users/davidvanlaatum/followers","following_url":"https://api.github.com/users/davidvanlaatum/following{/other_user}","gists_url":"https://api.github.com/users/davidvanlaatum/gists{/gist_id}","starred_url":"https://api.github.com/users/davidvanlaatum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/davidvanlaatum/subscriptions","organizations_url":"https://api.github.com/users/davidvanlaatum/orgs","repos_url":"https://api.github.com/users/davidvanlaatum/repos","events_url":"https://api.github.com/users/davidvanlaatum/events{/privacy}","received_events_url":"https://api.github.com/users/davidvanlaatum/received_events","type":"User","site_admin":false},"body":"","created_at":"2014-09-14T04:01:43Z","updated_at":"2015-07-22T10:51:08Z","closed_at":null,"merged_at":null,"merge_commit_sha":"80a0591192f8a1fe3606e3ab4f75a82de1a191f2","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/jenkinsci/database-plugin/pulls/1/commits","review_comments_url":"https://api.github.com/repos/jenkinsci/database-plugin/pulls/1/comments","review_comment_url":"https://api.github.com/repos/jenkinsci/database-plugin/pulls/comments{/number}","comments_url":"https://api.github.com/repos/jenkinsci/database-plugin/issues/1/comments","statuses_url":"https://api.github.com/repos/jenkinsci/database-plugin/statuses/bd09678023d09cfb84c8cc24b4f583cfab6a128d","head":{"label":"davidvanlaatum:master","ref":"master","sha":"bd09678023d09cfb84c8cc24b4f583cfab6a128d","user":{"login":"davidvanlaatum","id":1491158,"avatar_url":"https://avatars.githubusercontent.com/u/1491158?v=3","gravatar_id":"","url":"https://api.github.com/users/davidvanlaatum","html_url":"https://github.com/davidvanlaatum","followers_url":"https://api.github.com/users/davidvanlaatum/followers","following_url":"https://api.github.com/users/davidvanlaatum/following{/other_user}","gists_url":"https://api.github.com/users/davidvanlaatum/gists{/gist_id}","starred_url":"https://api.github.com/users/davidvanlaatum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/davidvanlaatum/subscriptions","organizations_url":"https://api.github.com/users/davidvanlaatum/orgs","repos_url":"https://api.github.com/users/davidvanlaatum/repos","events_url":"https://api.github.com/users/davidvanlaatum/events{/privacy}","received_events_url":"https://api.github.com/users/davidvanlaatum/received_events","type":"User","site_admin":false},"repo":{"id":23750251,"name":"database-plugin","full_name":"davidvanlaatum/database-plugin","owner":{"login":"davidvanlaatum","id":1491158,"avatar_url":"https://avatars.githubusercontent.com/u/1491158?v=3","gravatar_id":"","url":"https://api.github.com/users/davidvanlaatum","html_url":"https://github.com/davidvanlaatum","followers_url":"https://api.github.com/users/davidvanlaatum/followers","following_url":"https://api.github.com/users/davidvanlaatum/following{/other_user}","gists_url":"https://api.github.com/users/davidvanlaatum/gists{/gist_id}","starred_url":"https://api.github.com/users/davidvanlaatum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/davidvanlaatum/subscriptions","organizations_url":"https://api.github.com/users/davidvanlaatum/orgs","repos_url":"https://api.github.com/users/davidvanlaatum/repos","events_url":"https://api.github.com/users/davidvanlaatum/events{/privacy}","received_events_url":"https://api.github.com/users/davidvanlaatum/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/davidvanlaatum/database-plugin","description":"","fork":true,"url":"https://api.github.com/repos/davidvanlaatum/database-plugin","forks_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/forks","keys_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/keys{/key_id}","collaborators_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/teams","hooks_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/hooks","issue_events_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/issues/events{/number}","events_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/events","assignees_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/assignees{/user}","branches_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/branches{/branch}","tags_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/tags","blobs_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/git/refs{/sha}","trees_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/git/trees{/sha}","statuses_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/statuses/{sha}","languages_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/languages","stargazers_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/stargazers","contributors_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/contributors","subscribers_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/subscribers","subscription_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/subscription","commits_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/commits{/sha}","git_commits_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/git/commits{/sha}","comments_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/comments{/number}","issue_comment_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/issues/comments{/number}","contents_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/contents/{+path}","compare_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/compare/{base}...{head}","merges_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/merges","archive_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/downloads","issues_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/issues{/number}","pulls_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/pulls{/number}","milestones_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/milestones{/number}","notifications_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/labels{/name}","releases_url":"https://api.github.com/repos/davidvanlaatum/database-plugin/releases{/id}","created_at":"2014-09-07T01:56:33Z","updated_at":"2014-09-07T09:48:10Z","pushed_at":"2015-07-22T01:28:01Z","git_url":"git://github.com/davidvanlaatum/database-plugin.git","ssh_url":"git@github.com:davidvanlaatum/database-plugin.git","clone_url":"https://github.com/davidvanlaatum/database-plugin.git","svn_url":"https://github.com/davidvanlaatum/database-plugin","homepage":"","size":155,"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":"master"}},"base":{"label":"jenkinsci:master","ref":"master","sha":"9a580c3b37468439f439ab21e500b65817dda49a","user":{"login":"jenkinsci","id":107424,"avatar_url":"https://avatars.githubusercontent.com/u/107424?v=3","gravatar_id":"","url":"https://api.github.com/users/jenkinsci","html_url":"https://github.com/jenkinsci","followers_url":"https://api.github.com/users/jenkinsci/followers","following_url":"https://api.github.com/users/jenkinsci/following{/other_user}","gists_url":"https://api.github.com/users/jenkinsci/gists{/gist_id}","starred_url":"https://api.github.com/users/jenkinsci/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jenkinsci/subscriptions","organizations_url":"https://api.github.com/users/jenkinsci/orgs","repos_url":"https://api.github.com/users/jenkinsci/repos","events_url":"https://api.github.com/users/jenkinsci/events{/privacy}","received_events_url":"https://api.github.com/users/jenkinsci/received_events","type":"Organization","site_admin":false},"repo":{"id":6854928,"name":"database-plugin","full_name":"jenkinsci/database-plugin","owner":{"login":"jenkinsci","id":107424,"avatar_url":"https://avatars.githubusercontent.com/u/107424?v=3","gravatar_id":"","url":"https://api.github.com/users/jenkinsci","html_url":"https://github.com/jenkinsci","followers_url":"https://api.github.com/users/jenkinsci/followers","following_url":"https://api.github.com/users/jenkinsci/following{/other_user}","gists_url":"https://api.github.com/users/jenkinsci/gists{/gist_id}","starred_url":"https://api.github.com/users/jenkinsci/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jenkinsci/subscriptions","organizations_url":"https://api.github.com/users/jenkinsci/orgs","repos_url":"https://api.github.com/users/jenkinsci/repos","events_url":"https://api.github.com/users/jenkinsci/events{/privacy}","received_events_url":"https://api.github.com/users/jenkinsci/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/jenkinsci/database-plugin","description":"","fork":false,"url":"https://api.github.com/repos/jenkinsci/database-plugin","forks_url":"https://api.github.com/repos/jenkinsci/database-plugin/forks","keys_url":"https://api.github.com/repos/jenkinsci/database-plugin/keys{/key_id}","collaborators_url":"https://api.github.com/repos/jenkinsci/database-plugin/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/jenkinsci/database-plugin/teams","hooks_url":"https://api.github.com/repos/jenkinsci/database-plugin/hooks","issue_events_url":"https://api.github.com/repos/jenkinsci/database-plugin/issues/events{/number}","events_url":"https://api.github.com/repos/jenkinsci/database-plugin/events","assignees_url":"https://api.github.com/repos/jenkinsci/database-plugin/assignees{/user}","branches_url":"https://api.github.com/repos/jenkinsci/database-plugin/branches{/branch}","tags_url":"https://api.github.com/repos/jenkinsci/database-plugin/tags","blobs_url":"https://api.github.com/repos/jenkinsci/database-plugin/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/jenkinsci/database-plugin/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/jenkinsci/database-plugin/git/refs{/sha}","trees_url":"https://api.github.com/repos/jenkinsci/database-plugin/git/trees{/sha}","statuses_url":"https://api.github.com/repos/jenkinsci/database-plugin/statuses/{sha}","languages_url":"https://api.github.com/repos/jenkinsci/database-plugin/languages","stargazers_url":"https://api.github.com/repos/jenkinsci/database-plugin/stargazers","contributors_url":"https://api.github.com/repos/jenkinsci/database-plugin/contributors","subscribers_url":"https://api.github.com/repos/jenkinsci/database-plugin/subscribers","subscription_url":"https://api.github.com/repos/jenkinsci/database-plugin/subscription","commits_url":"https://api.github.com/repos/jenkinsci/database-plugin/commits{/sha}","git_commits_url":"https://api.github.com/repos/jenkinsci/database-plugin/git/commits{/sha}","comments_url":"https://api.github.com/repos/jenkinsci/database-plugin/comments{/number}","issue_comment_url":"https://api.github.com/repos/jenkinsci/database-plugin/issues/comments{/number}","contents_url":"https://api.github.com/repos/jenkinsci/database-plugin/contents/{+path}","compare_url":"https://api.github.com/repos/jenkinsci/database-plugin/compare/{base}...{head}","merges_url":"https://api.github.com/repos/jenkinsci/database-plugin/merges","archive_url":"https://api.github.com/repos/jenkinsci/database-plugin/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/jenkinsci/database-plugin/downloads","issues_url":"https://api.github.com/repos/jenkinsci/database-plugin/issues{/number}","pulls_url":"https://api.github.com/repos/jenkinsci/database-plugin/pulls{/number}","milestones_url":"https://api.github.com/repos/jenkinsci/database-plugin/milestones{/number}","notifications_url":"https://api.github.com/repos/jenkinsci/database-plugin/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/jenkinsci/database-plugin/labels{/name}","releases_url":"https://api.github.com/repos/jenkinsci/database-plugin/releases{/id}","created_at":"2012-11-25T19:51:19Z","updated_at":"2013-11-22T14:28:06Z","pushed_at":"2015-07-22T01:28:01Z","git_url":"git://github.com/jenkinsci/database-plugin.git","ssh_url":"git@github.com:jenkinsci/database-plugin.git","clone_url":"https://github.com/jenkinsci/database-plugin.git","svn_url":"https://github.com/jenkinsci/database-plugin","homepage":"","size":251,"stargazers_count":1,"watchers_count":1,"language":"Java","has_issues":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":7,"mirror_url":null,"open_issues_count":1,"forks":7,"open_issues":1,"watchers":1,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/jenkinsci/database-plugin/pulls/1"},"html":{"href":"https://github.com/jenkinsci/database-plugin/pull/1"},"issue":{"href":"https://api.github.com/repos/jenkinsci/database-plugin/issues/1"},"comments":{"href":"https://api.github.com/repos/jenkinsci/database-plugin/issues/1/comments"},"review_comments":{"href":"https://api.github.com/repos/jenkinsci/database-plugin/pulls/1/comments"},"review_comment":{"href":"https://api.github.com/repos/jenkinsci/database-plugin/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/jenkinsci/database-plugin/pulls/1/commits"},"statuses":{"href":"https://api.github.com/repos/jenkinsci/database-plugin/statuses/bd09678023d09cfb84c8cc24b4f583cfab6a128d"}}}}