A JDBC URL provides a way of identifying a database so that the appropriate
driver recognizes it and connects to it. In the
After the driver is loaded, an application must specify the correct database
connection URL to connect to a specific database. The
A JDBC URL always starts with jdbc:. After that, the format for the database connection URL depends on the JDBC driver.
Here is the format for the database connection URL for connecting to an
existing
The format for the database connection URL for connecting to an existing
The italicized items stand for something the user fills in:
The name of the database you want to connect to. This might also include the file system path to the database.
One or more of the supported
attributes of the database connection URL, such as ;upgrade=true, create=true or territory=ll_CC.
For more information, see the
The name of the machine where the server is running. It can be the name of the machine or the address.
The port number used by the server framework
Officially, the portion of the database connection URL called the protocol is jdbc:, just as http:// is a protocol in Web URLs. However, the second portion of the database connection URL (everything between jdbc: and databaseName), which is called the subprotocol, is informally considered part of the protocol. Later in this book you might see references to protocol. Consider protocol to be everything that comes before databaseName.
For complete information about the database connection URL, see
the