While writing the application using Apple's WebObjects, in exactly what kind of situation we need to use the Raw SQL in place of using the standard EOF generated queries? I dont find any perfect situation for it.
It's recomended to use raw sql access when you are going to do read-only or "non-interactive batch applications". Also, it is better to use aggregate functions (avg, sum) provided by the database, instead of calculating over an in memory collection of objects.
Hope this helps.
Roses are red, violets are blue. Some poems rhyme and some don't. And some poems are a tiny ad.
professionally read, modify and write PDF files from Java