remove the autocommit=off part of your URL.
On 2012-10-18 15:55, priyanka wrote:
hello sir,
Iam using latest version h2 database h2-1.3.169
I have deleted some tables from my H2 database...Now i want to shrink
the empty spaces..
but according to forums i got the information as
H2 doesn't shrink the data, or index files so it's possible there is
empty space in it.
so i can use script files for for it to take backup.sql
and again run the script
This is my url
jdbc:h2:tcp://localhost/~/abc;mvcc=true;lock_timeout=100000;lock_mode=0;auto_reconnect=true;auto_server=true;AUTOCOMMIT=OFF
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
