How do I modify HSQL default schema?

Question

I am creating HSQL memory db using Hibernate. The connection URL in Hibernate config file looks like this

<property name="connection.url">jdbc:hsqldb:mem:mock_db</property>

The default name of schema is Public. Suppose I want to change that to TEST I have tried this but it didn't change the name of schema.

<property name="hibernate.default_schema">TEST</property>

Do you guys know how I could do this? It would be convenient if I could do this in hibernate configuration file.

Thank in advance.

Answer 1

Old - To be used for clients written before HSQLDB schema support:

<property name="connection.url">jdbc:hsqldb:mem:mock_db;default_schema=XXX</property>

New - Users may change their base default schema name with the comand:

SET INITIAL SCHEMA <schemaname>;