How to create a database using JDBC in Clojure?

Question

This is what I have tried, starting with clojure.java.jdbc and a map containing the database connection details:

(:require '[clojure.java.jdbc :as j]))

(def mysql-db {:dbtype "mysql", :dbname "changelog_development", :user "root", :password "", :useSSL true, :verifyServerCertificate false}

First I tried to use execute but it cannot use the given connection configuration because the database does not yet exist:

(j/execute! mysql-db "CREATE DATABASE changelog_development") ;; MySQLSyntaxErrorException Unknown database 'changelog_development'

So I remove that dbname key and tried again, however the error says I have a missing parameter:

(j/execute! (dissoc mysql-db :dbname) "CREATE DATABASE changelog_development") ;; IllegalArgumentException db-spec {:dbtype "mysql", :user "root", :password "", :useSSL true, :verifyServerCertificate false} is missing a required parameter

Piotrek Bzdyl · Accepted Answer · 2017-01-23 12:41:45Z

5

clojure.java.jdbc connection spec has many possible formats. The one with keys for :dbtype, :user etc requires that you also specify a :dbname.

You can also specify your connection spec using a connection URI instead and execute your statement again:

{:connection-uri "jdbc:mysql://localhost/?user=root&password="}

answered Jan 23, 2017 at 12:41

Piotrek Bzdyl

13.2k1 gold badge36 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create a database using JDBC in Clojure?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related