Embedded HSQL Database with Spring

This tutorial will show you how you can work with embedded HSQLDB with Spring framework. This application will show you a CRUD(Create, Read, Update and Delete) operations on the fly using embedded HSQLDB.

Sometimes we need to work with an in memory database when we want to demonstrate certain database centric features of an application during development phase. Such situation may be when there is no access to real database server and we want to perform test on an application on the fly using database operations then this may be very helpful. Spring supports many databases such as HSQL, H2, and Derby as default embedded databases but, we can also use an extensible third party API to plug in new embedded database and DataSource implementations.

Spring supports XML as well as Programmatic configuration of beans but, here we will use XML based metadata configuration.

If you already have an idea on how to create a maven project in Eclipse will be great otherwise I will tell you here how to create a maven project in Eclipse. Continue reading “Embedded HSQL Database with Spring”