Hi Chris Schanck Thanks It works :)
On Apr 10, 9:31 am, Chris Schanck <[email protected]> wrote: > Ah Brish, good to see you're still here, still pushing your durability > concerns. Enjoy! True durability is for Angels. > > sleepycat, Here's a version that seems to work fine for me; I trimmed your > connection urls a bit for clarity, but the main thing is you can't use LOG=0 > and expect any durability; the log is what is reprocessed on reconnection > for transactions that were closed dirtily. LOG=2 logs index and data > changes; LOG=1 would probably be sufficient (Thomas correct me if my memory > is faulty). But if you don't LOG, you won't get any changes but those in > perfectly closed transactions. That said, I've seen similar issues in Oracle > and Postgres if you remove all the mechanism that exist for such > interuptions. > > Chris > > package test; > > import java.sql.Connection; > import java.sql.DriverManager; > import java.sql.Statement; > > /** > * @author sleepycat > * > */ > public class H2Test > { > /* > * > */ > /** > * @param args > */ > public static void main(String[] args) > { > try > { > Class.forName("org.h2.Driver"); > Connection connection = > DriverManager.getConnection("jdbc:h2:file:c:/datatbl;LOG=2;LOCK_MODE=3;USER=sa"); > Statement statement = connection.createStatement(); > statement.execute("CREATE TABLE DATATBL (KEY VARCHAR(20),VALUE > VARCHAR(20))"); > statement.execute("INSERT INTO DATATBL VALUES('ABC','ABC')"); > statement.execute("INSERT INTO DATATBL VALUES('XYZ','XYZ')"); > statement.execute("INSERT INTO DATATBL VALUES('ASDF','ASDF')"); > statement.close(); > connection.close(); > > connection = > DriverManager.getConnection("jdbc:h2:file:c:/datatbl;LOG=2;LOCK_MODE=3;USER=sa"); > statement = connection.createStatement(); > System.out.println(statement.executeUpdate("UPDATE DATATBL SET > KEY='123' WHERE KEY = 'ABC'")); > connection.commit(); > System.out.println("done forcefull close the program"); > Thread.sleep(10 * 60 * 1000L); > } > catch (Exception exception) > { > exception.printStackTrace(); > } > } > > } > On Thu, Apr 9, 2009 at 9:53 PM, Brish <[email protected]> wrote: > > > On Apr 9, 1:37 am, sleepycat <[email protected]> wrote: > > > I want to use h2 in embedded mode. But in case of any failure i want > > > the transaction to be durable. > > > i have also tried enableing trace of h2 which shows commit is > > > executed. > > > H2 doesn't support true durability. > > > Brish > > -- > C. Schanck --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
