Fork me on GitHub
#sql
<
2017-06-01
>
maleghast12:06:08

Hello, anyone "in" here..?

maleghast12:06:09

I am trying to figure out how to add the PostgreSQL JDBC driver as a dependency in a project that uses Boot, in that I want to use the most up to date driver, but I can't figure out how to address it. The library that I want to use, yesql, has an example that looks like this:

[org.postgresql/postgresql "9.4-1201-jdbc41"]
but the latest version of the driver for JDK8 (which is the JVM I am running) is this:
42.1.1 JDBC 42

maleghast12:06:56

I realise I could trial and error it, but does anyone know where I can look up how to express the dependency so that it will "just work"?

maleghast12:06:03

Ok, I went poking around on Maven Central and I think I've nailed it...

maleghast12:06:52

Anyone who cares, it's like this: [org.postgresql/postgresql "42.1.1.jre7"] if you want the latest version of the postgres JDBC library...

nwjsmith15:06:02

@maleghast I've tried to find why the JDBC lib is versioned differently after 9.4.1212, but I can't even find a changelog

nwjsmith15:06:16

have you come across anything?

maleghast15:06:11

Nope, no idea. I can only assume that the postgres team decided to stop tying the version to the version of the DB

maleghast15:06:45

In that that is what it looks like. I have no idea when / how the decision to alter the versioning approach was made.

donaldball15:06:44

The release notes simply say, “Version bumped to 42.0.0 to avoid version clash with PostgreSQL version”

nwjsmith15:06:16

@donaldball do happen to have a link to the release notes?

nwjsmith15:06:27

I gotta bookmark that/

seancorfield16:06:52

FWIW, clojure.java.jdbc is tested against the [org.postgresql/postgresql "9.4.1212.jre7"] driver. I’d have to check what actual version of PostgreSQL I test against… it’s in Docker…

seancorfield16:06:15

…hmm, looks like I just test against whatever is the current, generic postgres Docker registry image/version.

maleghast17:06:12

@seancorfield AFAIK the latest version is backwardly compatible, so there should not be any risk with using a more recent version that the one clojure.java.jdbc is tested against, unless one were to try and use features that were not implemented, right? I am just doing very vanilla CREATE statments, INSERTs and SELECTs

seancorfield17:06:06

Yeah, if someone reported a bug against a specific version combination, I’d make an effort to test against that to repro…

maleghast17:06:07

It's working so far, anyway... 😉