{"action":"created","issue":{"url":"https://api.github.com/repos/bootique/bootique-cayenne/issues/44","repository_url":"https://api.github.com/repos/bootique/bootique-cayenne","labels_url":"https://api.github.com/repos/bootique/bootique-cayenne/issues/44/labels{/name}","comments_url":"https://api.github.com/repos/bootique/bootique-cayenne/issues/44/comments","events_url":"https://api.github.com/repos/bootique/bootique-cayenne/issues/44/events","html_url":"https://github.com/bootique/bootique-cayenne/issues/44","id":251856990,"number":44,"title":"bootique-cayenne-test: test tables are not committed with rollbackOnReturn=true and defaultAutoCommit=false","user":{"login":"andrus","id":42668,"avatar_url":"https://avatars1.githubusercontent.com/u/42668?v=4","gravatar_id":"","url":"https://api.github.com/users/andrus","html_url":"https://github.com/andrus","followers_url":"https://api.github.com/users/andrus/followers","following_url":"https://api.github.com/users/andrus/following{/other_user}","gists_url":"https://api.github.com/users/andrus/gists{/gist_id}","starred_url":"https://api.github.com/users/andrus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andrus/subscriptions","organizations_url":"https://api.github.com/users/andrus/orgs","repos_url":"https://api.github.com/users/andrus/repos","events_url":"https://api.github.com/users/andrus/events{/privacy}","received_events_url":"https://api.github.com/users/andrus/received_events","type":"User","site_admin":false},"labels":[{"id":297978504,"url":"https://api.github.com/repos/bootique/bootique-cayenne/labels/bug","name":"bug","color":"fc2929","default":true}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/bootique/bootique-cayenne/milestones/15","html_url":"https://github.com/bootique/bootique-cayenne/milestone/15","labels_url":"https://api.github.com/repos/bootique/bootique-cayenne/milestones/15/labels","id":3238149,"number":15,"title":"0.26","description":null,"creator":{"login":"andrus","id":42668,"avatar_url":"https://avatars1.githubusercontent.com/u/42668?v=4","gravatar_id":"","url":"https://api.github.com/users/andrus","html_url":"https://github.com/andrus","followers_url":"https://api.github.com/users/andrus/followers","following_url":"https://api.github.com/users/andrus/following{/other_user}","gists_url":"https://api.github.com/users/andrus/gists{/gist_id}","starred_url":"https://api.github.com/users/andrus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andrus/subscriptions","organizations_url":"https://api.github.com/users/andrus/orgs","repos_url":"https://api.github.com/users/andrus/repos","events_url":"https://api.github.com/users/andrus/events{/privacy}","received_events_url":"https://api.github.com/users/andrus/received_events","type":"User","site_admin":false},"open_issues":0,"closed_issues":1,"state":"open","created_at":"2018-04-03T10:19:10Z","updated_at":"2018-04-03T10:19:35Z","due_on":null,"closed_at":null},"comments":1,"created_at":"2017-08-22T07:01:41Z","updated_at":"2018-04-03T10:19:35Z","closed_at":"2018-04-03T10:19:35Z","author_association":"COLLABORATOR","body":"With the following test data source settings:\r\n\r\n```yaml\r\njdbc:\r\n  ds:\r\n    url: jdbc:derby:target/derby/derby3;create=true\r\n    initialSize: 1\r\n    rollbackOnReturn: true\r\n    defaultAutoCommit: false\r\n```\r\n\r\ncreated test schema is rolled back and is not visible to the operations that follow:\r\n\r\n```java\r\nCayenneTestDataManager dataManager = new CayenneTestDataManager(runtime, false, Table1.class);\r\nTable t1 = dataManager.getTable(Table1.class);\r\nassertEquals(0, t1.getRowCount());\r\n```\r\n\r\n```\r\n[main] INFO io.bootique.jdbc.test.DefaultDatabaseChannel - SELECT COUNT(*) FROM \"table1\"\r\nStopping all JVM Derby servers...\r\n\r\njava.lang.RuntimeException: Error running SQL: SELECT COUNT(*) FROM \"table1\"\r\n\r\n\tat io.bootique.jdbc.test.DefaultDatabaseChannel.select(DefaultDatabaseChannel.java:51)\r\n\tat io.bootique.jdbc.test.Table.selectOne(Table.java:192)\r\n\tat io.bootique.jdbc.test.Table.getRowCount(Table.java:293)\r\n\tat io.bootique.cayenne.test.CayenneTestDataManagerTxIT.testDataSourceDoesNotAutocommit(CayenneTestDataManagerTxIT.java:27)\r\n...\r\nCaused by: java.sql.SQLSyntaxErrorException: Table/View 'table1' does not exist.\r\n\tat org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)\r\n```"},"comment":{"url":"https://api.github.com/repos/bootique/bootique-cayenne/issues/comments/378201498","html_url":"https://github.com/bootique/bootique-cayenne/issues/44#issuecomment-378201498","issue_url":"https://api.github.com/repos/bootique/bootique-cayenne/issues/44","id":378201498,"user":{"login":"andrus","id":42668,"avatar_url":"https://avatars1.githubusercontent.com/u/42668?v=4","gravatar_id":"","url":"https://api.github.com/users/andrus","html_url":"https://github.com/andrus","followers_url":"https://api.github.com/users/andrus/followers","following_url":"https://api.github.com/users/andrus/following{/other_user}","gists_url":"https://api.github.com/users/andrus/gists{/gist_id}","starred_url":"https://api.github.com/users/andrus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andrus/subscriptions","organizations_url":"https://api.github.com/users/andrus/orgs","repos_url":"https://api.github.com/users/andrus/repos","events_url":"https://api.github.com/users/andrus/events{/privacy}","received_events_url":"https://api.github.com/users/andrus/received_events","type":"User","site_admin":false},"created_at":"2018-04-03T10:19:35Z","updated_at":"2018-04-03T10:19:35Z","author_association":"COLLABORATOR","body":"fixed long ago, as we upgraded to B2."}}
{"actor":{"display_login":"andrus"}}