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.
