Cant execute two instance of Axelor Business Suite on a same database with two schemas

English Forum
1

Hello everyone!

Trying to execute two instance of Axelor Business Suite on a same database with two schemas:
For first instance company1, I’ve added in file /opt/tomcat/webapps/company1/WEB-INF/classes/META-INF, screen: http://ipic.su/aC1KG.jpg

Like as above I’ve added company2 with another scheme company2 in a second folder of tomcat webapps company2.

But, when I’m trying to execute tomcat, first instance is executing absolutely normal, but the second instance is not creating sequences.

executing first instance: http://ipic.su/aC1KM.jpg
executing second instance: http://ipic.su/aC1KP.jpg

Be greate thankful if u can help me to solve this problem.

P.S. Thank you the developers of Axelor for ur great job !!!

2

Hi,
Which database are u using ? postgres ?
I think the better way for you is to use the multi-tenancy (see https://docs.axelor.com/adk/5.0/dev-guide/application/multi-tenancy.html) with database based and not shema based.

Or have a look here https://vladmihalcea.com/hibernate-database-schema-multitenancy/

Regards