> Why do you need the catalog?

I wanted to make a connection to the same database where the code is executing.
So to construct a connection url I wrote jdbc:h2:tcp://localhost/ + CATALOG

I assume the terminology goes like this
CATALOG = DATABASE

And DATABASE() function also returns the name in all uppercase.

So if I have named my database in mixed case there is no programmatic way to
figure out the url to the current database.

>  No, I think that's not required.

Heh. I like your style. Compact ;-)
I have had already problems writing sometimes the database name somewhere all lowercase and somewhere in all uppercase and wondered, where have the tables,updates etc disappeared. I think it is a very rare case that someone would need the ability to have databases named
so that they only differ in their casing.
Also this would bring consistency between operating systems.
So I see only plusses in this one.
But I have to admit that you are right. It is not required. :-D

- rami

On 28.5.2010 19:46, Thomas Mueller wrote:
Hi,

a file named fOo.h2.db is created
Inside the database that db is referred to as catalog FOO
Why do you need the catalog? It is supported for compatibility (with
OpenOffice as far as I remember).

So since the catalog and database name are case insensitive (all uppercase)
I think the file name should be too.
No, I think that's not required.

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