Sound good to explore, thanks!

Istvan

On Feb 4, 9:43 am, Thomas Mueller <[email protected]>
wrote:
> Hi,
>
> > we have table name collisions (for valid reasons).
>
> Did you consider using schemas?
>
> http://h2database.com/html/grammar.html#create_schemahttp://h2database.com/html/grammar.html#set_schema
>
> So put everything in the same database, but use different database URLs:
>
> jdbc:h2:~/test;schema=a
> jdbc:h2:~/test;schema=b
> jdbc:h2:~/test;schema=c
>
> Initially, you need to create the schemas using CREATE SCHEMA A and so
> on. I guess that doesn't matter, because you anyway you need to create
> the tables. If it does matter, you could use an init script, 
> seehttp://h2database.com/html/features.html#execute_sql_on_connection
>
> Regards,
> Thomas

-- 
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.

Reply via email to