{"action":"created","issue":{"url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/488","labels_url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/488/labels{/name}","comments_url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/488/comments","events_url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/488/events","html_url":"https://github.com/brettwooldridge/HikariCP/issues/488","id":115138511,"number":488,"title":"Request adding PreparedStatement caching to HikariCP","user":{"login":"Adam-Git-Hub","id":15654826,"avatar_url":"https://avatars.githubusercontent.com/u/15654826?v=3","gravatar_id":"","url":"https://api.github.com/users/Adam-Git-Hub","html_url":"https://github.com/Adam-Git-Hub","followers_url":"https://api.github.com/users/Adam-Git-Hub/followers","following_url":"https://api.github.com/users/Adam-Git-Hub/following{/other_user}","gists_url":"https://api.github.com/users/Adam-Git-Hub/gists{/gist_id}","starred_url":"https://api.github.com/users/Adam-Git-Hub/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Adam-Git-Hub/subscriptions","organizations_url":"https://api.github.com/users/Adam-Git-Hub/orgs","repos_url":"https://api.github.com/users/Adam-Git-Hub/repos","events_url":"https://api.github.com/users/Adam-Git-Hub/events{/privacy}","received_events_url":"https://api.github.com/users/Adam-Git-Hub/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-11-04T20:19:33Z","updated_at":"2015-11-06T05:00:26Z","closed_at":"2015-11-06T05:00:25Z","body":"I would like to request adding PreparedStatement caching to HikariCP.\r\n\r\n1) PreparedStatement caching is not supported for SQL Server sqljdbc4.jar.\r\n\tjTDS does not support JDBC 4.0 nor DB mirroring\r\n\tsqljdbc4 is maintained by Microsoft\r\n\tMore sql server users are likely to use HikariCP.\r\n2) Consistency, this would simplify configuration across all jdbc drivers.\r\n\t(This would allow removing the caveat in the benchmarks about requiring PreparedStatement caching.)\r\n3) Performance\r\n\tBy leveraging the optimizations already present in HakariCP it would be faster.\r\n\r\nThank you,\r\nAdam"},"comment":{"url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/comments/154286123","html_url":"https://github.com/brettwooldridge/HikariCP/issues/488#issuecomment-154286123","issue_url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/488","id":154286123,"user":{"login":"brettwooldridge","id":1538661,"avatar_url":"https://avatars.githubusercontent.com/u/1538661?v=3","gravatar_id":"","url":"https://api.github.com/users/brettwooldridge","html_url":"https://github.com/brettwooldridge","followers_url":"https://api.github.com/users/brettwooldridge/followers","following_url":"https://api.github.com/users/brettwooldridge/following{/other_user}","gists_url":"https://api.github.com/users/brettwooldridge/gists{/gist_id}","starred_url":"https://api.github.com/users/brettwooldridge/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/brettwooldridge/subscriptions","organizations_url":"https://api.github.com/users/brettwooldridge/orgs","repos_url":"https://api.github.com/users/brettwooldridge/repos","events_url":"https://api.github.com/users/brettwooldridge/events{/privacy}","received_events_url":"https://api.github.com/users/brettwooldridge/received_events","type":"User","site_admin":false},"created_at":"2015-11-06T05:00:25Z","updated_at":"2015-11-06T05:00:25Z","body":"![screen shot 2015-11-06 at 13 57 39](https://cloud.githubusercontent.com/assets/1538661/10989725/684a2bdc-848e-11e5-9d35-c992dc7ad0bb.png)\r\n\r\nThere, I started it for you.  Favorite it, retweet it, respond to it (don't forget @SQLServer)!\r\n"}}