We have a project with MySQL database and Spring as the framework. I am very new to Spring and looking to implement the database access layer and found that there are several options available, like
- Using Spring + Hibernate
- Using Spring JDBC Template
- Using Spring ORM Module
I have gone through the various posts in stackoverflow and did a bit of research on the web, but every question had different answers supporting different options. Also, I did see a mention about Spring JDBC template not being recommended now.
The application might have approximately 1000 transactions per hour and have 60% reads and 40% writes, approximately.
Can anyone help me in finding an answer as to which of the 3 options is suitable and why ? Or, if you can point me to some resources, that would be highly appreciated as well.