The standard way to obtain a Connection object is to call the method DriverManager.getConnection, which takes a String containing a connection URL (uniform resource locator). A JDBC connection URL provides a way of identifying a database. It also allows you to perform a number of high-level tasks, such as creating a database or shutting down the system.

An application in an embedded environment uses a different connection URL from that used by applications using the Network Server in a client/server environment. See the for more information on the Network Server.

However, all versions of the connection URL (which you can use for tasks besides connecting to a database) have common features:

• you can specify the name of the database you want to connect to
• you can specify a number of attributes and values that allow you to accomplish tasks. For more information about what you can specify with the connection URL, see .

The connection URL syntax is as follows:

Subsubprotocol, which is not typically specified, determines how looks for a database: in a directory, in a class path, or in a jar file. Subsubprotocol is one of the following:

• directory: The default. Specify this explicitly only to distinguish a database that might be ambiguous with one on the class path.
• classpath: Databases are treated as read-only databases, and all databaseNames must begin with at least a slash, because you specify them "relative" to the classpath directory. See for details.
• jar: Databases are treated as read-only databases. DatabaseNames might require a leading slash, because you specify them "relative" to the jar file. See for details.

  jar requires an additional element immediately before the database name:

  (pathToArchive)

  pathToArchive is the path to the jar or zip file that holds the database.

For detailed reference about connection URL attributes and values, see "Setting attributes for the database connection URL" in the .

The following example shows the use of the connection URL: