Save embedded HSQL database to file

Question

For logging and debugging purposes I want to dump an embedded/in-memory HSQL database to a file. Schema + Data. I'm using the spring-framework with hibernate.

I've tried both:

    Session session = sessionFactory.openSession();
    Transaction transaction = session.beginTransaction();

    session.createSQLQuery("BACKUP DATABASE TO '/tmp/backup.tar.gz' BLOCKING");

    transaction.commit();
    session.close();

and

    Session session = sessionFactory.openSession();
    Transaction transaction = session.beginTransaction();

    session.createSQLQuery("SCRIPT '/tmp/backup-data.sql'");

    transaction.commit();
    session.close();

Both to no avail.

There is no special configuration.

Hibernate config:

<jdbc:embedded-database id="dataSource" type="HSQL">
    <jdbc:script location="classpath:spring/batch/database/schema.sql"/>
</jdbc:embedded-database>

<bean id="sessionFactory"
      class="org.springframework.orm.hibernate4.LocalSessionFactoryBean"
      p:dataSource-ref="dataSource">
    <property name="packagesToScan" value="com.domain.*.model"/>
    <property name="hibernateProperties">
        <value>
            hibernate.format_sql=true
            hibernate.dialect=org.hibernate.dialect.HSQLDialect
        </value>
    </property>
</bean>

What did I miss, do I need a different approach, is it even possible?

You are only creating the query, not executing it.

M. Deinum
– M. Deinum

2013-11-26 10:16:42 +00:00
Commented Nov 26, 2013 at 10:16 — M. Deinum
– M. Deinum, Commented Nov 26, 2013 at 10:16

M. Deinum · Accepted Answer · 2013-11-26 10:22:31Z

3

Your code is only creating an instance of a SQLQuery and throws it away. You aren't executing the query.

Add/change to the following

SQLQuery query = session.createSQLQuery("BACKUP DATABASE TO '/tmp/backup.tar.gz' BLOCKING");
query.executeUpdate();

This will execute the query.

answered Nov 26, 2013 at 10:22

M. Deinum

127k22 gold badges236 silver badges254 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

David Rabinowitz · Accepted Answer · 2013-11-26 10:09:06Z

0

Have you tried:

Session session = sessionFactory.openSession();
Transaction transaction = session.beginTransaction();

session.createSQLQuery("BACKUP DATABASE TO '/tmp/' BLOCKING");

transaction.commit();
session.close();

According to the documentation you need to give the directory and HSQL will create the tar.gz file in it.

answered Nov 26, 2013 at 10:09

David Rabinowitz

30.5k16 gold badges95 silver badges125 bronze badges

1 Comment

lulu Over a year ago

Yes I have also tried this. And again just now to be sure ;) This does not work for me either.

Collectives™ on Stack Overflow

Save embedded HSQL database to file

Hibernate config:

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Hibernate config:

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related