h2 Database backup and restore while database is opned using hibernate ORM

[abdou amer]

I want to perform backup and restore using hibernate ORM, but i seems that the below code not do any thing.

So, what the propre way to perform backup and restore without corrupting the database.

File file = fileChooser.showSaveDialog(tbTabPaneHome.getScene().getWindow());
        if (file != null) {
            // Save file


            try {


                Session session = DatabaseUtil.getSessionFactory().openSession();
                session.beginTransaction();
                session.createSQLQuery("BACKUP TO '" + file.getCanonicalPath() + "'");
                session.getTransaction().commit();
                session.close();


            } catch (IOException e) {
                e.printStackTrace();
            }

        }

[Ryan How]

You aren't executing the query, only creating it?

session.createSQLQuery("BACKUP TO '" + file.getCanonicalPath() + "'").executeUpdate();

--
You received this message because you are subscribed to the Google Groups "H2 Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email to h2-database...@googlegroups.com.
To post to this group, send email to h2-da...@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

[Peter wein.peter]

Like Ryan mentioned:

session.createSQLQuery("BACKUP TO \'" + file.getCanonicalPath() + "\'").executeUpdate();



was just missing. And for me I had to escape the '-character.

Thank you for the basic approach, which led me to my solution!
For linking, my special problem was also getting from entities to hibernate Sessions:: 
https://groups.google.com/d/msg/h2-database/ri3SiqWezkM/UpVR4t6vFAAJ

[Bruno Santos Silva]

 Restore how works?

Em segunda-feira, 4 de abril de 2016 02:40:07 UTC-3, Ryan How escreveu:

You aren't executing the query, only creating it?

session.createSQLQuery("BACKUP TO '" + file.getCanonicalPath() + "'").executeUpdate();

On 4/04/2016 4:55 AM, abdou amer wrote:

I want to perform backup and restore using hibernate ORM, but i seems that the below code not do any thing.

So, what the propre way to perform backup and restore without corrupting the database.

File file = fileChooser.showSaveDialog(tbTabPaneHome.getScene().getWindow());
        if (file != null) {
            // Save file


            try {


                Session session = DatabaseUtil.getSessionFactory().openSession();
                session.beginTransaction();
                session.createSQLQuery("BACKUP TO '" + file.getCanonicalPath() + "'");
                session.getTransaction().commit();
                session.close();


            } catch (IOException e) {
                e.printStackTrace();
            }

        }

--
You received this message because you are subscribed to the Google Groups "H2 Database" group.

To unsubscribe from this group and stop receiving emails from it, send an email to h2-da...@googlegroups.com.