jdbc:<subprotocol>:<dbName>[propertyList]
,
subprotocol
is a driver or database connectivity specific name
(e.g. "mysql", "odbc", "sqlserver" etc.) and the dbName
portion of the URL
identifies a specific database. A database can be in one of many locations:
in the current working directory, on the classpath, in a specific Java DB database home directory,
in an absolute location on your file system or on the network, etc. In this very losely
specified structure each database driver provider can specify a custom syntax of the JDBC URL
its driver expects.
For more details about the general structure of the JDBC URL you can visit the following link: http://home.tiscali.nl/~bmc88/java/sbook/032.html
A good overview of the structure of the JDBC URLs for some of the most used database systems can be found at: http://www.petefreitag.com/articles/jdbc_urls/
Here are some example JDBC URLs:
jdbc:mysql://localhost:3306/db1
jdbc:microsoft:sqlserver://serverName\instanceName:1433
jdbc:sqlserver://serverName;instanceName:1433[;property=value]
jdbc:sqlserver://smi-test:1433;instanceName=BIOSTORM;databasename=ITN
:@
" is host:port:sid
):
jdbc:oracle:thin:@pcora5.gsi.de:1521:had3p1
jdbc:oracle:oci7:@mydatabase
jdbc:postgresql://localhost:5432/test
For more information please refer to http://protegewiki.stanford.edu/index.php/DataMaster