Fork me on GitHub
#sql
<
2017-07-06
>
danielcompton00:07:32

@petr.mensik I have a kinda similar problem, this is how I solved it:

(extend-protocol jdbc/IResultSetReadColumn
  OffsetDateTime
  (result-set-read-column [v _ _]
    (to-instant v))

  Timestamp
  (result-set-read-column [v _ _]
    (.toInstant v)))

(extend-type Instant
  jdbc/ISQLParameter
  (set-parameter [v ^PreparedStatement stmt idx]
    (.setTimestamp stmt idx (Timestamp/from v))))

seancorfield06:07:30

[org.clojure/java.jdbc "0.7.0-beta5"] is available with support for :auto-commit? option on connections, to help support streaming result sets.