Introduction

Ever wanted to connect to a relational database using Java and didn’t know the URL connection string?

Then, this article is surely going to help you from now on.

Connect to a relational database using #Java with JDBC Driver Connection URL strings - @vlad_mihalcea https://t.co/vdCpoWvrIE pic.twitter.com/hy2OuQrYkC

— Java (@java) February 15, 2018

Oracle

The JDBC connection properties look as follows:

And, if you want to connect using a JDBC DataSource, this is what you need to use:

OracleDataSource dataSource = new OracleDataSource();
dataSource.setDatabaseName("high_performance_java_persistence");
dataSource.setURL("jdbc:oracle:thin:@localhost:1521/orclpdb1");
dataSource.setUser("oracle");
dataSource.setPassword("admin");

MySQL

The JDBC connection properties look as follows:

And, if you want to connect using a JDBC DataSource, this is what you need to use:

MysqlDataSource dataSource = new MysqlDataSource();
dataSource.setURL( 
    "jdbc:mysql://localhost/high_performance_java_persistence"
);
dataSource.setUser("mysql");
dataSource.setPassword("admin");

PostgreSQL

The JDBC connection properties look as follows:

And, if you want to connect using a JDBC DataSource, this is what you need to use:

PGSimpleDataSource dataSource = new PGSimpleDataSource();
dataSource.setDatabaseName("high_performance_java_persistence");
dataSource.setServerName("localhost");
dataSource.setUser("postgres");
dataSource.setPassword("admin");

SQL Server

The JDBC connection properties look as follows:

And, if you want to connect using a JDBC DataSource, this is what you need to use:

SQLServerDataSource dataSource = new SQLServerDataSource();
dataSource.setURL(
    "jdbc:sqlserver://localhost;instance=SQLEXPRESS;" +
    "databaseName=high_performance_java_persistence;" 
);
dataSource.setUser("sa");
dataSource.setPassword("adm1n");

MariaDB

The JDBC connection properties look as follows:

Db2 Express-C

The JDBC connection properties look as follows:

SAP HANA

The JDBC connection properties look as follows:

Informix

The JDBC connection properties look as follows:

HSQLDB

The JDBC connection properties look as follows:

And, if you want to connect using a JDBC DataSource, this is what you need to use:

JDBCDataSource dataSource = new JDBCDataSource();
dataSource.setUrl("jdbc:hsqldb:mem:test");
dataSource.setUser("sa");
dataSource.setPassword("");

H2

The JDBC connection properties look as follows:

Derby

The JDBC connection properties look as follows:

That’s it!

If you enjoyed this article, I bet you are going to love my Book and Video Courses as well.

And there is more!

You can earn a significant passive income stream from promoting all these amazing products that I have been creating.

If you're interested in supplementing your income, then join my affiliate program.

Conclusion

Knowing the JDBC Driver Connection URL strings is mandatory if you want to connect to a relational database system from a Java application.

If there is a database system that I forgot to add, add a comment and I’ll update the article.

Insert details about how the information is going to be processed

DOWNLOAD NOW