I managed to solve the problem after spending many hours on this issue. Both of you are right and here is my problem. I can only start and an embedded server db but not in memory. Hence my url should be
%test.db.url=jdbc:h2:play;AUTO_SERVER=TRUE;MODE=MYSQL;LOCK_MODE=0;DB_CLOSE_DELAY=-1 then I need to connect to the db using info from the .lock.db file. In my case the url is jdbc:h2:tcp:// 172.20.10.2:49434/12ff45a8d5228ea09fa5b848476c84f20625b0e01fc Though now I can connect to the play db now but DBVisualizer is complaining about the missing 'public' schema when i select the tables. Any thoughts? Regards chungonn On May 15, 5:54 pm, chungonn <[email protected]> wrote: > Hi, > > I am tried to connect to Play's embedded H2 db using DbVisualizer but > fail. I tried changing Play's H2 settings but didn't help. Connecting > to H2's console is fine though. > > Any help on this is greatly appreciated. > > Here's my setting in application.conf > > %test.jpa.ddl=update > %test.jpa.dialect=org.hibernate.dialect.H2Dialect > %test.db.url=jdbc:h2:mem:play;AUTO_SERVER=TRUE;MODE=MYSQL;LOCK_MODE=0;DB_CLOSE_DELAY=-1 > %test.db.driver=org.h2.Driver > %test.db.user=sa > %test.db.pass= > > Here's the db.url from DbVisualizer > jdbc:h2:tcp://localhost/mem:play > > Below is the error from DbVisualizer > An error occurred while establishing the connection: > > Long Message: > Connection is broken: "Connection refused" [90067-149] > > Details: > Type: org.h2.jdbc.JdbcSQLException > Error Code: 90067 > SQL State: 90067 -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
