Download java derby database from CSV

Question

Does Derby have any options for batch inserting data from CSV? The best I could think of was to read line by line in line by line and create a batch expression about updating SQL and run it. For 1 million lines that took between 30-40 minutes, compared to using the mySQL LOAD instruction to load from a CSV file that took 2-3 seconds for the same data

Answer 1

syscs_util.syscs_import_table will do what you want. Here's the docs: http://db.apache.org/derby/docs/10.5/tools/rtoolsimport91458.html#rtoolsimport91458