Introduction
In this post, Spring JDBC is integrated with apache cxf RESTful webservice. H2DB has been used as in-memory/filebased databse. There are two sql scripts, one to create table structure required for this example and another sql script to populate tables during application startup. The data can be persisted in a filebased database supported by H2DB. Also the same data can be persisted in-memory i.e.the data will persist, as long as the application is running.
Steps to write code
- In this example, followings have been implemented
- Apache CXF based RESTful webservice
- Log4j integration
- Spring AOP integration
- Spring JDBC integration
- Database transaction control using Spring JDBC
- H2DB integration as a backend file based database (Also have an option to use H2DB as in-memory database)