Re: "We don't do triggers"

Comments in-line.

Peter Connolly wrote:

> In addition to portability, another reason for specifying no stored
> procedures could be to ensure that there is no business logic in the
> database procs.

Because you value data corruption?

   In an n-tiered system, all business logic should be
> on the application server, not in the GUI or the database.

According to who. I want names, dates, and places. This is pure unadulterated garbage.

   If you
> can't write logic then your stored procs would be reduced to simple
> insert, update, delete, and select statements. Most J2EE application
> servers now support container managed persistence, which means it will
> handle all of the sql select and dml statements for you.

And which means that the first person that goes into your database by any means other than your specified front-end can do anything they wish.

  That leaves
> very few cases when an application developer on an n-tiered system
> will need to write a stored proc.

Which they don't want to do because doing so would expose their incredible lack of knowledge to public view. They haven't a clue about concepts, they haven't a clue about architecture, they wouldn't know an atomic transaction data model from an atomic bomb if it was sitting on their dining room table. If ignorance is bliss ... then this has got to be a first-class ticket to the garden of eden.

   I think there is still a place for
> stored procs, but they should be used sparingly in an application like
> this.

Because using them is more scalable, more stable, more secure, and perform faster and we sure as H... don't want any of those things in a database application.

Thank you for providing me with classroom material. It is just the kind of thinking that makes the perfect bad example. It is thinking like this that is resulting in so many failed IT projects and so many jobs being off-shored. All fluff ... no substance.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)