Loading large dataset using ActiveJDBC

Question

I have a SQL script with Insert statements (around 100 rows and might increase in the future) that I would like to execute using ActiveJDBC. Is there a way to do it?

Answer 1

Yes please see this: http://javalite.io/batch_operations - close to the end of the page. We used this to process millions of records from files in batches of 1000 records each

This method presumes that the file has only data, such as CSV file. If you need to execute SQL verbatim, you can use: Base#exec