Question 1

Is clojure.java.jdbc still maintained?

Accepted Answer

No, it is considered inactive and superseded by next.jdbc. The README states it will only receive critical bug fixes, and the maintainer recommends next.jdbc for new projects.

Question 2

How do I connect to PostgreSQL with clojure.java.jdbc?

Accepted Answer

Use a db-spec map with :dbtype set to 'postgresql', along with :dbname, :user, :password, and other options. Example from the README: {:dbtype 'postgresql' :dbname 'mypgdatabase' :user 'myuser' :password 'secret' :ssl true}.

Question 3

clojure.java.jdbc vs next.jdbc: which is better?

Accepted Answer

For new projects, next.jdbc is better as it is faster, more modern, and actively maintained. clojure.java.jdbc is only suitable for maintaining existing codebases that already depend on its API.

Question 4

What databases does clojure.java.jdbc support?

Accepted Answer

It supports multiple databases including PostgreSQL, MySQL, SQLite, Derby, H2, and Microsoft SQL Server, but you must manually add the JDBC driver dependencies for each, as listed in the README.

Question 5

How to handle transactions in clojure.java.jdbc?

Accepted Answer

Use the with-db-transaction macro to wrap operations, which supports options like :isolation for control. The README mentions transaction utilities in the connection management section.

Question 6

Can I use clojure.java.jdbc with Clojure 1.12?

Accepted Answer

Yes, version 0.7.12 requires Clojure 1.7 or later, and the change log notes testing against Clojure 1.12, but support for older versions has been dropped in recent releases.

Question 7

How to migrate from clojure.java.jdbc to next.jdbc?

Accepted Answer

Migration involves updating dependencies and adapting to next.jdbc's different API. Refer to next.jdbc's documentation for specific steps, as the README highlights it as a 'next generation' replacement with a better interface.

clojure.java.jdbc

What is clojure.java.jdbc?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Frequently Asked Questions