Fork me on GitHub
#sql
<
2022-08-10
>
slipset07:08:19

So, a CVE against the postgres jdbc driver is out https://nvd.nist.gov/vuln/detail/CVE-2022-31197 . From a quick search of next-jdbc it seems like next-jdbc does not use refreshRow

seancorfield16:08:48

I can't say I'd even heard of that method 🙂

Noah Bogart18:08:02

Is it possible to get namespaced keys in result sets in clojure.jdbc? I'm sadly unable to move to jdbc.next at this time

seancorfield18:08:04

You can use the :qualifier option -- but that will just namespace all columns with the same, fixed ns.

seancorfield18:08:52

There's no machinery in c.j.j to expose how to get table names for columns in a result set.

seancorfield18:08:20

You are aware that you can use c.j.j and next.jdbc side-by-side and convert your code one query at a time @UEENNMX0T?

Noah Bogart19:08:27

Yeah I'm aware, but we've built some common functions to do quoting and formatting of our honeysql v1 queries lol and we don't wanna do adhoc queries at the moment

Noah Bogart19:08:03

Thanks for the quick reply, I'll keep exploring my options

seancorfield19:08:52

Heh, at work, we have both c.j.j and next.jdbc, and both HoneySQL v1 and v2, and we're very slowly migrated from the formers to the latters 🙂

seancorfield19:08:03

Just as we're very slowly migrating to Polylith 🙂

Noah Bogart19:08:33

okay, figured out a solution for the moment: column aliases. [:o.id "o_id"] . it's bad lol but it works for the situation i'm in.