Fork me on GitHub
#sql
<
2023-09-20
>
erwinrooijakkers16:09:53

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 ...)

erwinrooijakkers16:09:53

my approach now is to implement the interface myself, since i cannot find any libraries that go from raw data to resultset

erwinrooijakkers16:09:41

only it’s too big

erwinrooijakkers16:09:55

maybe i can use a CSV and insert SQLServerBulkCSVFileRecord

erwinrooijakkers16:09:03

data is originally csv

erwinrooijakkers16:09:30

but in-memory only