I have small task where i need to retrieve all the data from text file and insert into Oracle table.
I have created java files which is attached with this project and we need to modify ImportWorkflow and DBImporter java files so that it will encorporate the changes needed to read text files and insert into database table. Before insert we want to delete the table completely everytime and then insert the data. Once the table has been processed of inserting it will be moved to archive directory. This logic is already been built in ImportWorkflow.java.
I am providing sample java files([login to view URL], [login to view URL]) from my previous project which gives an idea of how to read files and insert into database. Just we need to use the same logic of retrieving data from [login to view URL] file and insert it into database table.
We have to use Spring JDBC framework.
I have also attached table DDL which is required to insert the data from text file.
While reading the data from [login to view URL], ignore the string such as 'User Maintenance 27.05.19 16:21', '[GeneralAttributes];' and others which is not needed in database table
13 freelancers are bidding on average €33 for this job
As per your description it will be possible for me complete the task you want. I have reviewed the code from sample file attached in description. Let's have a chat to discuss more about your project.