ylliX - Online Advertising Network

The JDBC driver Maven Central coordinates for the most popular RDBMS

Do you need to add a JDBC driver to your application, and don’t know its Maven coordinates? This blog post lists the most popular drivers from the jOOQ integration tests. Look up the latest versions directly on https://central.sonatype.com/ with parameters g:groupId a:artifactId, for example, the H2 database and driver: https://central.sonatype.com/search?q=g%3Acom.h2database+a%3Ah2 The list only includes drivers […]

The JDBC Connection URLs and driver names of the most popular RDBMS

Need to connect to your RDBMS with JDBC and don’t have the JDBC connection URL or driver name at hand? No problem, just look up your RDBMS below: // BigQuery driver = “com.simba.googlebigquery.jdbc42.Driver”; url = “jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=<project-id>;OAuthType=0;OAuthServiceAcctEmail=<service-account>;OAuthPvtKeyPath=path-to-key.json”; // CockroachDB driver = “org.postgresql.Driver”; url = “jdbc:postgresql://<host>/<database>”; // Db2 driver = “com.ibm.db2.jcc.DB2Driver”; url = “jdbc:db2://<host>:50000/<database>”; // Derby driver […]