107thAirhacksQ&A.md

107thAirhacksQ&A.md

Ask questions and see you at February 6, 8 pm CET: youtube.com/c/bienadam

Also checkout recent episode:

Please keep the questions as short and as concise as only possible. Feel free to ask several, shorter questions. I will also cover some questions in my "shorts" https://youtube.com/playlist?list=PLxU9yM-_yPs8xqd8Yu4ecpVwiUD_1Xv4N between the shows.

Upcoming airhacks.tv events are also going to be announced at meetup.com/airhacks

New: the airhacks.tv discord server: https://discord.com/invite/airhacks

How to JPA Multitenancy with JavaEE, Inject, CDI, Payara 5 (not plain hibernate, without spring data) ? Must be transactional out of the box without weird magic.

;)

• single database server (mysql 8)
• multiple schemas for tenants (n-schemas)
• one schema per tenant (n-tables)
• one schema for storing users, app settings etc (n-tables)..

Maybe some examples and guides or different approache. Thanks.

Interested to see what Adam has to say here, as well. As far as I'm aware - multitenancy is not included in the JPA spec but is supported by provider-specific extensions. You mention Payara - that indicates eclipselink - have you taken a look at the eclipselink solution guide?

So what do you think with your experience is a good approach?
Switching tech and increasing horizontal knowledge or sticking to one and going deep with the vertical approach (ajv) question from: https://discord.gg/airhacks