sql

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