Hi, You should also remove the lock_mode=0 part, unless you are 100% sure you need it. See the FAQ for details.
Regards, Thomas On Thu, Oct 18, 2012 at 3:59 PM, Noel Grandin <[email protected]> wrote: > 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. > -- 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.
