Sql - Java Desktop Application to Upload CSV Files to Database - Stack Overflow
I'm excavation on desktop employment (Extract Transform Load type of app) that requires uploading of large CSV files (about 6 GB) to a information exploitation Java as front end and Oracle as a backend but I'm open to other databases and tools as well (i.e. I well-tried using Open beginning Java libraries for parsing and uploading CSV files such as: The problem with these libraries is efficiency. For example, It'll income 6 unit of time to upload 4 Gb of CSV file. It can take out whitespaces, load CSV files to various tables, use oracle functions suchs as decode, etcetera Having this experience, I decided to try database utilities for uploading CSV files. However, I soul the following problems: I looked for other probable solutions and constitute brainless databases equivalent SQLite and H2. On SQLite, I use the .import command to transfer CSV files. I turn to H2 info but I have arduous moment uploading since it does not support escaping the header row.