How to list database names available in derby server?

Question

Suppose I have connected to the the derby server. I need to know which datagbases are available for me to connect to. Is there a command to do so?

Answer 1

There is no such command. Derby does not maintain an overall registry or catalog of all known databases.

Each database is independent, and can be opened by providing the correct JDBC Connection URL. The JDBC Connection URL specifies the location of the database folder on the server's disk, either as an absolute path name, or relative to the Derby Network Server's "home" directory.

If you have physical access to the server machine, you can perform a filesystem search and look for Derby database folders.

Otherwise, it is the responsibility of the application to keep track of which databases it is using and where they are located.

For more information about the JDBC Connection URL, look here: http://db.apache.org/derby/docs/10.11/devguide/cdevdvlp17453.html

And for more information about controlling the Derby Network Server's home directory, look here: http://db.apache.org/derby/docs/10.11/ref/rrefproper32066.html