H2 component upgrade

[Julien_GUIRAUD]

Hi Nuxeo team,

Nuxeo 8.x and 9.x embeds h2-1.4.177-NX01 version of H2 database. This version of H2 is a beta one dated of 2014-04-12 and is very buggy.

http://www.h2database.com/html/changelog.html

The last version of H2 1.4.194 is dated of 2017-03-10 and is a stable one.

We use Nuxeo core and H2 as our production database. (all-in-one application)

For our needs, we upgraded to the last version of H2. (to fix database size, locks problems...)

Before, we checked that Nuxeo changes from h2-1.4.177-NX01 patch are integrated in the last version 1.4.194. (XA fixes)

It would be interesting that Nuxeo upgrades this library.

What do you think about ?

Cheers, Julien

[Florent_Guillau]

We don't support h2. It should be used only for demos and small tests. While well-meaning, h2 is much too limited. For production you should use a real database.

If you have a pull request for Nuxeo to upgrade to that more recent version we'll look at it, but otherwise we won't invest much time on it.

[Julien_GUIRAUD]

Hi Florent,

[Florent_Guillau]

Thanks, your pull request would be welcome.

[Florent_Guillau]

[NXP-22334](https