Re: [h2] h2 Database backup and restore while database is opned using hibernate ORM
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 .
> 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.
>
>
>
--
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/3ef8a651-c2e0-4578-a7f1-e4e04cfed6e7%40googlegroups.com.
Re: [h2] h2 Database backup and restore while database is opned using hibernate ORM
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.|
||
|Filefile
=fileChooser.showSaveDialog(tbTabPaneHome.getScene().getWindow());if(file
!=null){// Save filetry{Sessionsession
=DatabaseUtil.getSessionFactory().openSession();session.beginTransaction();session.createSQLQuery("BACKUP
TO
'"+file.getCanonicalPath()+"'");session.getTransaction().commit();session.close();}catch(IOExceptione){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-database+unsubscr...@googlegroups.com
.
To post to this group, send email to h2-database@googlegroups.com
.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
--
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+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
