DAO a "stored procedures only" pristup

[jeeff]

Ahoj,

mna k takemuto rieseniu nutil jeden klient (velka banka), pretoze  
doteraz tiez taky pristup pouzivali. Na odpoved preco hovorili, ze  
kvoli moznosti nastavovania pristupov, pouzivali MS SQL a tam s tym  
asi mali problem -  k SP sa daju nastavovat presnejsie prava. Druhy  
dovod co uvadzali bolo to, ze k SP ma databaza pripravene exekucne  
plany a ze je to teda rychlejsie ako bezne SQL dotazy.

Bolo pre nich dost nepochopitelne, ked sme im povedali, ze v nasej  
aplikacii nepouzivame ziadne SP (z dovodu prenositelnosti medzi  
databazami). Nakoniec sa ale uspokojili s tym, ze pre pripojenie na MS  
SQL pouzivame jTDS, ktory automaticky volania prepared statements  
konvertuje na stored procedures, ktore si dynamicky vytvara.


On 5.6.2009, at 10:39, <Lukas.Kubasek na barclayscapital.com> <Lukas.Kubasek na barclayscapital.com 
 > wrote:

> Zdravim,
>
> Rad bych se zeptal na nezavisly nazor. Je ve vasi firme bezne, ze  
> jsou v
> Java Enterprise aplikaci (Spring, EJB, cokoliv) vsechny CRUD operace
> modelovany pres ulozene procedury v databazi? Nemluvim o komplexnich
> operacich, ktere je nutne do storky davat, ale o kazde jednotlive
> jednoduche operaci select, update, insert, delete, pricemz z DAO  
> vrstvy
> pak jen volate ulozenou proceduru?
>
> Mate nejake vyrazne plusy ci minusy proc tento pristup
> doporucit/zavrhnout?
>
> Diky
>
> Lukas Kubasek
> Barclays Capital, Global IT Services Prague
> _______________________________________________
>
> This e-mail may contain information that is confidential, privileged  
> or otherwise protected from disclosure. If you are not an intended  
> recipient of this e-mail, do not duplicate or redistribute it by any  
> means. Please delete it and any attachments and notify the sender  
> that you have received it in error. Unless specifically indicated,  
> this e-mail is not an offer to buy or sell or a solicitation to buy  
> or sell any securities, investment products or other financial  
> product or service, an official confirmation of any transaction, or  
> an official statement of Barclays. Any views or opinions presented  
> are solely those of the author and do not necessarily represent  
> those of Barclays. This e-mail is subject to terms available at the  
> following link: www.barcap.com/emaildisclaimer. By messaging with  
> Barclays you consent to the foregoing.  Barclays Capital is the  
> investment banking division of Barclays Bank PLC, a company  
> registered in England (number 1026167) with its registered office at  
> 1 Churchill Place, London, E14 5HP.  This email may relate to or be  
> sent from other members of the Barclays Group.
> _______________________________________________

--
jeeff