Re: Need suggestion on Hibernate+Oracle

On 03/13/2005 04:50:46 AM, Christian Antognini wrote:

> The goal of a transparent persistence framework like Hibernate is that =
=3D
> the developer should design the object model independently from the =3D
> database design.

And that is a recipe for disaster. I haven't seen a single attempt of writi= ng
a "database independent application" which wasn't a pure and unadulterated = disaster.
OO structure which is not aware of gory implementation details usually beco= mes
aware of them when the clients start suffering 15-minute response times in = an=20
online application.=20
Those shrewd solutions are usually built using JDBC and dynamic SQL, with u= tter disdain
for bind variables. Special beauties are 16k long SQL statements which cont= ain clever
tricks like "rownum<2" condition to ensure uniqueness. Of course, putting u= nique constraint
in place would break the database independence, because IdiotBase+ doesn't = support unique=20
constraints, unless the database is mauve. There is only one thing I can say about so called "database neutral applica= tions":=20
I resemble that!

--=20
Mladen Gogala
Oracle DBA

--
http://www.freelists.org/webpage/oracle-l