{"action":"created","issue":{"url":"https://api.github.com/repos/h2database/h2database/issues/216","labels_url":"https://api.github.com/repos/h2database/h2database/issues/216/labels{/name}","comments_url":"https://api.github.com/repos/h2database/h2database/issues/216/comments","events_url":"https://api.github.com/repos/h2database/h2database/issues/216/events","html_url":"https://github.com/h2database/h2database/issues/216","id":119949862,"number":216,"title":"TRANSACTION_READ_UNCOMMITTED does not work since 1.4.178","user":{"login":"bedrin","id":4654384,"avatar_url":"https://avatars.githubusercontent.com/u/4654384?v=3","gravatar_id":"","url":"https://api.github.com/users/bedrin","html_url":"https://github.com/bedrin","followers_url":"https://api.github.com/users/bedrin/followers","following_url":"https://api.github.com/users/bedrin/following{/other_user}","gists_url":"https://api.github.com/users/bedrin/gists{/gist_id}","starred_url":"https://api.github.com/users/bedrin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bedrin/subscriptions","organizations_url":"https://api.github.com/users/bedrin/orgs","repos_url":"https://api.github.com/users/bedrin/repos","events_url":"https://api.github.com/users/bedrin/events{/privacy}","received_events_url":"https://api.github.com/users/bedrin/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-12-02T14:14:41Z","updated_at":"2015-12-07T20:41:12Z","closed_at":null,"body":"Following unit test runs fine using H2 1.4.177 but fails with 1.4.178\r\n\r\n```java\r\npackage h2test;\r\n\r\nimport org.h2.jdbcx.JdbcConnectionPool;\r\nimport org.junit.Test;\r\n\r\nimport java.sql.Connection;\r\nimport java.util.concurrent.atomic.AtomicBoolean;\r\nimport java.util.concurrent.atomic.AtomicReference;\r\n\r\nimport static org.junit.Assert.assertEquals;\r\nimport static org.junit.Assert.assertTrue;\r\n\r\npublic class TestReadUncommitted {\r\n\r\n    @Test\r\n    public void test() throws Throwable {\r\n\r\n        final JdbcConnectionPool dataSource = JdbcConnectionPool.\r\n                create(\"jdbc:h2:mem:test;MVCC=FALSE;LOCK_MODE=0\", \"sa\", \"sa\");\r\n\r\n        dataSource.getConnection().createStatement().execute(\"CREATE TABLE FOO (NAME VARCHAR(255), PRIMARY KEY (NAME))\");\r\n\r\n        final Connection connection = dataSource.getConnection();\r\n        connection.setTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED);\r\n        connection.setAutoCommit(false);\r\n\r\n        assertEquals(1, connection.createStatement().executeUpdate(\"INSERT INTO FOO(NAME) VALUES ('foo')\"));\r\n        assertTrue(connection.createStatement().executeQuery(\"SELECT * from FOO\").next());\r\n\r\n        final AtomicReference<Throwable> exceptionHolder = new AtomicReference<>();\r\n        final AtomicBoolean hasResult = new AtomicBoolean();\r\n\r\n        Thread thread = new Thread(new Runnable() {\r\n\r\n            @Override\r\n            public void run() {\r\n                try {\r\n                    Connection connection = dataSource.getConnection();\r\n                    connection.setAutoCommit(false);\r\n                    connection.setTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED);\r\n                    hasResult.set(connection.createStatement().executeQuery(\"SELECT * from FOO\").next());\r\n                } catch (Throwable e) {\r\n                    exceptionHolder.set(e);\r\n                }\r\n            }\r\n\r\n        });\r\n\r\n        thread.start();\r\n        thread.join();\r\n\r\n        Throwable throwable = exceptionHolder.get();\r\n        if (null != throwable) {\r\n            throw throwable;\r\n        }\r\n        assertTrue(hasResult.get());\r\n\r\n    }\r\n\r\n}\r\n```"},"comment":{"url":"https://api.github.com/repos/h2database/h2database/issues/comments/162655111","html_url":"https://github.com/h2database/h2database/issues/216#issuecomment-162655111","issue_url":"https://api.github.com/repos/h2database/h2database/issues/216","id":162655111,"user":{"login":"bedrin","id":4654384,"avatar_url":"https://avatars.githubusercontent.com/u/4654384?v=3","gravatar_id":"","url":"https://api.github.com/users/bedrin","html_url":"https://github.com/bedrin","followers_url":"https://api.github.com/users/bedrin/followers","following_url":"https://api.github.com/users/bedrin/following{/other_user}","gists_url":"https://api.github.com/users/bedrin/gists{/gist_id}","starred_url":"https://api.github.com/users/bedrin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bedrin/subscriptions","organizations_url":"https://api.github.com/users/bedrin/orgs","repos_url":"https://api.github.com/users/bedrin/repos","events_url":"https://api.github.com/users/bedrin/events{/privacy}","received_events_url":"https://api.github.com/users/bedrin/received_events","type":"User","site_admin":false},"created_at":"2015-12-07T20:41:12Z","updated_at":"2015-12-07T20:41:12Z","body":"@thomasmueller I think that \"Transaction Isolation\" section should state that this isolation level is not supported\r\nhttp://www.h2database.com/html/advanced.html#transaction_isolation"}}