JDBC URL

RazorSQL uses JDBC drivers to connect to the database. JDBC drivers require a piece of information known as a JDBC URL in order to obtain a connection to the database. This URL can be comprised of information such as the name of the server or host on which the database is running, the port on which the database is listening, the name of the database, etc.

RazorSQL displays the format of the JDBC URL in the JDBC URL field for many databases. For example:

jdbc:mysql://<host>:<port>/<database_name>

In the above example, the user should replace the <host>, <port> and <database_name> fields with the appropriate values. For example, if the database you are trying to connect to runs on the host named neptune.acme.com on port 3306, and the database name is TEST, the JDBC URL would be the following:

jdbc:mysql://neptune.acme.com:3306/TEST

Some databases have default ports. For example, the default port for MySQL is 3306. In these cases, it may not be necessary to include the port in the JDBC URL as long as the database is running on the default port. Consult your JDBC driver documentation for more information.