Geek Answers Handbook

HSQLDB eats all my memory

I use HSQLDB for an application that stores research data, and quite a lot of data. HSQLDB insists on always loading tables into memory. I tried to fix this by setting hsqldb.default_table_type = cached in my persistence.xml, but this does not work.

Is this the wrong place?

persistence.xml

<persistence-unit name="Dvh DB" transaction-type="RESOURCE_LOCAL">
    <class>com.willcodejavaforfood.dvh.entity.Patient</class>
    <class>com.willcodejavaforfood.dvh.entity.Plan</class>
    <class>com.willcodejavaforfood.dvh.entity.Dvh</class>
    <class>com.willcodejavaforfood.dvh.entity.ImportSession</class>
    <class>com.willcodejavaforfood.dvh.entity.Project</class>
    <class>com.willcodejavaforfood.dvh.entity.Course</class>
    <class>com.willcodejavaforfood.dvh.entity.Property</class>
    <properties>
        <property name="javax.persistence.jdbc.url" value="jdbc:hsqldb:./myDvhDb"/>
        <property name="javax.persistence.jdbc.user" value="sa"/>
        <property name="javax.persistence.jdbc.password" value=""/>
        <property name="javax.persistence.jdbc.driver" value="org.hsqldb.jdbcDriver"/>
        <property name="hibernate.dialect" value="org.hibernate.dialect.HSQLDialect" />
        <property name="hibernate.hbm2ddl.auto" value="create-drop" />
        <property name="hsqldb.default_table_type" value="cached" />
    </properties>
</persistence-unit>

When my HSQLDB database is created, I can see its properties file:

hsqldb.default_table_type=memory

thank

+5
source share
1 answer

Could you try putting hsqldb.default_table_type=cachedin the connection string? For instance:jdbc:hsqldb:./myDvhDb;hsqldb.default_table_type=cached

+5
source

More articles:


All Articles