We use H2 in production for a non-critical small app. If it goes down we just launch it again and it fetches data from other internal webapps.

I'd not recommend it for heavy-use in Production.