Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Java to die in 2003
On 28 Dec 2002, stuartc_at_mac.com wrote:
> Nuno Souto <nsouto_at_optushome.com.au.nospam> wrote in message
> news:<3e0d4769$0$7817$afc38c87_at_news.optusnet.com.au>...
>
>> Precisely. And let me stress: this "duality" comes from the J2EE >> crowd every single time, IME. Not once are they willing to accept >> that there is a little bit more about databases than just what JDBC >> has.
>> If it's not in the example cookbook provided by WSAD and IBM in a >> deranged red book somewhere, they don't even want to hear about it...
>> > Stored procedures >> > aren't evil. >> >> Tell that to J2EE "God" Scott Ambler & Co. And the Jakarta mob...
The issue with stored procedures from the J2EE point of view is that your application isn't portable. To port the application, the procedures have to be rewritten for the next database platform. So, the whole J2EE mantra becomes one of minimizing the chores of the developer of the application. The mantra isn't one of bringing the best application to the customer, it is one of building an app that can be ported easily. But, then, the ported application will invariably perform poorly and some of the sql will need to be rewritten for the next DB platform. So, complete portable is truly a pipe-dream.
My issue with not using stored procedures is the other side of this coin. JDBC doesn't provide you with platform independence or guarantee that you will execute high-performing SQL. It only provides a single API for dealing with interacting with databases. If you want a successful application, it needs to perform well. Letting application developers stick dynamic sql in java code will invariably end up with an application that doesn't perform well. Its not that J2EE developers aren't smart enough to be good db developers, its that most J2EE developers aren't good db developers. So, a way to guarantee that SQL code isn't in java code is to have everything go through a proc. Then, the database actually looks much more java like anyways. There is nothing java/object like about dynamic SQL. It is much more java/object like to ask something to execute a method.
[...]
>> Narh! That would be too easy. >> Eschew simplicity is the middle name of J2EE... >> :(
Arghh!!! The next time someone creates a bean for every single row on a report screen I think I will scream.
-- Galen deForest Boyer Sweet dreams and flying machines in pieces on the ground.Received on Sat Dec 28 2002 - 21:17:07 CST