How to check if a database exists in Hsqldb/Derby?

I am looking for information how to check if a database exists -- from Java code -- in hsqldb and in Apache derby. In Mysql it is quite easy, because I can query a system table -- INFORMATION_SCHEMA.SCHEMATA -- but these two databases seem not to have such a table.

What is an alternative to mysql query:

 SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = <DATABASE NAME>

to find if a database exists in hsqldb and apache derby?

6
задан Brian Tompsett - 汤莱恩 11 June 2017 в 08:21
поделиться