Skip to content

nik-31/csv_to_db_batch_application

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 

Repository files navigation

Spring Batch CSV to Database Application

This Spring Batch application is designed to efficiently process CSV files and store the data into a relational database. By leveraging the power of Spring Batch, it provides a robust and scalable solution for handling large datasets with ease.

Features

  • CSV File Processing: Supports reading data from CSV files.
  • Database Integration: Persists data into a relational database.
  • Configurable: Easily configurable to adapt to different CSV formats and database schemas.
  • Scalable: Handles large datasets efficiently through batch processing.
  • Logging: Utilizes logging to capture application events and errors.
  • Error Handling: Provides mechanisms to handle errors gracefully during processing.

Prerequisites

Before running the application, ensure that you have the following prerequisites installed:

  • Java Development Kit (JDK) 8 or higher
  • Apache Maven
  • MySQL/PostgreSQL/Oracle/SQL Server (choose the database according to your configuration)

Configuration

  1. Database Configuration: Update application.properties with your database connection details.
  2. CSV File: Place your CSV file in the designated directory or specify the file path in the configuration.
  3. Spring Batch Configuration: Adjust batch job configurations (job.xml or Java configuration) as per your requirements.

Running the Application

  1. Clone the repository to your local machine.

    git clone https://github.com/yourusername/csv_to_db_batch_application.git
  2. Navigate to the project directory.

    cd csv_to_db_batch_application
  3. Build the application using Maven.

    mvn clean package
  4. Execute the JAR file.

    java -jar target/csv_to_db_batch_application.jar

Usage

  1. Place your CSV file in the configured directory or provide the file path in the batch configuration file.
  2. Run the application using the provided instructions.
  3. Monitor the logs to track the progress and any errors during processing.
  4. Once processing completes, verify the data in your database.

Contributing

Contributions are welcome! If you encounter any issues or have suggestions for improvements, please feel free to open an issue or submit a pull request.

License

This project is licensed under the MIT License. Feel free to modify and distribute the code for your own purposes.

Acknowledgements

This application is built with Spring Batch, a powerful framework for batch processing within the Spring ecosystem. We extend our gratitude to the Spring community for their contributions and support.


Feel free to customize this README based on your specific project requirements and preferences. Happy coding!

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages