Why to change the h2 database

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.

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

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

Thanks you guys for your responses !

Now I’ve understood.