Re: RawRow cross DB compatibility

2014-03-25 Thread Aaron Rosenzweig
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

Re: RawRow cross DB compatibility

2014-03-25 Thread Ken Anderson
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 develop

Re: RawRow cross DB compatibility

2014-03-24 Thread Chuck Hill
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

Re: RawRow cross DB compatibility

2014-03-24 Thread Aaron Rosenzweig
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 wrote: > Hi all, > I'm migrating a few projects f

RawRow cross DB compatibility

2014-03-24 Thread Oscar González
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