• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag
 

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: RawRow cross DB compatibility
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: RawRow cross DB compatibility

  • Subject: Re: RawRow cross DB compatibility
  • From: Ken Anderson <email@hidden>
  • Date: Tue, 25 Mar 2014 07:44:31 -0400
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@hidden> 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@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
  • Follow-Ups:
    • Re: RawRow cross DB compatibility
      • From: Aaron Rosenzweig <email@hidden>
References: 
 >RawRow cross DB compatibility (From: Oscar González <email@hidden>)
 >Re: RawRow cross DB compatibility (From: Chuck Hill <email@hidden>)

  • Prev by Date: Re: ERXObjectStoreCoordinator dispose not releasing database connection?
  • Next by Date: Re: Error after adding entity and relationship to model
  • Previous by thread: Re: RawRow cross DB compatibility
  • Next by thread: Re: RawRow cross DB compatibility
  • Index(es):
    • Date
    • Thread