To make a long story short, I have a relational database with a REALLY bad schema that I'm trying to map using an ORM. I have a set of objects already defined that I think represent the data that I'm storing. My only step is to connect the DB to those objects. Hibernate seems to be the go-to solution, but I'm not sure if it will work for me. He's some of the issues I face:
1. I need to dynamically connect to different databases (all of the same type, not all with the same schema). At runtime, I will get connection information and then I must connect to and modify that database.
2. The schema in the databases is dynamic. The tables are all fixed, but in one particular table, columns are added and removed dynamically, at runtime. The names of the columns would also be resolved at runtime.
3. My data is spread across many tables. I've read that it's common to have 1 object = 1 table. But in my case, the data for one object could come from as many as 5 different tables.
So given those constraints, can Hibernate work for me? Or would I be better off just writing my own ORM? Sorry if it seems like I'm asking dumb questions. I'm brand new to ORMs, so a lot of concepts are foreign to me.
|