Hi, I'm not sure if you got my previous mail in which I wrote "Could you post a reproducible test case? I can't reproduce the problem"
Regards, Thomas On Fri, Oct 19, 2012 at 7:13 AM, priyanka priya <[email protected]>wrote: > > Thank you so much for replying sir, > > I have tried with dis 2 urls then also iam facing the same exception > > jdbc:h2:tcp://localhost/~/abc; > > > jdbc:h2:tcp://localhost/~/abc;mvcc=true;lock_timeout=100000;auto_reconnect=true;auto_server=true > > > Out of memory.; SQL statement: > SCRIPT > [90108-169]<https://192.168.123.109:8082/tools.do?jsessionid=e9ff1c9826858a84d39747b47fa8a5cb#>90108/90108 > (Help)<http://h2database.com/javadoc/org/h2/constant/ErrorCode.html#c90108> > > Please help me... > > On Thu, Oct 18, 2012 at 11:55 PM, Thomas Mueller < > [email protected]> wrote: > >> 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. >> > > -- > 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.
