как подключить сервер баз данных: HSQLDB в in-process режиме

Я написал приложение в режиме сервера. Теперь же мне необходимо подключить бд в режиме in-process. Ничего не работает. Много что пробовал в applicationContext настраивать. Нужна любая помощь, я не очень опытный.

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx.xsd">

    <context:component-scan base-package="com.haulmont.evgenyshevchenko"/>

    <mvc:annotation-driven/>


    <bean
            class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/view/"/>
        <property name="suffix" value=".jsp"/>
    </bean>

    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
          destroy-method="close">
        <property name="driverClass" value="org.hsqldb.jdbcDriver" />
        <property name="jdbcUrl" value="jdbc:hsqldb:mem:db" />
        <property name="user" value="SA" />
        <property name="password" value="" />
    </bean>

    <bean id="sessionFactory"
          class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="packagesToScan" value="com.haulmont.evgenyshevchenko.entity"/>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.HSQLDialect</prop>
                <prop key="hibernate.show_sql">true</prop>
                <prop key="hibernate.hbm2ddl.auto">create-drop</prop>
            </props>
        </property>
    </bean>

    <bean id="transactionManager"
          class="org.springframework.orm.hibernate5.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory"/>
    </bean>

    <tx:annotation-driven transaction-manager="transactionManager"/>

    <mvc:resources mapping="/resources/**" location="/resources/"/>


</beans>

CREATE TABLE clients (
                         id UUID PRIMARY KEY,
                         fio VARCHAR(40),
                         phonenumber  VARCHAR(20),
                         email VARCHAR(30),
                         passportnumber INTEGER
);

CREATE TABLE credit (
                        id UUID PRIMARY KEY,
                        limit INTEGER,
                        percent  INTEGER
);

INSERT INTO "PUBLIC"."CLIENTS"
( "ID", "FIO", "PHONENUMBER", "EMAIL", "PASSPORTNUMBER" )
VALUES ( '21a80fb6-1ca4-435c-8fb3-2215d145db41', 'Шевченко Евгений Александрович', '79521082228', '[email protected]', 765432);

INSERT INTO "PUBLIC"."CLIENTS"
( "ID", "FIO", "PHONENUMBER", "EMAIL", "PASSPORTNUMBER" )
VALUES ( '1a919417-e33e-4eb8-b23a-4d8126a37f9c', 'Петров Иван Викторович', '79066543456', '[email protected]', 765532);

INSERT INTO "PUBLIC"."CLIENTS"
( "ID", "FIO", "PHONENUMBER", "EMAIL", "PASSPORTNUMBER" )
VALUES ( '5fa960f0-c1ba-41cf-9d82-9d388a00892b', 'Сидорова Мария Николаевна', '79205678990', '[email protected]', 453532);

INSERT INTO "PUBLIC"."CREDIT"
( "ID", "LIMIT", "PERCENT" )
VALUES ( '815691f3-15b7-458a-8ac7-8f87728d6e8f', 100000, 25);

INSERT INTO "PUBLIC"."CREDIT"
( "ID", "LIMIT", "PERCENT" )
VALUES ( '939978d1-be0a-41f2-bd81-d55f175a8982', 300000, 20);

INSERT INTO "PUBLIC"."CREDIT"
( "ID", "LIMIT", "PERCENT" )
VALUES ( 'e7af60d2-ca09-44dc-b9ee-575e566858ad', 500000, 15);

INSERT INTO "PUBLIC"."CREDIT"
( "ID", "LIMIT", "PERCENT" )
VALUES ( '6f9e3671-0dad-4f5f-a867-b08d23ff9eab', 1500000, 10);

INSERT INTO "PUBLIC"."CREDIT"
( "ID", "LIMIT", "PERCENT" )
VALUES ( 'bac6862f-9c88-4296-9aac-be35a6bf3f7e', 5000000, 7);

А этот скрипт необходимо запустить при запуске приложения