Two MySQL Database on Jhipster

Question

I am using jHipster and it is great as most of the boiler-plate Java code is automatically generated.

In my application, I need two MySQL databases. How do I configure them? Should I have two different database config files for the two different schemas?

Also, jHipster uses Liquibase, so how do I change my DatabaseConfiguration class?

Are you sure you need two schemas? That is, you can't create tables with foreign keys? — riddle_me_this, Jul 06 '15 at 14:42
Not only two schemas they are in two different DBs one MSSQL and other MySQL — Allahbaksh Asadullah, Jul 06 '15 at 15:37

score 2 · Answer 1 · edited May 23 '17 at 12:25

2

You will need to configure 2 datasources, 2 Hibernate sessions, 2 cache instances... This is going to be quite complex: first start with the datasources (obviously!).
Please note that transactions won't work between your two databases, so this can lead to some interesting bugs :-)

Another solution, which I would prefer, is to use something similar to Oracle DB Link. That would solve all those problems and be much easier to work on.

edited May 23 '17 at 12:25

Community

1
1

answered Jul 06 '15 at 11:42

Julien Dubois

3,678
1
20
22

Your Point No 1 is something which I can look at. But how do we configure it with liquibase. Any sample application would help – Allahbaksh Asadullah Jul 07 '15 at 05:10

score 0 · Answer 2 · answered Jul 06 '15 at 13:34

I'm not sure, if you talk about spring, but since you added the spring tag, I assume you do.

As far as I see, the basic question is, wether you need an XA-transaction or not (update both databases within the same transaction). If you do, then you simply define your datasources with an appropriate MySql XA-Datasource and bind them to the same transactionmanger (which of course has to support XA-transactions).

If you do this configuration in one or more spring-config-xml files (or java classes, if you prefer annotation based spring configuration) is up to you.

Two MySQL Database on Jhipster

2 Answers2

Linked