JDBC Class name and URL Examples

The following is a small sample library of JDBC class names, connection URI's and download links for a selection of commonly used databases.

Microsoft SQL Server

Class name: com.microsoft.sqlserver.jdbc.SQLServerDriver

URL string template:

jdbc:sqlserver://<host>:<port>;encrypt=true;database=<database>

Driver Download: Link

MariaDB Server

Class name: org.mariadb.jdbc.Driver

URL string template:

jdbc:mariadb://<host>:<port>/<database>

Driver Download: Link

MySQL Server

Class name: com.mysql.cj.jdbc.Driver

URL string template:

jdbc:mysql://<host>:<port>/<database>

Driver Download: Link

Oracle

Class name: oracle.jdbc.OracleDriver

URL string template

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(HOST=<host>)(PORT=<port>)(PROTOCOL=<protocol>))(CONNECT_DATA=(SERVICE_NAME=<database>)))

Driver Download: Link

SAP Hana

Class name: com.sap.db.jdbc

URL string template:

jdbc:sap://<host>:<port>/?encrypt=true&validateCertificate=false

Driver Download: Link

SingleStore

Class name: com.singlestore.jdbc.Driver

URL string template:

jdbc:singlestore:[loadbalance:|sequential:]//<host>:<port>/<database>

Driver Download: Link

Teradata

Class name: com.teradata.jdbc.TeraDriver

URL string template:

jdbc:teradata://<host>:<port>/DATABASE=<database>

Driver Download: Link