How to connect to specific Schema in H2

java h2
Acewin picture Acewin · Feb 16, 2015 · Viewed 29.3k times · Source

So I have created a few schema in H2. How can I connect to a specific schema in H2

For example when I need to connect to a specific schema in SQL Server I have below JDBC URL jdbc:sqlserver://HOSTNAME:PORT;SelectMethod=cursor;instanceName=MYSCHEMA;databaseName=DBNAME

Is this feature available in H2. If not is there a workaround.

I do not want to always access a particular table in my schema instance be accessed like MYSCHEMA.TABLE_NAME

Otherwise I suppose only way out will be to create all table into the default schema that is public

Answer

Rohit S picture Rohit S · Apr 5, 2015

There is such feature supported. See this:

http://www.h2database.com/html/grammar.html#set_schema

You can specify the schema in the connection string:

jdbc:h2:test;SCHEMA=SCHEMA_NAME

You can also change the current schema with:

SET SCHEMA SCHEMA_NAME;

Hope this helps.

Related questions

Spring Boot default H2 jdbc connection (and H2 console)

I am simply trying to see the H2 database content for an embedded H2 database which spring-boot creates when I don't specify anything in my application.properties and start with mvn spring:run. I can see hibernate JPA creating the …

Read More
H2 in-memory database. Table not found

I've got a H2 database with URL "jdbc:h2:test". I create a table using CREATE TABLE PERSON (ID INT PRIMARY KEY, FIRSTNAME VARCHAR(64), LASTNAME VARCHAR(64));. I then select everything from this (empty) table using SELECT * FROM PERSON. So far, …

Read More
Can I have H2 autocreate a schema in an in-memory database?

(I've already seen the H2 database In memory - Init schema via Spring/Hibernate question; it is not applicable here.) I'd like to know if there's a setting in H2 that will allow me to auto-create a schema upon connecting …

Read More