How to specify user & password when adding an H2 database connection? [SOLVED]

I’m trying to add an H2 database connection using the connection string: file:~/mydb

I can see that it finds the file, but then I obviously get the error message:
No matching clause: org.h2.jdbc.JdbcSQLException: Nombre de usuario ó password incorrecto Wrong user name or password [28000-192]

How can I set the username and password?

Is it possible to connect to an H2 server via TCP?

1 Like


I have the same problem.

The solution is put the password and the user in the url connection.

Something like this: file:home\workspace\mydb;PASSWORD=mypass;USER=myuser

Hope help you.