{"action":"created","issue":{"url":"https://api.github.com/repos/pentaho/pentaho-platform-plugin-reporting/issues/164","labels_url":"https://api.github.com/repos/pentaho/pentaho-platform-plugin-reporting/issues/164/labels{/name}","comments_url":"https://api.github.com/repos/pentaho/pentaho-platform-plugin-reporting/issues/164/comments","events_url":"https://api.github.com/repos/pentaho/pentaho-platform-plugin-reporting/issues/164/events","html_url":"https://github.com/pentaho/pentaho-platform-plugin-reporting/pull/164","id":104677389,"number":164,"title":"[BISERVER-12767] Resolve issue where the ScrollableResultSetTableModel is not closed after caching","user":{"login":"bradhandy","id":683552,"avatar_url":"https://avatars.githubusercontent.com/u/683552?v=3","gravatar_id":"","url":"https://api.github.com/users/bradhandy","html_url":"https://github.com/bradhandy","followers_url":"https://api.github.com/users/bradhandy/followers","following_url":"https://api.github.com/users/bradhandy/following{/other_user}","gists_url":"https://api.github.com/users/bradhandy/gists{/gist_id}","starred_url":"https://api.github.com/users/bradhandy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bradhandy/subscriptions","organizations_url":"https://api.github.com/users/bradhandy/orgs","repos_url":"https://api.github.com/users/bradhandy/repos","events_url":"https://api.github.com/users/bradhandy/events{/privacy}","received_events_url":"https://api.github.com/users/bradhandy/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-09-03T12:13:13Z","updated_at":"2015-10-15T17:28:15Z","closed_at":"2015-09-08T17:17:03Z","pull_request":{"url":"https://api.github.com/repos/pentaho/pentaho-platform-plugin-reporting/pulls/164","html_url":"https://github.com/pentaho/pentaho-platform-plugin-reporting/pull/164","diff_url":"https://github.com/pentaho/pentaho-platform-plugin-reporting/pull/164.diff","patch_url":"https://github.com/pentaho/pentaho-platform-plugin-reporting/pull/164.patch"},"body":"When caching data via the CachingDataFactory, the data is added to the PentahoDataCache.  The CachingDataFactory expects to have a different TableModel returned in order to close the original one, if it is a CloseableTableModel.\r\n\r\nThe PentahoDataCache always returns the original TableModel causing the CachingDataFactory to skip closing the original TableModel.  This leaves the ResultSet and a corresponding cursor open within Oracle.  This can lead to \"maximum open cursor limit exceeded\" errors in Oracle.\r\n\r\nThis is related to support request #60653 on support.pentaho.com."},"comment":{"url":"https://api.github.com/repos/pentaho/pentaho-platform-plugin-reporting/issues/comments/148466029","html_url":"https://github.com/pentaho/pentaho-platform-plugin-reporting/pull/164#issuecomment-148466029","issue_url":"https://api.github.com/repos/pentaho/pentaho-platform-plugin-reporting/issues/164","id":148466029,"user":{"login":"bradhandy","id":683552,"avatar_url":"https://avatars.githubusercontent.com/u/683552?v=3","gravatar_id":"","url":"https://api.github.com/users/bradhandy","html_url":"https://github.com/bradhandy","followers_url":"https://api.github.com/users/bradhandy/followers","following_url":"https://api.github.com/users/bradhandy/following{/other_user}","gists_url":"https://api.github.com/users/bradhandy/gists{/gist_id}","starred_url":"https://api.github.com/users/bradhandy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bradhandy/subscriptions","organizations_url":"https://api.github.com/users/bradhandy/orgs","repos_url":"https://api.github.com/users/bradhandy/repos","events_url":"https://api.github.com/users/bradhandy/events{/privacy}","received_events_url":"https://api.github.com/users/bradhandy/received_events","type":"User","site_admin":false},"created_at":"2015-10-15T17:28:15Z","updated_at":"2015-10-15T17:28:15Z","body":"Thank you!"}}