Here we will list down the sample connection urls used in the jdbc examples at javajee.com.

Oracle Database 11g JDBC Drivers and Connection String

Driver Download Url

http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html

Driver names include ojdbc5.jar for java 5,  ojdbc6.jar for java 6 etc.

Sample Connection String for Oracle XE

jdbc:oracle:thin:@localhost:1521:XE

Note:

 To use the standard JDBC4.0 java.sql.SQLXML interface with JDBC 11.2.0.3, you need to use xdb6.jar (instead of xdb.jar) from the 11.2.0.3 distribution.

MySQL JDBC Connector and Connection String

Driver Download Procedure:

1. Search for MySQL JDBC Connector, get driver names such as mysql-connector-java-5.0.8, mysql-connector-java-5.1.24.
2. You need .jar file, not the .zip or .tar. find the .jar within the zip.
3. Or download and use the .jar by searching the name with .jar (I got it from jarfinder.com url in search results)

Sample connection String for MySQL

jdbc:mysql://localhost:3307/testdb

Known Issues with MySQL Drivers

• When using the mysql-connector-java-5.0.8 driver, you need to use Class.forname(com.mysql.jdbc.Driver);  before calling DriverManager.getConnection(url, username, password); This is not required with mysql-connector-java-5.1.24 dricer.
• When using the mysql-connector-java-5.0.8 driver, prepared statement call will not take space in a table name or a stored proc name even if it is properly quoted.  For example, consider con.prepareCall("{call `sp_with_space in name`()}");. It will give an error: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: FUNCTION sp_with_space does not exist. But this will work with mysql-connector-java-5.1.24 driver.

MSSQL JDBC Connector and Connection String

Driver Download Url

http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774

Driver name is sqljdbc4.jar

Sample connection String for MS SQL Server

jdbc:sqlserver://localhost:1433;databaseName=hiberdb

Important Note

Urls and driver issues mentioned here are based on the time of updating the details for a particular driver/database. If you find any change of url/behaviour, please do let us know.