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 <[email protected]> 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 ([email protected]) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/kenlists%40anderhome.com > > This email sent to [email protected]
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
