I have some problems with an HSQLDB datasource in in-process mode. My datasource is configured like this :
But apparently the "destroy-method="close" is not enough since when I stop my web application, the HSQLDB lock file is left behind and I can't access my database anymore (without rebooting my computer :roll: ).
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
I read on HSQLDB forums that it was because the SHUTDOWN SQL method had to be called so that the lock file can be released, but my question is, how can I integrate that in my Spring configuration ?
Thx in advance.[/code]