On Sat, Oct 27, 2012 at 2:09 AM, Adam McMahon <[email protected]> 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 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.
