{"action":"created","issue":{"url":"https://api.github.com/repos/robolectric/robolectric/issues/1890","labels_url":"https://api.github.com/repos/robolectric/robolectric/issues/1890/labels{/name}","comments_url":"https://api.github.com/repos/robolectric/robolectric/issues/1890/comments","events_url":"https://api.github.com/repos/robolectric/robolectric/issues/1890/events","html_url":"https://github.com/robolectric/robolectric/issues/1890","id":87683911,"number":1890,"title":"ShadowSQLiteConnection$Connections.execute fails while testing sqlite operations in different test case","user":{"login":"rsingh31","id":12858978,"avatar_url":"https://avatars.githubusercontent.com/u/12858978?v=3","gravatar_id":"","url":"https://api.github.com/users/rsingh31","html_url":"https://github.com/rsingh31","followers_url":"https://api.github.com/users/rsingh31/followers","following_url":"https://api.github.com/users/rsingh31/following{/other_user}","gists_url":"https://api.github.com/users/rsingh31/gists{/gist_id}","starred_url":"https://api.github.com/users/rsingh31/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rsingh31/subscriptions","organizations_url":"https://api.github.com/users/rsingh31/orgs","repos_url":"https://api.github.com/users/rsingh31/repos","events_url":"https://api.github.com/users/rsingh31/events{/privacy}","received_events_url":"https://api.github.com/users/rsingh31/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2015-06-12T10:26:31Z","updated_at":"2015-07-09T05:11:37Z","closed_at":null,"body":"java.lang.RuntimeException: java.lang.IllegalStateException: Illegal connection pointer 37. Current pointers for thread Thread[pool-1-thread-1,5,main] []\r\n\tat org.robolectric.shadows.ShadowSQLiteConnection$Connections.execute(ShadowSQLiteConnection.java:460)\r\n\tat org.robolectric.shadows.ShadowSQLiteConnection$Connections.prepareStatement(ShadowSQLiteConnection.java:373)\r\n\tat org.robolectric.shadows.ShadowSQLiteConnection.nativePrepareStatement(ShadowSQLiteConnection.java:64)\r\n\tat android.database.sqlite.SQLiteConnection.nativePrepareStatement(SQLiteConnection.java)\r\n\tat android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)\r\n\tat android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)\r\n\tat android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)\r\n\tat android.database.sqlite.SQLiteProgram.__constructor__(SQLiteProgram.java:58)\r\n\tat android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java)\r\n\tat android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java)\r\n\tat android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)\r\n\tat android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1316)\r\n\tat android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1255)"},"comment":{"url":"https://api.github.com/repos/robolectric/robolectric/issues/comments/119820805","html_url":"https://github.com/robolectric/robolectric/issues/1890#issuecomment-119820805","issue_url":"https://api.github.com/repos/robolectric/robolectric/issues/1890","id":119820805,"user":{"login":"rsingh31","id":12858978,"avatar_url":"https://avatars.githubusercontent.com/u/12858978?v=3","gravatar_id":"","url":"https://api.github.com/users/rsingh31","html_url":"https://github.com/rsingh31","followers_url":"https://api.github.com/users/rsingh31/followers","following_url":"https://api.github.com/users/rsingh31/following{/other_user}","gists_url":"https://api.github.com/users/rsingh31/gists{/gist_id}","starred_url":"https://api.github.com/users/rsingh31/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rsingh31/subscriptions","organizations_url":"https://api.github.com/users/rsingh31/orgs","repos_url":"https://api.github.com/users/rsingh31/repos","events_url":"https://api.github.com/users/rsingh31/events{/privacy}","received_events_url":"https://api.github.com/users/rsingh31/received_events","type":"User","site_admin":false},"created_at":"2015-07-09T05:11:37Z","updated_at":"2015-07-09T05:11:37Z","body":"sorry for no update ,@mickele  i resolved issue last week , actually m having static variables (greendao session object ) which needs to be set to null  after every test case , which can be done applying @nenick solution above. "}}