Re: Making certain transactions more durable

2012-10-27 Thread Noel Grandin
On Sat, Oct 27, 2012 at 3:55 PM, Adam McMahon wrote: > I just want to make sure that I understand how to use the "CHECKPOINT SYNC". > Assuming I use the default durability and the defualt ACCESS_MODE_DATA, then > I can simply call CHECKPOINT SYNC after an important update/insert. And > that is i

Re: Making certain transactions more durable

2012-10-27 Thread Adam McMahon
Thanks for the reply. The H2 community is always helpful! That makes sense with the ACCESS_MODE_DATA. I just want to make sure that I understand how to use the "CHECKPOINT SYNC". Assuming I use the default durability and the defualt ACCESS_MODE_DATA, then I can simply call CHECKPOINT SYNC afte

Re: Left Outer Join Issue in Select query after migrating from HSQL to H2

2012-10-27 Thread Noel Grandin
Well, there is probably some kind of bug in H2, but we're not going to be able to help you unless you can supply us with a self-contained reduced test case. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-d

Re: Making certain transactions more durable

2012-10-27 Thread Noel Grandin
On Sat, Oct 27, 2012 at 2:09 AM, Adam McMahon wrote: > By putting ACCESS_MODE_DATA=rws in a connection url, does that only affect > the this connection or does that affect all connections? If it only affects If it is the first connection i.e. the one that causes the database to be opened, it will