{"action":"created","comment":{"url":"https://api.github.com/repos/lf-kailashraj/batch7crud/pulls/comments/50212927","id":50212927,"diff_hunk":"@@ -0,0 +1,36 @@\n+package com.lftechnology.batch7crud.db;\n+\n+import java.sql.Connection;\n+import java.sql.SQLException;\n+import java.util.logging.Level;\n+import java.util.logging.Logger;\n+\n+import javax.naming.Context;\n+import javax.naming.InitialContext;\n+import javax.naming.NamingException;\n+import javax.sql.DataSource;\n+\n+public class DbConnector {\n+\n+    private static final Logger logger = Logger.getLogger(\"UserController\");\n+\n+    private DbConnector() {\n+\n+    }\n+\n+    public static Connection getMySqlConnection() throws SQLException {\n+        Connection connection = null;\n+        try {\n+            Context initCtx = new InitialContext();\n+\n+            Context envCtx = (Context) initCtx.lookup(\"java:comp/env\");\n+\n+            DataSource ds = (DataSource) envCtx.lookup(\"jdbc/dbInitial\");\n+            connection = ds.getConnection();\n+        } catch (NamingException e) {","path":"batch7crud-roll6/src/main/java/com/lftechnology/batch7crud/db/DbConnector.java","position":30,"original_position":30,"commit_id":"6c514fb67b01b18fb8824c9587d7447b8bd64c84","original_commit_id":"6c514fb67b01b18fb8824c9587d7447b8bd64c84","user":{"login":"bhuwang","id":3335673,"avatar_url":"https://avatars.githubusercontent.com/u/3335673?v=3","gravatar_id":"","url":"https://api.github.com/users/bhuwang","html_url":"https://github.com/bhuwang","followers_url":"https://api.github.com/users/bhuwang/followers","following_url":"https://api.github.com/users/bhuwang/following{/other_user}","gists_url":"https://api.github.com/users/bhuwang/gists{/gist_id}","starred_url":"https://api.github.com/users/bhuwang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bhuwang/subscriptions","organizations_url":"https://api.github.com/users/bhuwang/orgs","repos_url":"https://api.github.com/users/bhuwang/repos","events_url":"https://api.github.com/users/bhuwang/events{/privacy}","received_events_url":"https://api.github.com/users/bhuwang/received_events","type":"User","site_admin":false},"body":"![CRITICAL](https://raw.githubusercontent.com/SonarCommunity/sonar-github/master/images/severity-critical.png) Either log or rethrow this exception. [![rule](https://raw.githubusercontent.com/SonarCommunity/sonar-github/master/images/rule.png)](http://nemo.sonarqube.org/coding_rules#rule_key=squid%3AS1166)\n","created_at":"2016-01-20T04:12:42Z","updated_at":"2016-01-20T04:12:42Z","html_url":"https://github.com/lf-kailashraj/batch7crud/pull/11#discussion_r50212927","pull_request_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/pulls/11","_links":{"self":{"href":"https://api.github.com/repos/lf-kailashraj/batch7crud/pulls/comments/50212927"},"html":{"href":"https://github.com/lf-kailashraj/batch7crud/pull/11#discussion_r50212927"},"pull_request":{"href":"https://api.github.com/repos/lf-kailashraj/batch7crud/pulls/11"}}},"pull_request":{"url":"https://api.github.com/repos/lf-kailashraj/batch7crud/pulls/11","id":56426829,"html_url":"https://github.com/lf-kailashraj/batch7crud/pull/11","diff_url":"https://github.com/lf-kailashraj/batch7crud/pull/11.diff","patch_url":"https://github.com/lf-kailashraj/batch7crud/pull/11.patch","issue_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/issues/11","number":11,"state":"open","locked":false,"title":"CRUD operation done","user":{"login":"lf-madan","id":16680742,"avatar_url":"https://avatars.githubusercontent.com/u/16680742?v=3","gravatar_id":"","url":"https://api.github.com/users/lf-madan","html_url":"https://github.com/lf-madan","followers_url":"https://api.github.com/users/lf-madan/followers","following_url":"https://api.github.com/users/lf-madan/following{/other_user}","gists_url":"https://api.github.com/users/lf-madan/gists{/gist_id}","starred_url":"https://api.github.com/users/lf-madan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lf-madan/subscriptions","organizations_url":"https://api.github.com/users/lf-madan/orgs","repos_url":"https://api.github.com/users/lf-madan/repos","events_url":"https://api.github.com/users/lf-madan/events{/privacy}","received_events_url":"https://api.github.com/users/lf-madan/received_events","type":"User","site_admin":false},"body":"","created_at":"2016-01-19T06:30:44Z","updated_at":"2016-01-20T04:12:43Z","closed_at":null,"merged_at":null,"merge_commit_sha":"0676f2f1fef802ec2902c70ebdc6cc82b315cb67","assignee":{"login":"udhamala-lftechnology","id":5583533,"avatar_url":"https://avatars.githubusercontent.com/u/5583533?v=3","gravatar_id":"","url":"https://api.github.com/users/udhamala-lftechnology","html_url":"https://github.com/udhamala-lftechnology","followers_url":"https://api.github.com/users/udhamala-lftechnology/followers","following_url":"https://api.github.com/users/udhamala-lftechnology/following{/other_user}","gists_url":"https://api.github.com/users/udhamala-lftechnology/gists{/gist_id}","starred_url":"https://api.github.com/users/udhamala-lftechnology/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/udhamala-lftechnology/subscriptions","organizations_url":"https://api.github.com/users/udhamala-lftechnology/orgs","repos_url":"https://api.github.com/users/udhamala-lftechnology/repos","events_url":"https://api.github.com/users/udhamala-lftechnology/events{/privacy}","received_events_url":"https://api.github.com/users/udhamala-lftechnology/received_events","type":"User","site_admin":false},"milestone":null,"commits_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/pulls/11/commits","review_comments_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/pulls/11/comments","review_comment_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/pulls/comments{/number}","comments_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/issues/11/comments","statuses_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/statuses/6c514fb67b01b18fb8824c9587d7447b8bd64c84","head":{"label":"lf-kailashraj:ROLL6-branch1","ref":"ROLL6-branch1","sha":"6c514fb67b01b18fb8824c9587d7447b8bd64c84","user":{"login":"lf-kailashraj","id":7426244,"avatar_url":"https://avatars.githubusercontent.com/u/7426244?v=3","gravatar_id":"","url":"https://api.github.com/users/lf-kailashraj","html_url":"https://github.com/lf-kailashraj","followers_url":"https://api.github.com/users/lf-kailashraj/followers","following_url":"https://api.github.com/users/lf-kailashraj/following{/other_user}","gists_url":"https://api.github.com/users/lf-kailashraj/gists{/gist_id}","starred_url":"https://api.github.com/users/lf-kailashraj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lf-kailashraj/subscriptions","organizations_url":"https://api.github.com/users/lf-kailashraj/orgs","repos_url":"https://api.github.com/users/lf-kailashraj/repos","events_url":"https://api.github.com/users/lf-kailashraj/events{/privacy}","received_events_url":"https://api.github.com/users/lf-kailashraj/received_events","type":"User","site_admin":false},"repo":{"id":49557152,"name":"batch7crud","full_name":"lf-kailashraj/batch7crud","owner":{"login":"lf-kailashraj","id":7426244,"avatar_url":"https://avatars.githubusercontent.com/u/7426244?v=3","gravatar_id":"","url":"https://api.github.com/users/lf-kailashraj","html_url":"https://github.com/lf-kailashraj","followers_url":"https://api.github.com/users/lf-kailashraj/followers","following_url":"https://api.github.com/users/lf-kailashraj/following{/other_user}","gists_url":"https://api.github.com/users/lf-kailashraj/gists{/gist_id}","starred_url":"https://api.github.com/users/lf-kailashraj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lf-kailashraj/subscriptions","organizations_url":"https://api.github.com/users/lf-kailashraj/orgs","repos_url":"https://api.github.com/users/lf-kailashraj/repos","events_url":"https://api.github.com/users/lf-kailashraj/events{/privacy}","received_events_url":"https://api.github.com/users/lf-kailashraj/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/lf-kailashraj/batch7crud","description":"","fork":false,"url":"https://api.github.com/repos/lf-kailashraj/batch7crud","forks_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/forks","keys_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/keys{/key_id}","collaborators_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/teams","hooks_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/hooks","issue_events_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/issues/events{/number}","events_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/events","assignees_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/assignees{/user}","branches_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/branches{/branch}","tags_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/tags","blobs_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/git/refs{/sha}","trees_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/git/trees{/sha}","statuses_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/statuses/{sha}","languages_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/languages","stargazers_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/stargazers","contributors_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/contributors","subscribers_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/subscribers","subscription_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/subscription","commits_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/commits{/sha}","git_commits_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/git/commits{/sha}","comments_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/comments{/number}","issue_comment_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/issues/comments{/number}","contents_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/contents/{+path}","compare_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/compare/{base}...{head}","merges_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/merges","archive_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/downloads","issues_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/issues{/number}","pulls_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/pulls{/number}","milestones_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/milestones{/number}","notifications_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/labels{/name}","releases_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/releases{/id}","created_at":"2016-01-13T07:24:08Z","updated_at":"2016-01-13T07:26:37Z","pushed_at":"2016-01-20T04:09:57Z","git_url":"git://github.com/lf-kailashraj/batch7crud.git","ssh_url":"git@github.com:lf-kailashraj/batch7crud.git","clone_url":"https://github.com/lf-kailashraj/batch7crud.git","svn_url":"https://github.com/lf-kailashraj/batch7crud","homepage":null,"size":217,"stargazers_count":0,"watchers_count":0,"language":"Java","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":10,"forks":0,"open_issues":10,"watchers":0,"default_branch":"dev"}},"base":{"label":"lf-kailashraj:dev","ref":"dev","sha":"2356e0515bd2aae35d92d74484081a4e53512bb4","user":{"login":"lf-kailashraj","id":7426244,"avatar_url":"https://avatars.githubusercontent.com/u/7426244?v=3","gravatar_id":"","url":"https://api.github.com/users/lf-kailashraj","html_url":"https://github.com/lf-kailashraj","followers_url":"https://api.github.com/users/lf-kailashraj/followers","following_url":"https://api.github.com/users/lf-kailashraj/following{/other_user}","gists_url":"https://api.github.com/users/lf-kailashraj/gists{/gist_id}","starred_url":"https://api.github.com/users/lf-kailashraj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lf-kailashraj/subscriptions","organizations_url":"https://api.github.com/users/lf-kailashraj/orgs","repos_url":"https://api.github.com/users/lf-kailashraj/repos","events_url":"https://api.github.com/users/lf-kailashraj/events{/privacy}","received_events_url":"https://api.github.com/users/lf-kailashraj/received_events","type":"User","site_admin":false},"repo":{"id":49557152,"name":"batch7crud","full_name":"lf-kailashraj/batch7crud","owner":{"login":"lf-kailashraj","id":7426244,"avatar_url":"https://avatars.githubusercontent.com/u/7426244?v=3","gravatar_id":"","url":"https://api.github.com/users/lf-kailashraj","html_url":"https://github.com/lf-kailashraj","followers_url":"https://api.github.com/users/lf-kailashraj/followers","following_url":"https://api.github.com/users/lf-kailashraj/following{/other_user}","gists_url":"https://api.github.com/users/lf-kailashraj/gists{/gist_id}","starred_url":"https://api.github.com/users/lf-kailashraj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lf-kailashraj/subscriptions","organizations_url":"https://api.github.com/users/lf-kailashraj/orgs","repos_url":"https://api.github.com/users/lf-kailashraj/repos","events_url":"https://api.github.com/users/lf-kailashraj/events{/privacy}","received_events_url":"https://api.github.com/users/lf-kailashraj/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/lf-kailashraj/batch7crud","description":"","fork":false,"url":"https://api.github.com/repos/lf-kailashraj/batch7crud","forks_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/forks","keys_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/keys{/key_id}","collaborators_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/teams","hooks_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/hooks","issue_events_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/issues/events{/number}","events_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/events","assignees_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/assignees{/user}","branches_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/branches{/branch}","tags_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/tags","blobs_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/git/refs{/sha}","trees_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/git/trees{/sha}","statuses_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/statuses/{sha}","languages_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/languages","stargazers_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/stargazers","contributors_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/contributors","subscribers_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/subscribers","subscription_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/subscription","commits_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/commits{/sha}","git_commits_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/git/commits{/sha}","comments_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/comments{/number}","issue_comment_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/issues/comments{/number}","contents_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/contents/{+path}","compare_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/compare/{base}...{head}","merges_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/merges","archive_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/downloads","issues_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/issues{/number}","pulls_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/pulls{/number}","milestones_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/milestones{/number}","notifications_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/labels{/name}","releases_url":"https://api.github.com/repos/lf-kailashraj/batch7crud/releases{/id}","created_at":"2016-01-13T07:24:08Z","updated_at":"2016-01-13T07:26:37Z","pushed_at":"2016-01-20T04:09:57Z","git_url":"git://github.com/lf-kailashraj/batch7crud.git","ssh_url":"git@github.com:lf-kailashraj/batch7crud.git","clone_url":"https://github.com/lf-kailashraj/batch7crud.git","svn_url":"https://github.com/lf-kailashraj/batch7crud","homepage":null,"size":217,"stargazers_count":0,"watchers_count":0,"language":"Java","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":10,"forks":0,"open_issues":10,"watchers":0,"default_branch":"dev"}},"_links":{"self":{"href":"https://api.github.com/repos/lf-kailashraj/batch7crud/pulls/11"},"html":{"href":"https://github.com/lf-kailashraj/batch7crud/pull/11"},"issue":{"href":"https://api.github.com/repos/lf-kailashraj/batch7crud/issues/11"},"comments":{"href":"https://api.github.com/repos/lf-kailashraj/batch7crud/issues/11/comments"},"review_comments":{"href":"https://api.github.com/repos/lf-kailashraj/batch7crud/pulls/11/comments"},"review_comment":{"href":"https://api.github.com/repos/lf-kailashraj/batch7crud/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/lf-kailashraj/batch7crud/pulls/11/commits"},"statuses":{"href":"https://api.github.com/repos/lf-kailashraj/batch7crud/statuses/6c514fb67b01b18fb8824c9587d7447b8bd64c84"}}}}