{"action":"opened","issue":{"url":"https://api.github.com/repos/themost-framework/themost-adapters/issues/2","repository_url":"https://api.github.com/repos/themost-framework/themost-adapters","labels_url":"https://api.github.com/repos/themost-framework/themost-adapters/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/themost-framework/themost-adapters/issues/2/comments","events_url":"https://api.github.com/repos/themost-framework/themost-adapters/issues/2/events","html_url":"https://github.com/themost-framework/themost-adapters/issues/2","id":346264038,"node_id":"MDU6SXNzdWUzNDYyNjQwMzg=","number":2,"title":"`show schemas` doesn't work","user":{"login":"damasofc","id":25425595,"node_id":"MDQ6VXNlcjI1NDI1NTk1","avatar_url":"https://avatars2.githubusercontent.com/u/25425595?v=4","gravatar_id":"","url":"https://api.github.com/users/damasofc","html_url":"https://github.com/damasofc","followers_url":"https://api.github.com/users/damasofc/followers","following_url":"https://api.github.com/users/damasofc/following{/other_user}","gists_url":"https://api.github.com/users/damasofc/gists{/gist_id}","starred_url":"https://api.github.com/users/damasofc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/damasofc/subscriptions","organizations_url":"https://api.github.com/users/damasofc/orgs","repos_url":"https://api.github.com/users/damasofc/repos","events_url":"https://api.github.com/users/damasofc/events{/privacy}","received_events_url":"https://api.github.com/users/damasofc/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-07-31T16:28:18Z","updated_at":"2018-07-31T16:28:18Z","closed_at":null,"author_association":"NONE","body":"I was trying to get all the schemas that I have in my H2 DB in I get this error:\r\n`Error: Error running instance method\r\norg.h2.jdbc.JdbcSQLException: Method is not allowed for a query. Use execute or executeQuery instead of executeUpdate; SQL statement:\r\nshow schemas [90001-197]`\r\n\r\nI've noticed that the error is in the function execute in the line 421 of the index.js of H2\r\nthe problem occurs because you have an If asking if the query doesn't starts with select your run this code: \r\n`executeQuery = statement.executeUpdate;`\r\n\r\nbut in this case my query doesn't starts with select but is not a sql statements that insert/update/delete, so that cause the error.\r\n\r\nagain thank you very much for this adapter, \r\n"}}
{"actor":{"display_login":"damasofc"}}