{"action":"created","issue":{"url":"https://api.github.com/repos/dnvriend/akka-persistence-jdbc/issues/64","repository_url":"https://api.github.com/repos/dnvriend/akka-persistence-jdbc","labels_url":"https://api.github.com/repos/dnvriend/akka-persistence-jdbc/issues/64/labels{/name}","comments_url":"https://api.github.com/repos/dnvriend/akka-persistence-jdbc/issues/64/comments","events_url":"https://api.github.com/repos/dnvriend/akka-persistence-jdbc/issues/64/events","html_url":"https://github.com/dnvriend/akka-persistence-jdbc/issues/64","id":169374061,"number":64,"title":"Getting 'Table \"journal\" not found' error with H2","user":{"login":"devidatta45","id":14850980,"avatar_url":"https://avatars.githubusercontent.com/u/14850980?v=3","gravatar_id":"","url":"https://api.github.com/users/devidatta45","html_url":"https://github.com/devidatta45","followers_url":"https://api.github.com/users/devidatta45/followers","following_url":"https://api.github.com/users/devidatta45/following{/other_user}","gists_url":"https://api.github.com/users/devidatta45/gists{/gist_id}","starred_url":"https://api.github.com/users/devidatta45/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/devidatta45/subscriptions","organizations_url":"https://api.github.com/users/devidatta45/orgs","repos_url":"https://api.github.com/users/devidatta45/repos","events_url":"https://api.github.com/users/devidatta45/events{/privacy}","received_events_url":"https://api.github.com/users/devidatta45/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-08-04T13:27:48Z","updated_at":"2016-08-05T02:53:32Z","closed_at":null,"body":"I am new to akka-persistence and am trying to use H2 database for persistence. I referred the README and added the application.conf file as mentioned. But I am getting the error  when I try to start the application. Do I need to create the tables explicitly ? I saw the h2-schema.sql file, but where to actually keep it in the project ?\r\n\r\n```\r\norg.h2.jdbc.JdbcSQLException: Table \"journal\" not found; SQL statement:\r\nselect \"sequence_number\" from \"journal\" where \"persistence_id\" = ? order by \"sequence_number\" desc limit 1 [42102-192]\r\n\tat org.h2.message.DbException.getJdbcSQLException(DbException.java:345)\r\n\tat org.h2.message.DbException.get(DbException.java:179)\r\n```\r\n"},"comment":{"url":"https://api.github.com/repos/dnvriend/akka-persistence-jdbc/issues/comments/237742798","html_url":"https://github.com/dnvriend/akka-persistence-jdbc/issues/64#issuecomment-237742798","issue_url":"https://api.github.com/repos/dnvriend/akka-persistence-jdbc/issues/64","id":237742798,"user":{"login":"yadavan88","id":9131956,"avatar_url":"https://avatars.githubusercontent.com/u/9131956?v=3","gravatar_id":"","url":"https://api.github.com/users/yadavan88","html_url":"https://github.com/yadavan88","followers_url":"https://api.github.com/users/yadavan88/followers","following_url":"https://api.github.com/users/yadavan88/following{/other_user}","gists_url":"https://api.github.com/users/yadavan88/gists{/gist_id}","starred_url":"https://api.github.com/users/yadavan88/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yadavan88/subscriptions","organizations_url":"https://api.github.com/users/yadavan88/orgs","repos_url":"https://api.github.com/users/yadavan88/repos","events_url":"https://api.github.com/users/yadavan88/events{/privacy}","received_events_url":"https://api.github.com/users/yadavan88/received_events","type":"User","site_admin":false},"created_at":"2016-08-05T02:53:32Z","updated_at":"2016-08-05T02:53:32Z","body":"So, do we need to create the table manually before using it ? This is not for testing. Due to some issues, we are unable to use leveldb in a small device. So, thouht of trying with h2 and use the persist to disk of h2(should not be inmemory). "}}
{"actor":{"display_login":"yadavan88"}}