Hello All ,
I am very new to this forum and we are planning to evaluate H2 in our
application . Basically our application uses apache-derby as embedded
database and we are planning to evaluate H2 in our application . Data may
not be too huge but we require some way to defragment the database .
In my sample I am trying to connect to the local db
Connection conn =
DriverManager.getConnection("jdbc:h2:~/test;DEFRAG_ALWAYS=TRUE", "sa", "");
so when I close the database using conn.close() I want the database to get
defragment always during the shutdown . This is not happening in my sample
program .But when I try calling statement.execute("shutdown defrag") it
gets defragmented .
What I assume is when I create the connection I want these dbsettings to
get applicable . Is there something I am doing wrong here ?? or is there
any way to defragment database programatically ??
Thanks
Rajasekhar
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
