Why to change the h2 database

Submitted by big73 on Thu, 02/12/2015 - 09:14

Hi all,

I've read in documentation that I must to change h2 database to another database system because h2 is suitable for test and not for production..

Okay but why h2 isn't suitable for a production environnement ? What coul be happen if I deploy my application with h2 ?

Thanks in advance.

Database H2

Log in or register to post comments
5646 reads

2 answers

Submitted by renaud.pichot on Thu, 02/12/2015 - 13:00

This one is the BEST answer!

Hi big73003_1

Event though H2 is a great database system I would still recommend a postgres or oracle system for production stack: I have much more (nice) experience with them. Note that bonita engine is aimed to performs lots of parallel transaction, hence you would need a DBMS that manage well transaction. Not sure how H2 will behave with large DB and lots of transcations.

http://stackoverflow.com/questions/4687156/how-reliable-is-h2-database

http://stackoverflow.com/questions/12064030/are-there-any-reasons-why-h2-database-shouldnt-be-used-in-production

Log in or register to post comments
686 reads

Comments

Submitted by big73 on Thu, 02/12/2015 - 13:45

Thanks you guys for your responses !

Now I've understood.

Permalink

Submitted by Sean McP on Thu, 02/12/2015 - 13:07

Scalability, backups, speed, availability, restore, security, access from other systems, sharing of business data.

H2 is really only for small standalone system, not big databases. And after a few processes have been run you will need a bigger database which is far more capable.

see here

Log in or register to post comments
473 reads