Hi I thought that at first so I tried to setup a trigger on other system tables (like users) and it worked as expected.
Maybe I should explain how my server program should work. My server creates a TcpServer instance and starts it, it connects to it (and eventually creates the database, with custom functions, triggers etc... [it all works correctly]) then waits until it has to stop. During this wait time I want to log client connections and display the list of current active connections. Of course I don't want to constantly pool the sessions table. So, what I need to do is to find a way be notified when a client connect to my TcpServer. Unfortunately, none of the Server, TcpServer or TcpServerThread has functionnalities to do so on such event. Digging in the source code i found that TcpServer insert/delete a row in the sessions table. That's why I tries to be triggered after instert and before delete on sessions. I wished there was some kind of DatabaseEventListener working on server instances, which could provide information about client connection like IP address etc... ! Maybe this could be requested On Wednesday, 24 August 2016 08:47:29 UTC+2, Noel Grandin wrote: > > Those are kind of virtual tables, so it's probable that the trigger logic > is simply not implemented on them. > > you could try using the > > http://www.h2database.com/javadoc/org/h2/api/DatabaseEventListener.html > functionality > > to achieve a similar thing > -- 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 https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
