Re: [Engine-devel] Move SQL out of stored procedures

2013-04-02 Thread Eli Mesika
- Original Message - > From: "Yair Zaslavsky" > To: "Liran Zelkha" > Cc: engine-devel@ovirt.org > Sent: Tuesday, April 2, 2013 10:15:06 AM > Subject: Re: [Engine-devel] Move SQL out of stored procedures > > > Hi all, > Sorry for my lat

Re: [Engine-devel] Move SQL out of stored procedures

2013-04-02 Thread Liran Zelkha
" >> To: "Juan Hernandez" >> Cc: engine-devel@ovirt.org >> Sent: Wednesday, March 27, 2013 10:09:22 AM >> Subject: Re: [Engine-devel] Move SQL out of stored procedures >> >> Hi, >> I would recommend always to avoid hard coding SQL into J

Re: [Engine-devel] Move SQL out of stored procedures

2013-04-02 Thread Yair Zaslavsky
- Original Message - > From: "Libor Spevak" > To: "Juan Hernandez" > Cc: engine-devel@ovirt.org > Sent: Wednesday, March 27, 2013 10:09:22 AM > Subject: Re: [Engine-devel] Move SQL out of stored procedures > > Hi, > I would recommend always

Re: [Engine-devel] Move SQL out of stored procedures

2013-04-02 Thread Laszlo Hornyak
Hi Liran, - Original Message - > From: "Liran Zelkha" > To: "Laszlo Hornyak" > Cc: "Liran Zelkha" , engine-devel@ovirt.org > Sent: Tuesday, April 2, 2013 8:37:28 AM > Subject: Re: [Engine-devel] Move SQL out of stored procedures > &

Re: [Engine-devel] Move SQL out of stored procedures

2013-04-02 Thread Yair Zaslavsky
2, 2013 9:37:28 AM > Subject: Re: [Engine-devel] Move SQL out of stored procedures > > Hi Laszlo, > > I'm currently in the process of adding a caching layer on top of > JdbcTemplate, which would greatly reduce the number of database activities > we have, so that would solve t

Re: [Engine-devel] Move SQL out of stored procedures

2013-04-01 Thread Laszlo Hornyak
- Original Message - > From: "Eli Mesika" > To: engine-devel@ovirt.org > Sent: Monday, April 1, 2013 11:35:03 PM > Subject: Re: [Engine-devel] Move SQL out of stored procedures > > > > - Original Message - > > From: "Laszlo Ho

Re: [Engine-devel] Move SQL out of stored procedures

2013-04-01 Thread Liran Zelkha
e more like > that. > > Therefore having a JPA could improve the performance in engine. > > Laszlo > > - Original Message - >> From: "Liran Zelkha" >> To: "Eli Mesika" >> Cc: engine-devel@ovirt.org >> Sent: Tuesday, Apri

Re: [Engine-devel] Move SQL out of stored procedures

2013-04-01 Thread Laszlo Hornyak
improve the performance in engine. Laszlo - Original Message - > From: "Liran Zelkha" > To: "Eli Mesika" > Cc: engine-devel@ovirt.org > Sent: Tuesday, April 2, 2013 7:24:08 AM > Subject: Re: [Engine-devel] Move SQL out of stored procedures > > I

Re: [Engine-devel] Move SQL out of stored procedures

2013-04-01 Thread Liran Zelkha
Tuesday, April 2, 2013 12:35:03 AM Subject: Re: [Engine-devel] Move SQL out of stored procedures - Original Message - > From: "Laszlo Hornyak" > To: "Libor Spevak" > Cc: "Juan Hernandez" , engine-devel@ovirt.org > Sent: Thursday, March 28, 20

Re: [Engine-devel] Move SQL out of stored procedures

2013-04-01 Thread Eli Mesika
- Original Message - > From: "Laszlo Hornyak" > To: "Libor Spevak" > Cc: "Juan Hernandez" , engine-devel@ovirt.org > Sent: Thursday, March 28, 2013 5:31:34 PM > Subject: Re: [Engine-devel] Move SQL out of stored procedures > > >

Re: [Engine-devel] Move SQL out of stored procedures

2013-03-28 Thread Laszlo Hornyak
- Original Message - > From: "Libor Spevak" > To: "Itamar Heim" > Cc: "Juan Hernandez" , engine-devel@ovirt.org > Sent: Thursday, March 28, 2013 4:04:20 PM > Subject: Re: [Engine-devel] Move SQL out of stored procedures > > Hi, >

Re: [Engine-devel] Move SQL out of stored procedures

2013-03-28 Thread Libor Spevak
On 27.3.2013 13:53, Itamar Heim wrote: On 03/26/2013 08:39 PM, Alon Bar-Lev wrote: - Original Message - From: "Juan Hernandez" To: engine-devel@ovirt.org Sent: Tuesday, March 26, 2013 7:34:04 PM Subject: [Engine-devel] Move SQL out of stored procedures Hello, I would

Re: [Engine-devel] Move SQL out of stored procedures

