Unique Database/Catalog Name

2011-05-01 Thread Anthony
Hi, Is there a way to get a unique database or catalog name? eg: jdbc:h2:mem:abc/test -> catalog name=test jdbc:h2:mem:xyz/test -> catalog name=test But abc/test and xyz/test are different databases and they have the same catalog name. So why do I need a unique database name? I'm implementing a

Re: Unique Database/Catalog Name

2011-05-02 Thread Anthony
Answering my own question.. I was able to get the database name using Internal H2 API String databaseName = ((Session) ((JdbcConnection)conn).getSession()).getDatabase().getName(); On May 2, 1:20 pm, Anthony wrote: > Hi, > > Is there a way to get a unique database or catalog name? > > eg: > jd

Re: Unique Database/Catalog Name

2011-05-06 Thread Thomas Mueller
Hi, > Is there a way to get a unique database or catalog name? This might also help: "select database_path()". 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 h2-database@googlegroups.com. T

Re: Unique Database/Catalog Name

2011-05-12 Thread Thomas Mueller
Hi, I understand. Unfortunately, there is currently no way to get the unique name from the database, except if you use unique database names such as: jdbc:h2:mem:abc -> catalog name=abc jdbc:h2:mem:xyz -> catalog name=xyz Is there a reason why you need to use mem:abc/test instead of mem:abc or m

Re: Unique Database/Catalog Name

2011-05-12 Thread Anthony
Hi, In my application, it create databases for users on demand and each user can have multiple databases. eg: jdbc:h2:mem:/ After understanding the behaviour of H2 Database, there's no reason, why I can't implement it as jdbc:h2:mem:- Thanks for your help. Anthony On May 13, 5:32 am, Thomas