I think I added some functionality to H2 to do this a year or two ago. Create an implementation in Java of H2's DatabaseEventListener interface. In your implementation, implement the method void setProgress(int state, String name, int x, int max);
It is called each time a query or update statement starts with the state STATE_STATEMENT_START. The 'name' parameter will contain the full SQL statement being executed. > > On Monday, 29 April 2013 07:55:41 UTC-4, Noel Grandin wrote: > > No. > There have been a couple of people looking at doing such things, but > nobody has actually produced any patches yet :-) > > On 2013-04-27 02:02, [email protected] <javascript:> wrote: > > Is there any way to get insert/update logs with a memory only > > database? Preferably having it write out to an in memory buffer I can > > get at. > > > > The alternative is that since I do have a single point of entry for > > all queries, I could just log them myself. > > > > Basically I'm looking to stream logs to another system where I can > > use them to re-create the database. This is a high volume OLTP type > > environment where I need deterministic query times. I'm basically > > using a similar architecture to what the Voltdb guys are doing with > > hsqldb. > > > > Chris > > -- > > You received this message because you are subscribed to the Google > > Groups "H2 Database" group. > > To unsubscribe from this group and stop receiving emails from it, send > > an email to [email protected] <javascript:>. > > To post to this group, send email to > > [email protected]<javascript:>. > > > Visit this group at http://groups.google.com/group/h2-database?hl=en. > > For more options, visit https://groups.google.com/groups/opt_out. > > > > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
