Hi, does anybody have experience with multi tenant setup of objectDB.
For example using multiple schema or multiple database. How to handle connections between app (Jboss Wildfly) and pass query request to appropriate database, how to dynamically add new database or schema.
There are lot of discussions on how to do it with hibernate
Thanks
Many ObjectDB users use ObjectDB with multiple databases. It is very easy when accessing databases directly (by database path). It is more tricky when using ObjectDB within an application server as automatic injection of entity managers in Java EE and JPA is static.
ObjectDB supports a dynamic schema, if your application generates entity classes dynamically (e.g. using CGLIB, javassist, asm, bcel). However, you will lose one of the main benefits of using a Java object database, which is the simplicity of representing persisted data using staticially defined POJO classes. A popular alternative approach it to use static Java classes for the common data and maps (as persistent fields) to store specific tenant data as key/value pairs.
