Nuxeo Server

H2 Limitations

Updated: December 19, 2017 Page Information Edit on GitHub

H2 is first and foremost designed to be an embedded database. We use it in Nuxeo to provide an easy-to-use downloadable demo platform, but it should never be used in production.

H2 limitations:

  • It has very bad concurrent behavior (writing a row locks the whole table, therefore deadlocks are much more frequent).
  • Its full-text embedding (using Apache Lucene) is not really transactional.
  • It has a poor query optimizer.


a month ago manonlumeau NXDOC-1395: Review 'H2 Limitations'
a month ago Manon Lumeau add tags for doc days
2 months ago manonlumeau Added content-review-lts2017 label
3 months ago manonlumeau NXDOC-1346-FT review screenshot
2 years ago Manon Lumeau 7
3 years ago Solen Guitter 6
4 years ago Florent Guillaume 5
6 years ago Solen Guitter 3 | Added related pages
6 years ago Solen Guitter 4 | Migrated to Confluence 4.0
6 years ago Florent Guillaume 2
6 years ago Florent Guillaume 1
History: Created by Florent Guillaume