[Engine-devel] Move SQL out of stored procedures

[Libor Spevak]

Hi,
I would recommend always to avoid hard coding SQL into Java code. It is 
very hard to maintain and read.
If there is something, which prevents using JPA/Hibernate, e.g. the 
database relational model doesn't reflect the object-oriented domain
very well or we have to live with many stored procedures concurrently, I 
would choose a framework, which enables to externalize the SQL code 
(into XML).

I worked on a larger project(s) with a lot of PL/SQL code, we moved to 
myBatis (previously iBatis) very soon for Java backend:

https://code.google.com/p/mybatis/

Libor


On 26.3.2013 18:34, Juan Hernandez wrote:
> Hello,
>
> I would like to start a discussion about the subject. I think this is 
> something we need to do if one day we want to be able to use any 
> database other than PostgreSQL.
>
> I did an small example of what it takes and how it looks like to have 
> the SQL code into the DAOs:
>
> http://gerrit.ovirt.org/13347
>
> It isn't rocket science, it isn't an exciting task, it isn't fun, but 
> something I think we should eventually do.
>
> I appreciate any comment about how and when to do this, including 
> those saying that instead of this primitive approach we should use 
> this or that ORM framework.
>
> Regards,
> Juan Hernandez