1. In H2 (and many others) database and schema are different things. Database may have multiple schemas.
2. Each database has own connection URL. You can't use multiple URLs in one connection pool and can't use multiple databases in the one pool. Each database must have own connection pool. 3. You can use multiple schemas in one database, in that case you need to have only one connection pool and only one database. Each connection can change its current schema with Connection.setSchema() method and can access objects from other schemas too by prefixing names of objects with it SELECT * FROM SCHEMA1.TABLE1 New schemas can be created with CREATE SCHEMA schemaName command. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/92f84838-5c0a-4f20-87d0-f212729d15da%40googlegroups.com.
