Hello,
I need some advices, guidelines or opinion of people with more experience.
As I have application that is split into parts on various servers (servcies) and each of those parts might be communicating with the database on it own, I thought of creating a single Database Encapsulation Layer exposed as somekind service.
First thing is that I can't find any existing projects/software providing that kind of service - maybe someone knows it.
Secod thing is abstraction of DB itself in Java - there are so many things around that and getting quite confused what to use ? ton's of ORMs (whichne to use) and should i use it at all? I'd like it to be fast so maybe avoiding ORM and having only DB abstraction is better?
I tryed Hibernate but it's so hard to have anything automaticaly generated in Eclipse or NetBeans using existing DB - I'd like a tool that can reverse engenire database (withouth rocket sience around it) and with ALL DB schemas at once (using pgsql with 10 or more schemas) so I can use it in my Java application. Is there easier way than writing ton of XML to map all db tables and fields ...
I'd be very thankful if anyone can provide me with some information about this "databse abstraction layer as a service".
Thank you
