Project used for importing csv file into MySQL database using Apache Commons CSV.

Spring Boot provides some properties with which we can add the exception message, exception class, or even a stack trace as part of the response payload:

server.error.include-message=always
server.error.include-binding-errors=always
server.error.include-stacktrace=on_param
server.error.include-exception=false

Using these Spring Boot server properties in our application.properties we can alter the error response to some extent.

Note that we’ve set the property include-stacktracee to on_trace_param which means that only if we include the trace param in the URL (?trace=true), we’ll get a stack trace in the response payload:

We might want to keep the value of include-stacktrace flag to never, at least in production, as it might reveal the internal workings of our application.

• Spring Web
• Spring Boot
• Spring Data JPA
• Apache Commons CSV
• MySQL Database

• Run the following command in the project root for creating MySQL database in Docker

docker-compose up -d

To set container name as mysql instead of the folder name where docker-compose.yml file is located, use the following command:

docker-compose -f docker-compose.yml -p "mysql" up

• Database connection url:

jdbc:mysql://localhost:3306/employee-db

All URIs are relative to http://localhost:8080/api/v1

Apache Commons CSV User Guide
Hibernate ORM 5.6.10.Final User Guide
Hibernate Natural Ids with @NaturalId
The best way to map a @NaturalId business key with JPA and Hibernate
How to Use Hibernate Natural IDs in Spring Boot

Murat Yıldız

• 0.2
  • Various bug fixes and optimizations
  • See commit change or See release history
• 0.1
  • Initial Release

...

...