{"action":"created","issue":{"url":"https://api.github.com/repos/javers/javers/issues/371","repository_url":"https://api.github.com/repos/javers/javers","labels_url":"https://api.github.com/repos/javers/javers/issues/371/labels{/name}","comments_url":"https://api.github.com/repos/javers/javers/issues/371/comments","events_url":"https://api.github.com/repos/javers/javers/issues/371/events","html_url":"https://github.com/javers/javers/issues/371","id":154676017,"number":371,"title":"When auditing data in java.lang.Iterable, exception occurred \"ORA-01000: maximum open cursors exceeded\" in oracle database","user":{"login":"carrchang","id":614483,"avatar_url":"https://avatars.githubusercontent.com/u/614483?v=3","gravatar_id":"","url":"https://api.github.com/users/carrchang","html_url":"https://github.com/carrchang","followers_url":"https://api.github.com/users/carrchang/followers","following_url":"https://api.github.com/users/carrchang/following{/other_user}","gists_url":"https://api.github.com/users/carrchang/gists{/gist_id}","starred_url":"https://api.github.com/users/carrchang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/carrchang/subscriptions","organizations_url":"https://api.github.com/users/carrchang/orgs","repos_url":"https://api.github.com/users/carrchang/repos","events_url":"https://api.github.com/users/carrchang/events{/privacy}","received_events_url":"https://api.github.com/users/carrchang/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-05-13T09:57:38Z","updated_at":"2016-05-13T10:04:51Z","closed_at":null,"body":"The exception is:\r\n```\r\nCaused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1\r\nORA-01000: maximum open cursors exceeded\r\nORA-00604: error occurred at recursive SQL level 1\r\nORA-01000: maximum open cursors exceeded\r\nORA-01000: maximum open cursors exceeded\r\n```\r\n\r\nMy solution is:\r\n```alter system set open_cursors = 1000;```\r\n\r\n> The number just a example, maybe need more bigger than this. \r\n\r\nSo I think we need a batch mode to process data(commit and snapshot). The Original commit as:\r\n```\r\norg.javers.core.Javers#commit(String author, Object currentVersion);\r\n```\r\nneed new api like:\r\n```\r\norg.javers.core.Javers#commit(String author, java.lang.Iterable<Object> currentVersion);\r\n```\r\n "},"comment":{"url":"https://api.github.com/repos/javers/javers/issues/comments/219003248","html_url":"https://github.com/javers/javers/issues/371#issuecomment-219003248","issue_url":"https://api.github.com/repos/javers/javers/issues/371","id":219003248,"user":{"login":"bartoszwalacik","id":2511028,"avatar_url":"https://avatars.githubusercontent.com/u/2511028?v=3","gravatar_id":"","url":"https://api.github.com/users/bartoszwalacik","html_url":"https://github.com/bartoszwalacik","followers_url":"https://api.github.com/users/bartoszwalacik/followers","following_url":"https://api.github.com/users/bartoszwalacik/following{/other_user}","gists_url":"https://api.github.com/users/bartoszwalacik/gists{/gist_id}","starred_url":"https://api.github.com/users/bartoszwalacik/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bartoszwalacik/subscriptions","organizations_url":"https://api.github.com/users/bartoszwalacik/orgs","repos_url":"https://api.github.com/users/bartoszwalacik/repos","events_url":"https://api.github.com/users/bartoszwalacik/events{/privacy}","received_events_url":"https://api.github.com/users/bartoszwalacik/received_events","type":"User","site_admin":false},"created_at":"2016-05-13T10:04:51Z","updated_at":"2016-05-13T10:04:51Z","body":"Which Javers version are you using?"}}