Hi Anthony-
The primary objective of this exercise is to avoid having to maintain our own set of DDL
and DML for each database, this is what we already do in JBM 1.x and is a big PITA and
maintenance hassle.
The idea was to leverage Hibernate to abstract out the differences between the different
databases DDL, DML.
One way to do that, would be to use Hibernate as ORM.
Currently we just use a few simple hand tuned SQL statements, note that we *do not* have
an existing domain model that maps to the tables.
If we were to use Hibernate as ORM we would have to create a domain model. Also it's
my understanding we would have caching (which we don't want). All which seems a lot of
unnecessary overhead.
I know very little about Hibernate and what it is capable of, but I was under the
impression it provided an API that would let us map "abstract" DDL/DML (i.e.
using some abstract database indepdendent query language), into *real* DDL/DML that could
be used against a specific database.
If this is the case, it would seem this is the simplest way to fulfil our requirements -
this would avoid having to create/maintain an extra domain layer that we really don't
need.
However, maybe I am mistaken / misinformed and such an API does not exist, in which case I
imagine we need to go down the ORM route. If this is the case I would like to know if
HIbernate can be configured to not cache - basically just act as a raw
"translator".
If you could advise me on my assumptions/misundertstandings that would be great. :)
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4117840#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...