Update Pet Clinic to use HSQL as an embedded database [SPR-5429]

[spring-projects-issues]

Scott Andrews opened SPR-5429 and commented

The Pet Clinic sample application currently uses an external HSQL or MySQL database. An embedded HQSL database is much easier for users to get up an running. The old data source configurations can remain commented for those still wishing to use an external database.

---

Affects: 3.0 M1

This issue is a sub-task of #10156

Referenced from: commits 7dcb3b5, 16c9391, 300e4d7

[spring-projects-issues]

Scott Andrews commented

Created DbcpDataSourceFactory factory bean to create and populate a dbcp based connection pool. The factory bean is based on EmbeddedDataSourceFactory from the JavaConfig version of Pet Clinic. The new DbcpDataSourceFactory has been tested with HSQL in embedded and stand-alone modes.

[spring-projects-issues]

Scott Andrews commented

Removed support for running HSQL in stand-alone mode. Out of the box embedded HSQL and MySQL are supported.