{"action":"created","issue":{"url":"https://api.github.com/repos/pocoproject/poco/issues/913","labels_url":"https://api.github.com/repos/pocoproject/poco/issues/913/labels{/name}","comments_url":"https://api.github.com/repos/pocoproject/poco/issues/913/comments","events_url":"https://api.github.com/repos/pocoproject/poco/issues/913/events","html_url":"https://github.com/pocoproject/poco/issues/913","id":101982289,"number":913,"title":"Property \"transactionMode\" of Poco::Data::Session no longer supported in Poco 1.6.0","user":{"login":"danatata","id":13151456,"avatar_url":"https://avatars.githubusercontent.com/u/13151456?v=3","gravatar_id":"","url":"https://api.github.com/users/danatata","html_url":"https://github.com/danatata","followers_url":"https://api.github.com/users/danatata/followers","following_url":"https://api.github.com/users/danatata/following{/other_user}","gists_url":"https://api.github.com/users/danatata/gists{/gist_id}","starred_url":"https://api.github.com/users/danatata/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danatata/subscriptions","organizations_url":"https://api.github.com/users/danatata/orgs","repos_url":"https://api.github.com/users/danatata/repos","events_url":"https://api.github.com/users/danatata/events{/privacy}","received_events_url":"https://api.github.com/users/danatata/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/pocoproject/poco/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-08-19T19:46:52Z","updated_at":"2015-08-19T23:26:30Z","closed_at":null,"body":"When I tried to set \"transactionMode\" property of  a Poco::Data::Session object to \"IMMEDIATE\" in Poco 1.6, I got a run time error \"feature or property not supported\".\r\nThe same code works in Poco 1.4.6.\r\n\r\nFrom the release note, the support for \"transactionMode\" property is added in Poco 1.3.4. \r\nI did not find any other information there indicating it is no longer supported in Poco 1.6.\r\nIs this a bug?"},"comment":{"url":"https://api.github.com/repos/pocoproject/poco/issues/comments/132824772","html_url":"https://github.com/pocoproject/poco/issues/913#issuecomment-132824772","issue_url":"https://api.github.com/repos/pocoproject/poco/issues/913","id":132824772,"user":{"login":"aleks-f","id":2429093,"avatar_url":"https://avatars.githubusercontent.com/u/2429093?v=3","gravatar_id":"","url":"https://api.github.com/users/aleks-f","html_url":"https://github.com/aleks-f","followers_url":"https://api.github.com/users/aleks-f/followers","following_url":"https://api.github.com/users/aleks-f/following{/other_user}","gists_url":"https://api.github.com/users/aleks-f/gists{/gist_id}","starred_url":"https://api.github.com/users/aleks-f/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aleks-f/subscriptions","organizations_url":"https://api.github.com/users/aleks-f/orgs","repos_url":"https://api.github.com/users/aleks-f/repos","events_url":"https://api.github.com/users/aleks-f/events{/privacy}","received_events_url":"https://api.github.com/users/aleks-f/received_events","type":"User","site_admin":false},"created_at":"2015-08-19T23:26:30Z","updated_at":"2015-08-19T23:26:30Z","body":"AFAICT, ```BEGIN IMMEDIATE``` is SQLite specific, so it would require adding some features specific for that back-end (if there are APIs to set it session-wide - I didn't check). Currently, transactions are supported through [Transaction](https://github.com/pocoproject/poco/blob/develop/Data/include/Poco/Data/Transaction.h#L33) and SQLite autoCommit is [not implemented](https://github.com/pocoproject/poco/blob/develop/Data/SQLite/src/SessionImpl.cpp#L247). If you need changes, send a pull request and we will look into it. Keep in mind that will likely not be inclined propagate back-end specifics to the front-end Poco::Data interface because it would break the abstraction. @intensifi"}}