Re: RawRow cross DB compatibility
Oscar, As an aside, I suggest you use Wonder’s features to implement the port, so you’re not stuck again with raw SQL. I would also bet that raw SQL has nothing to do with performance, but more with either: 1. A very complex query that cannot be translated into qualifiers (rare) 2. A developer that didn’t understand what was possible Fix it now, so you don’t have to fix it later! I learned so much good stuff about ERXKey lately! Ken On Mar 24, 2014, at 11:28 PM, Chuck Hill ch...@global-village.net wrote: Hi Oscar, On 2014-03-24, 5:54 PM, Oscar González wrote: Hi all, I'm migrating a few projects from Oracle to Postgresql, there are a lot straight RawRow for performance. Raw rows or raw SQL? Most raw row stuff can take a qualifier which removes the need for raw (custom) SQL. You are using Wonder, right? Now I'm facing the problem of changing every incompatibility like nvl for coalesce for example. 1. I will like to know the right way of doing a RawRow to use the JdbcPlugin for better cross databases There might be some stuff in JDBCPlugin or in the SQLHelper family to make this easier, but it might be more trouble than it is worth unless you plan on migrating the projects again. 2. For my own problem is there any workaround instead of doing it by the long way. I think you might be stuck with it. Oracle is known for doing things its own way. Chuck Appreciate any help Saludos, Óscar González Pérez TECH un AGRO S.A ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/kenlists%40anderhome.com This email sent to kenli...@anderhome.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: RawRow cross DB compatibility
Hi Ken, Actually there are many queries that are impossible to do with the set of tools that Apple gives us. We *can* write special qualifiers but it takes time and is a bit daunting to get up to speed with. A surprisingly large set of these “unsolvable” problems can be overcome with a custom “Exists” qualifier which is what I’ll present at WOWODC. But you are right on the money, “performance” is often a cop-out for “I don’t understand” how to do it a better way so I roll up my sleeves and write it in straight SQL. I mean, heck, EOF lets us pass hints down to SQL if we want to. AARON ROSENZWEIG / Chat 'n Bike e: aa...@chatnbike.com t: (301) 956-2319 On Mar 25, 2014, at 7:44 AM, Ken Anderson kenli...@anderhome.com wrote: Oscar, As an aside, I suggest you use Wonder’s features to implement the port, so you’re not stuck again with raw SQL. I would also bet that raw SQL has nothing to do with performance, but more with either: 1. A very complex query that cannot be translated into qualifiers (rare) 2. A developer that didn’t understand what was possible Fix it now, so you don’t have to fix it later! I learned so much good stuff about ERXKey lately! Ken On Mar 24, 2014, at 11:28 PM, Chuck Hill ch...@global-village.net wrote: Hi Oscar, On 2014-03-24, 5:54 PM, Oscar González wrote: Hi all, I'm migrating a few projects from Oracle to Postgresql, there are a lot straight RawRow for performance. Raw rows or raw SQL? Most raw row stuff can take a qualifier which removes the need for raw (custom) SQL. You are using Wonder, right? Now I'm facing the problem of changing every incompatibility like nvl for coalesce for example. 1. I will like to know the right way of doing a RawRow to use the JdbcPlugin for better cross databases There might be some stuff in JDBCPlugin or in the SQLHelper family to make this easier, but it might be more trouble than it is worth unless you plan on migrating the projects again. 2. For my own problem is there any workaround instead of doing it by the long way. I think you might be stuck with it. Oracle is known for doing things its own way. Chuck Appreciate any help Saludos, Óscar González Pérez TECH un AGRO S.A ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/kenlists%40anderhome.com This email sent to kenli...@anderhome.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/aaron%40chatnbike.com This email sent to aa...@chatnbike.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
RawRow cross DB compatibility
Hi all, I'm migrating a few projects from Oracle to Postgresql, there are a lot straight RawRow for performance. Now I'm facing the problem of changing every incompatibility like nvl for coalesce for example. 1. I will like to know the right way of doing a RawRow to use the JdbcPlugin for better cross databases 2. For my own problem is there any workaround instead of doing it by the long way. Appreciate any help Saludos, Óscar González Pérez TECH un AGRO S.A ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: RawRow cross DB compatibility
Hi Oscar, I think you already know the answer to this question ;-) Sorry man. There is no easy way... AARON ROSENZWEIG / Chat 'n Bike e: aa...@chatnbike.com t: (301) 956-2319 On Mar 24, 2014, at 8:54 PM, Oscar González racso...@hotmail.com wrote: Hi all, I'm migrating a few projects from Oracle to Postgresql, there are a lot straight RawRow for performance. Now I'm facing the problem of changing every incompatibility like nvl for coalesce for example. 1. I will like to know the right way of doing a RawRow to use the JdbcPlugin for better cross databases 2. For my own problem is there any workaround instead of doing it by the long way. Appreciate any help Saludos, Óscar González Pérez TECH un AGRO S.A ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/aaron%40chatnbike.com This email sent to aa...@chatnbike.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: RawRow cross DB compatibility
Hi Oscar, On 2014-03-24, 5:54 PM, Oscar González wrote: Hi all, I'm migrating a few projects from Oracle to Postgresql, there are a lot straight RawRow for performance. Raw rows or raw SQL? Most raw row stuff can take a qualifier which removes the need for raw (custom) SQL. You are using Wonder, right? Now I'm facing the problem of changing every incompatibility like nvl for coalesce for example. 1. I will like to know the right way of doing a RawRow to use the JdbcPlugin for better cross databases There might be some stuff in JDBCPlugin or in the SQLHelper family to make this easier, but it might be more trouble than it is worth unless you plan on migrating the projects again. 2. For my own problem is there any workaround instead of doing it by the long way. I think you might be stuck with it. Oracle is known for doing things its own way. Chuck Appreciate any help Saludos, Óscar González Pérez TECH un AGRO S.A ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com