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 subject. I think

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 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 stored procedures > > On 03/26/2013 07:39 PM, Alon Bar-Lev wro

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

2013-03-27 Thread Laszlo Hornyak
Hi, I agree with the idea. The stored procedures/UDF's are just one more place to go when trying to find out what is really happening. It is not a good solution for database portability. Laszlo - Original Message - > From: "Juan Hernandez" > To: engine-devel@ovirt.org > Sent: Tuesday,

Re: [Engine-devel] FeatureSupported and compatibility versions

2013-03-27 Thread Shireesh Anjal
On 03/20/2013 08:20 PM, Yair Zaslavsky wrote: - Original Message - From: "Shireesh Anjal" To: "Mike Kolesnik" Cc: engine-devel@ovirt.org Sent: Wednesday, March 20, 2013 4:47:08 PM Subject: Re: [Engine-devel] FeatureSupported and compatibility versions On 03/18/2013 01:11 PM, Shireesh

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 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] Move SQL out of stored procedures On 03/26/

Re: [Engine-devel] Any way to setup ovirt engine 3.2.0 or 3.2.1 running enviroment?

2013-03-27 Thread Shireesh Anjal
On 03/26/2013 09:20 AM, Chen, Wei D wrote: Hi, We notice that ovirt-engine's version (rpm package and source code) has updated from 3.2.0 to 3.2.1. As our development process is always based on 3.2.0. Is there any way to re-setup 3.2.0 running environment? Besides, we also cannot setup 3.2.1

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

2013-03-27 Thread Juan Hernandez
On 03/27/2013 01:36 PM, Mike Kolesnik wrote: - Original Message - Hello, according to my experiences Hibernate/JPA is the best solution for application which has to support multiple databases. +1 JPA would be much easier to maintain than the current approach. In most cases the stored

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 subject. I think

Re: [Engine-devel] Any way to setup ovirt engine 3.2.0 or 3.2.1 running enviroment?

2013-03-27 Thread Itamar Heim
On 03/26/2013 05:50 AM, Chen, Wei D wrote: Hi, We notice that ovirt-engine's version (rpm package and source code) has updated from 3.2.0 to 3.2.1. As our development process is always based on 3.2.0. Is there any way to re-setup 3.2.0 running environment? re-setup as in destroy and re-insta

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

2013-03-27 Thread Mike Kolesnik
- Original Message - > On 03/27/2013 01:36 PM, Mike Kolesnik wrote: > > - Original Message - > >> Hello, > >> > >> according to my experiences Hibernate/JPA is the best solution for > >> application > >> which has to support multiple databases. > > > > +1 > > > > JPA would be much e

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

2013-03-27 Thread Alissa Bonas
I suggest that there should be 2 different (though related) issues to consider here in this thread: 1. How the code works with database in runtime (CRUD) - and this is what the Hibernate/JPA/etc. discussion is so far about. 2. Maintenance/upgrade/modification of the database schema - which is al

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

2013-03-27 Thread Mike Kolesnik
- Original Message - > Hello, > > according to my experiences Hibernate/JPA is the best solution for > application > which has to support multiple databases. +1 JPA would be much easier to maintain than the current approach. In most cases the stored procedures we use are for CRUD operat

Re: [Engine-devel] FeatureSupported and compatibility versions

2013-03-27 Thread Mike Kolesnik
- Original Message - > On 03/20/2013 08:20 PM, Yair Zaslavsky wrote: > > > > - Original Message - > >> From: "Shireesh Anjal" > >> To: "Mike Kolesnik" > >> Cc: engine-devel@ovirt.org > >> Sent: Wednesday, March 20, 2013 4:47:08 PM > >> Subject: Re: [Engine-devel] FeatureSupported

Re: [Engine-devel] Any way to setup ovirt engine 3.2.0 or 3.2.1 running enviroment?

2013-03-27 Thread Chen, Wei D
Just want to setup 3.2.0 or 3.2.1 ovirt engine running environment. Thanks. Best Regards, Dave Chen -Original Message- From: Itamar Heim [mailto:ih...@redhat.com] Sent: Wednesday, March 27, 2013 8:39 PM To: Chen, Wei D Cc: engine-devel@ovirt.org Subject: Re: [Engine-devel] Any way to set