Noel- Would you kindly elaborate on your last statement there about H2 is not intended to be used over a complex client network?
My impression is that H2 is pretty close to being able to have robust client network connections. Is there a bigger issue or something more fundamental that would prevent this from being successful? Thanks, Matt On Monday, September 9, 2019 at 10:24:02 AM UTC-5, Noel Grandin wrote: > You > > On Mon, 9 Sep 2019 at 13:47, 'Christian Buchegger' via H2 Database < > h2-da...@googlegroups.com <javascript:>> wrote: > >> I would like to get feedback on the below two proposals: >> >> 1. Add a function abort_session: >> Abort current command and call session.close() so that the locks and >> resources will be released. This will avoid the need of server restart. >> >> > That sounds reasonable. > >> >> 1. >> 2. Add a parameter SQL_SESSION_IDLE_TIMEOUT >> With this parameter, a session will be closed by the server, when >> there was no client activity within the defined timeout period. >> >> >> > Note that, with something like this, you are invariably going to > occasionally manage to kill a session under a live client, and the client > may not notice until it issues a command, whereupon it will need to > reconnect and re-issue that command. > > You can probably mitigate these issues already by > (*) chatting to your sysadmin and making the timeout before recycling IP > addresses longer, so your users normally get the same IP address again. > (*) changing your app to shut down connections aggressively itself, and > re-open them as needed - this can normally be configured inside a > connection pool. For bonus points, the connection pool can be configured to > do a "test if connection OK before handing it out", which will prevent the > problem that your app sees a broken connection. > > But really the root of the problem is that you're using H2 as an > application server, which it is not really meant to be - it is not intended > to be using directly facing a complex client network. > > > > -- 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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/f906afa4-2c67-47d8-849e-e863f2561523%40googlegroups.com.