2013-03-27 Thread Mike Kolesnik
> Martin Perina > > > - Original Message - > > From: "Alon Bar-Lev" > > To: "Juan Hernandez" > > Cc: engine-devel@ovirt.org > > Sent: Tuesday, March 26, 2013 7:39:16 PM > > Subject: Re: [Engine-devel] Move SQL out of stored p

Re: [Engine-devel] Move SQL out of stored procedures

2013-03-27 Thread Alissa Bonas
t;Alon Bar-Lev" > Cc: "Juan Hernandez" , engine-devel@ovirt.org > Sent: Wednesday, March 27, 2013 2:53:45 PM > Subject: Re: [Engine-devel] Move SQL out of stored procedures > > On 03/26/2013 08:39 PM, Alon Bar-Lev wrote: > > > > > > - Original Messa

Re: [Engine-devel] Move SQL out of stored procedures

2013-03-27 Thread Mike Kolesnik
on fetch, and re-attach on save/update. Anyway, it still adds the benefit of ORM which would still simplify much of the code, and provide the desired portability. Also I think if we move to the direction of ORM, it would be easier to change the rest of the application code to behave differently, should

Re: [Engine-devel] Move SQL out of stored procedures

2013-03-27 Thread Itamar Heim
On 03/26/2013 08:39 PM, Alon Bar-Lev wrote: - Original Message - From: "Juan Hernandez" To: engine-devel@ovirt.org Sent: Tuesday, March 26, 2013 7:34:04 PM Subject: [Engine-devel] Move SQL out of stored procedures Hello, I would like to start a discussion about the subjec

Re: [Engine-devel] Move SQL out of stored procedures

2013-03-27 Thread Juan Hernandez
6, 2013 7:39:16 PM Subject: Re: [Engine-devel] Move SQL out of stored procedures - Original Message - From: "Juan Hernandez" To: engine-devel@ovirt.org Sent: Tuesday, March 26, 2013 7:34:04 PM Subject: [Engine-devel] Move SQL out of stored procedures Hello, I would like to

Re: [Engine-devel] Move SQL out of stored procedures

2013-03-27 Thread Juan Hernandez
On 03/27/2013 09:19 AM, Alon Bar-Lev wrote: - Original Message - From: "Juan Hernandez" To: "Alon Bar-Lev" Cc: engine-devel@ovirt.org, "Eli Mesika" , "Yair Zaslavsky" Sent: Wednesday, March 27, 2013 9:52:35 AM Subject: Re: [Engine-devel] Mov

Re: [Engine-devel] Move SQL out of stored procedures

2013-03-27 Thread Tal Nisan
Removing the stored procedures is indeed a blessing, but the implementation you offered seems a bit too oldschool (i.e. coding sql into the code), in my opinion if we go towards a joint effort to refactor the DAO layer we should go the extra mile and move to Hibernate (Take II :) ) On 03/26/

Re: [Engine-devel] Move SQL out of stored procedures

2013-03-27 Thread Laszlo Hornyak
t.org > Sent: Tuesday, March 26, 2013 6:34:04 PM > Subject: [Engine-devel] Move SQL out of stored procedures > > 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 > databa

Re: [Engine-devel] Move SQL out of stored procedures

2013-03-27 Thread Alon Bar-Lev
- Original Message - > From: "Juan Hernandez" > To: "Alon Bar-Lev" > Cc: engine-devel@ovirt.org, "Eli Mesika" , "Yair > Zaslavsky" > Sent: Wednesday, March 27, 2013 9:52:35 AM > Subject: Re: [Engine-devel] Move SQL out of s

Re: [Engine-devel] Move SQL out of stored procedures

2013-03-27 Thread 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 proce

Re: [Engine-devel] Move SQL out of stored procedures

2013-03-27 Thread Juan Hernandez
On 03/26/2013 07:39 PM, Alon Bar-Lev wrote: - Original Message - From: "Juan Hernandez" To: engine-devel@ovirt.org Sent: Tuesday, March 26, 2013 7:34:04 PM Subject: [Engine-devel] Move SQL out of stored procedures Hello, I would like to start a discussion about the subjec

Re: [Engine-devel] Move SQL out of stored procedures

2013-03-26 Thread Martin Perina
ar-Lev" > To: "Juan Hernandez" > Cc: engine-devel@ovirt.org > Sent: Tuesday, March 26, 2013 7:39:16 PM > Subject: Re: [Engine-devel] Move SQL out of stored procedures > > > > - Original Message - > > From: "Juan Hernandez" > &g

Re: [Engine-devel] Move SQL out of stored procedures

2013-03-26 Thread Alon Bar-Lev
- Original Message - > From: "Juan Hernandez" > To: engine-devel@ovirt.org > Sent: Tuesday, March 26, 2013 7:34:04 PM > Subject: [Engine-devel] Move SQL out of stored procedures > > Hello, > > I would like to start a discussion about the subject. I th

[Engine-devel] Move SQL out of stored procedures

2013-03-26 Thread Juan Hernandez
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.ovir