Hibernate JDBC Driver Connection URL strings

Below are the details of connection properties while connecting with different database.

Oracle

To connect with Oracle database JDBC connection properties look as follows:

JDBC Driver oracle.jdbc.OracleDriver
JDBC Url jdbc:oracle:thin:@localhost:1521/oradb
Hibernate Dialect org.hibernate.dialect.Oracle12cDialect

 

MySQL

To connect with MySQL database JDBC connection properties look as follows:

JDBC Driver com.mysql.jdbc.Driver
JDBC Url jdbc:mysql://localhost/upsilonwin_db
Hibernate Dialect org.hibernate.dialect.MySQL57Dialect

 

PostgreSQL

To connect with PostgreSQL database JDBC connection properties look as follows:

JDBC Driver org.postgresql.Driver
JDBC Url jdbc:postgresql://localhost/upsilonwin_db
Hibernate Dialect org.hibernate.dialect.PostgreSQL95Dialect

 

Microsoft SQL Server

To connect with MS SQL Server database JDBC connection properties look as follows:

JDBC Driver com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC Url jdbc:sqlserver://localhost;instance=SQLEXPRESS;
databaseName=upsilonwin_db
Hibernate Dialect org.hibernate.dialect.SQLServer2012Dialect

 

H2

To connect with H2 database JDBC connection properties look as follows:

JDBC Driver org.h2.Driver
JDBC Url jdbc:h2:mem:upsilonwin_db
Hibernate Dialect org.hibernate.dialect.H2Dialect

 

Please suggest me some more database name for which I should mention the connection properties details here.

Leave a Reply

Your email address will not be published. Required fields are marked *