Re: Sorting Nulls with Oracle
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