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:
bash
jdbc:sqlserver://<host>:<port>;encrypt=true;database=<database>
jdbc:sqlserver://<host>:<port>;encrypt=true;database=<database>
Driver Download: Link
MariaDB Server
Class name: org.mariadb.jdbc.Driver
URL string template:
bash
jdbc:mariadb://<host>:<port>/<database>
jdbc:mariadb://<host>:<port>/<database>
Driver Download: Link
MySQL Server
Class name: com.mysql.cj.jdbc.Driver
URL string template:
bash
jdbc:mysql://<host>:<port>/<database>
jdbc:mysql://<host>:<port>/<database>
Driver Download: Link
Oracle
Class name: oracle.jdbc.OracleDriver
URL string template
bash
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(HOST=<host>)(PORT=<port>)(PROTOCOL=<protocol>))(CONNECT_DATA=(SERVICE_NAME=<database>)))
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:
bash
jdbc:sap://<host>:<port>/?encrypt=true&validateCertificate=false
jdbc:sap://<host>:<port>/?encrypt=true&validateCertificate=false
Driver Download: Link
SingleStore
Class name: com.singlestore.jdbc.Driver
URL string template:
bash
jdbc:singlestore:[loadbalance:|sequential:]//<host>:<port>/<database>
jdbc:singlestore:[loadbalance:|sequential:]//<host>:<port>/<database>
Driver Download: Link
Teradata
Class name: com.teradata.jdbc.TeraDriver
URL string template:
bash
jdbc:teradata://<host>:<port>/DATABASE=<database>
jdbc:teradata://<host>:<port>/DATABASE=<database>
Driver Download: Link