Skip to content

Instantly share code, notes, and snippets.

@dpick
dpick / copy
Last active August 27, 2016 00:51
Clojure postgres copy table
(ns backfill-spike.core
(:require [byte-streams :as bs]
[clojure.java.jdbc :as jdbc]
[clojure.string :as string]
[clojure.java.io :as io]
[environ.core :refer [env]])
(import org.postgresql.copy.CopyManager)
(import org.postgresql.copy.PGCopyInputStream)
(import org.postgresql.util.PSQLException)
(import java.io.IOException)
(with-resource [c (consumer config)]
shutdown
(doseq [message (messages c "topic")]
(process-message message)))
java.net.SocketException: Connection reset
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)
at java.net.SocketOutputStream.write(SocketOutputStream.java:153)
at org.apache.http.impl.io.AbstractSessionOutputBuffer.write(AbstractSessionOutputBuffer.java:181)
at org.apache.http.impl.io.ContentLengthOutputStream.write(ContentLengthOutputStream.java:115)
at org.apache.http.impl.io.ContentLengthOutputStream.write(ContentLengthOutputStream.java:122)
at org.apache.http.entity.StringEntity.writeTo(StringEntity.java:170)
at org.apache.http.entity.HttpEntityWrapper.writeTo(HttpEntityWrapper.java:89)
at org.apache.http.impl.client.EntityEnclosingRequestWrapper$EntityWrapper.writeTo(EntityEnclosingRequestWrapper.java:108)
at org.apache.http.impl.entity.EntitySerializer.serialize(EntitySerializer.java:117)