Question

Suppose you have a Java DB database on your system named InventoryDB. What database URL would you use in a Java program to get a connection to the database?

Short answer

Answer: The database URL for a Java DB database named InventoryDB is `jdbc:derby:InventoryDB`.

Step-by-step solution

Understand Java DB URL format

The typical format for connecting to a Java DB (Derby) database using JDBC is: `jdbc:derby:[subsubprotocol:][databaseName][;attributes]` where: - `jdbc:derby:` indicates that we are using the Derby JDBC driver to connect to the Derby database. - `subsubprotocol` specifies how the database connection is made; for this exercise, we assume the embedded mode (`"//localhost"` can be used for network mode). - `databaseName` is the name of the Derby database. - `attributes` are optional parameters used to configure the connection.

Replace `databaseName` in the URL format

Replace `databaseName` with InventoryDB: `jdbc:derby:InventoryDB[;attributes]`

Final Java DB URL

The URL that you would use in a Java program to get a connection to the InventoryDB database is: `jdbc:derby:InventoryDB`