Java database connectivity (JDBC) is the JavaSoft specification of a trendy application programming interface (API) that permits java applications to get entry to database management structures. The JDBC API consists of a set of interfaces and classes written within the Java programming language.

With the use of those popular interfaces and training, programmers can write programs that hook up with databases, ship queries written in based question language (square), and system the consequences.

Because JDBC is a trendy specification, one java program that makes use of the JDBC API can connect with any database management gadget (DBMS), so long as a driving force exists for that particular DBMS.

The JDBC connection properties look as follows:

JDBC URL	jdbc:oracle:thin:@localhost:1521:orclpdb1

Hibernate Dialect	org.hibernate.dialect.Oracle12cDialect

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");

JDBC URL	jdbc:mysql://localhost/high_performance_java_persistence

Hibernate Dialect	org.hibernate.dialect.MySQL8Dialect

MysqlDataSource dataSource = new MysqlDataSource();

    "jdbc:mysql://localhost/high_performance_java_persistence"

JDBC URL	jdbc:postgresql://localhost/high_performance_java_persistence

Hibernate Dialect	org.hibernate.dialect.PostgreSQL95Dialect

PGSimpleDataSource dataSource = new PGSimpleDataSource();

JDBC Driver	com.microsoft.sqlserver.jdbc.SQLServerDriver

JDBC URL	jdbc:sqlserver://localhost;instance=SQLEXPRESS;databaseName=high_performance_java_persistence

Hibernate Dialect	org.hibernate.dialect.SQLServer2012Dialect

SQLServerDataSource dataSource = new SQLServerDataSource();

    "jdbc:sqlserver://localhost;instance=SQLEXPRESS;" +

    "databaseName=high_performance_java_persistence;"

JDBC URL	jdbc:mariadb://localhost/high_performance_java_persistence

Hibernate Dialect	org.hibernate.dialect.MariaDB53Dialect

JDBC URL	jdbc:db2://localhost/high_performance_java_persistence

Hibernate Dialect	org.hibernate.dialect.DB2Dialect

JDBC URL	jdbc:sap://localhost/high_performance_java_persistence

Hibernate Dialect	org.hibernate.dialect.HANAColumnStoreDialect

JDBC URL	jdbc:informix-sqli://localhost:9088/sysuser:INFORMIXSERVER=hpjp

Hibernate Dialect	org.hibernate.dialect.InformixDialect

JDBC URL	jdbc:hsqldb:mem:high_performance_java_persistence

Hibernate Dialect	org.hibernate.dialect.HSQLDialect

JDBCDataSource dataSource = new JDBCDataSource();

dataSource.setUrl("jdbc:hsqldb:mem:test");

JDBC URL	jdbc:h2:mem:high_performance_java_persistence

Hibernate Dialect	org.hibernate.dialect.H2Dialect

JDBC Driver	org.apache.derby.jdbc.EmbeddedDriver

JDBC URL	jdbc:derby:target/tmp/derby/hpjp;databaseName=high_performance_java_persistence;create=true

Hibernate Dialect	org.hibernate.dialect.DerbyTenSevenDialect

In this blog, we will discuss JDBC Driver Connection URL strings

JDBC Driver Connection URL strings

A JDBC driver is a software component enabling a Java application to interact with a database. JDBC drivers are analogous to ODBC drivers, ADO.NET data providers, and OLE DB providers. To connect with individual databases, JDBC (the Java Database Connectivity API) requires drivers for each database.

Since September 2019, the Oracle JDBC Driver is available on Maven Central.

For Java 11 and newer version, use the following Maven dependency:

    <groupId>com.oracle.database.jdbc</groupId>

For Java 8, use the ojdbc8 artifact instead:

For Java 6, use the ojdbc6 artifact instead:

For more details about the proper version to use, check out the following Maven Central link.

The MySQL Driver is available on Maven Central, so just add the following dependency to your pom.xml file:

    <artifactId>mysql-connector-java</artifactId>

    <version>${mysql.version}</version>       

Use this Maven Central link to get the latest artifact version for the MySQL JDBC Driver.

The PostgreSQL Driver is available on Maven Central, so us the following dependency:

    <version>${postgresql.version}</version>

This Maven Central link will tell you which is the latest version of the PostgreSQL JDBC artifact.

While many years ago, the official Microsoft SQL Server JDBC Driver was in a bad shape, to the extent that the Java community created the jTDS open-source JDBC Driver, nowadays, the SQL Server JDBC Driver is open-source and available on both GitHub and Maven Central:

    <groupId>com.microsoft.sqlserver</groupId>

To get the latest version of the SQL Server JDBC Driver, use this Maven Central query link.

You can get the Db2 JDBC Driver either from the IBM website and install it to your local Maven repository, or get it from Maven Central.

    <version>${db2.version}</version>               

To get the latest version of the Db2 JDBC Driver, use this Maven Central query link.

You can get the MariaDB JDBC Driver from Maven Central using the following dependency:

    <artifactId>mariadb-java-client</artifactId>

    <version>${mariadb.version}</version>               

Use this Maven Central link to get the latest artifact version for the MariaDB JDBC Driver.

To get the SAP HANA JDBC driver from Maven central using the following dependency.

Afterward, use the following Maven dependency:

    <groupId>com.sap.cloud.db.jdbc</groupId>

    <version>${hana.version}</version>               

Since 2017, the Informix JDBC Driver is available on Maven Central. Use the following Maven dependency to get it:

    <version>${informix.version}</version>

This Maven Central query link will provide you with the latest version of the Informix JDBC Driver.

Jaybird is the JDBC Driver for Firebird, and you can get it from Maven Central like this:

    <groupId>org.firebirdsql.jdbc</groupId>

    <version>${jaybird.version}</version>

To get the latest version of the Firebird JDBC Driver, use this Maven Central query link.

You can get the HyperSQL JDBC Driver using the following Maven dependency:

Use this Maven Central link to get the latest artifact version for the HSQLDB JDBC Driver.

Let's start the discussion with JDBC Driver Maven dependency list

jdbc driver

Trending Blogposts on jdbc driver

JDBC Driver Connection URL strings

JDBC Driver Maven dependency list

Popular Discussions on jdbc driver

PRODUCTS

QUICK LINKS

LEGAL

jdbc driver

Trending Blogposts on jdbc driver

JDBC Driver Connection URL strings

JDBC Driver Maven dependency list

Popular Discussions on jdbc driver