• 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: Sorting Nulls with Oracle
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Sorting Nulls with Oracle


  • Subject: Re: Sorting Nulls with Oracle
  • From: email@hidden
  • Date: Mon, 25 Jan 2010 17:22:30 -0500


Hi All,

The main question Dave was asking was how to give back to the community his useful fix for a very important piece of this problem.

I believe the answer is to just use NSProperties. That way the option can be given in the Properties file, from the command line, or even from your home directory. Here's the API:

http://developer.apple.com/legacy/mac/library/documentation/MacOSXServer/Reference/WO54_Reference/com/webobjects/foundation/NSProperties.html

All the other notes from Dave and Chuck are valuable and something you'll need to address in your own applications. Especially the "Ask Tom" URL that Dave gave. I'll cut and paste it again for completeness:

http://www.oracle.com/technology/oramag/oracle/07-jan/o17asktom.html

Also this other "Ask Tom" article:

http://www.oracle.com/technology/oramag/oracle/06-sep/o56asktom.html

One option you have is to jump start from what Mike has given you in the "OracleSQLHelper" then roll your own and replace it at runtime. This is also true for whatever database you use. Not only can you attempt to tweak it to get deterministic results in the general case using the oracle reserved keyword "rowid" you can go one step further. (BTW - "rowid" is like guid for the row). You can impliment an interface for specific Entities where you want to control what column to use for deterministic behavior. You can define something in the "userinfo" dictionary and make your generation templates latch onto that. In this way, when it comes time to do the clever batching, you can use either "rowid" or the special column of your entity if one is defined in Entity Modeler.

Cheers,
-- Aaron
 _______________________________________________
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

References: 
 >Re: Sorting Nulls with Oracle (From: Chuck Hill <email@hidden>)

  • Prev by Date: Re: ertaggable not migrating
  • Next by Date: Re: ertaggable not migrating
  • Previous by thread: Re: Sorting Nulls with Oracle
  • Next by thread: Port 443 appending
  • Index(es):
    • Date
    • Thread