{"action":"closed","issue":{"url":"https://api.github.com/repos/ebean-orm/avaje-ebeanorm/issues/415","labels_url":"https://api.github.com/repos/ebean-orm/avaje-ebeanorm/issues/415/labels{/name}","comments_url":"https://api.github.com/repos/ebean-orm/avaje-ebeanorm/issues/415/comments","events_url":"https://api.github.com/repos/ebean-orm/avaje-ebeanorm/issues/415/events","html_url":"https://github.com/ebean-orm/avaje-ebeanorm/issues/415","id":107093251,"number":415,"title":"ENH: Add ExplicitJdbcTransaction ... so like AutoCommitJdbcTransaction but using explicit statements to commit and rollback","user":{"login":"rbygrave","id":208973,"avatar_url":"https://avatars.githubusercontent.com/u/208973?v=3","gravatar_id":"","url":"https://api.github.com/users/rbygrave","html_url":"https://github.com/rbygrave","followers_url":"https://api.github.com/users/rbygrave/followers","following_url":"https://api.github.com/users/rbygrave/following{/other_user}","gists_url":"https://api.github.com/users/rbygrave/gists{/gist_id}","starred_url":"https://api.github.com/users/rbygrave/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rbygrave/subscriptions","organizations_url":"https://api.github.com/users/rbygrave/orgs","repos_url":"https://api.github.com/users/rbygrave/repos","events_url":"https://api.github.com/users/rbygrave/events{/privacy}","received_events_url":"https://api.github.com/users/rbygrave/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/ebean-orm/avaje-ebeanorm/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"closed","locked":false,"assignee":{"login":"rbygrave","id":208973,"avatar_url":"https://avatars.githubusercontent.com/u/208973?v=3","gravatar_id":"","url":"https://api.github.com/users/rbygrave","html_url":"https://github.com/rbygrave","followers_url":"https://api.github.com/users/rbygrave/followers","following_url":"https://api.github.com/users/rbygrave/following{/other_user}","gists_url":"https://api.github.com/users/rbygrave/gists{/gist_id}","starred_url":"https://api.github.com/users/rbygrave/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rbygrave/subscriptions","organizations_url":"https://api.github.com/users/rbygrave/orgs","repos_url":"https://api.github.com/users/rbygrave/repos","events_url":"https://api.github.com/users/rbygrave/events{/privacy}","received_events_url":"https://api.github.com/users/rbygrave/received_events","type":"User","site_admin":false},"milestone":null,"comments":1,"created_at":"2015-09-17T22:58:43Z","updated_at":"2015-09-18T10:27:45Z","closed_at":"2015-09-18T10:27:45Z","body":"As per discussion with Daryl so:\r\n\r\nVery similar to AutoCommitJdbcTransaction but with the following changes:\r\n- beginTransaction() was connection.executeUpdate(\"begin\");\r\n- commitTransaction() was connection.executeUpdate(\"commit\");\r\n- rollbackTransaction() was connection.executeUpdate(\"rollback\");\r\n\r\nIn this case the connection can be in autoCommit=true mode but we still want/expect transaction demarcation (and we get that via using the explicit executeUpdate(\"begin\"); etc).\r\n\r\nSo to do this we will add a ExplicitJdbcTransaction and ExplicitTransactionManager and a serverConfig option to turn it on."}}