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, <[email protected]> <[email protected]
> 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
