Clojurians Log v2
Clojure programming
Channels
Apps
sql 2023-09-20
erwinrooijakkers 2023-09-20T16:41:53.755829Z
how do i turn a vector of maps into a ResultSet? or something that can be bulk inserted using
(def bulk-copy (com.microsoft.sqlserver.jdbc.SQLServerBulkCopy. connection-string))
(.setDestinationTableName bulk-copy table-name)
(.writeToServer bulk-copy ...)erwinrooijakkers 2023-09-20T16:48:53.027819Z
my approach now is to implement the interface myself, since i cannot find any libraries that go from raw data to resultset
erwinrooijakkers 2023-09-20T16:49:41.463519Z
only it’s too big
erwinrooijakkers 2023-09-20T16:54:55.014629Z
maybe i can use a CSV and insert SQLServerBulkCSVFileRecord
erwinrooijakkers 2023-09-20T16:55:03.730459Z
data is originally csv
erwinrooijakkers 2023-09-20T16:55:30.545849Z
but in-memory only
erwinrooijakkers 2023-09-20T17:13:22.791449Z
this example should work: https://myadventuresincoding.wordpress.com/2018/04/01/java-using-sqlserverbulkcopy-in-java-with-an-inputstream/