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 after an important update/insert. And that is it? I understand that there are still no absolute guarantees with this, but this seems like it should work. My environment has pretty good power backup. On Saturday, October 27, 2012 8:25:28 AM UTC-4, Noel Grandin wrote: > > On Sat, Oct 27, 2012 at 2:09 AM, Adam McMahon > <[email protected]<javascript:>> > 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 affect all connections. > Otherwise it will have no affect. > > > this connection, then I think could use 'rws' followed by a CHECKPOINT > SYNC > > to get specific transactions to flush. Would this work on specific > > transactions while running most everything else in default mode? > > > You can just CHECKPOINT SYNC the stuff that is really important to you. > Note that > (1) this will affect all recently closed transactions because that > layer of the DB does not distinguish between data belonging to > different connections > (2) there is no guarantee that the data has actually hit the disk, > because most modern disks have some kind write-behind buffer. So there > is still a small window of data that you might lose. > > In general, a properly configured UPS is a much better solution. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/-0jTzH95YYEJ. 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.
