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 […]