Re: SQL DB without any stored procedures?!

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi

I don't know what the Hibernate layer is . I have seen such appliactions
that do not using stored procedures because of business requirements. The
management said that today application si working against SQL
Server --tomorrow against Oracle. Ofcause they make sure that all queries
were written in the way that would work on both products. Generally
speaking , it is really sad that they are not taking advanthge of using
stored procedures as you mentioned it can really speed up performance.

Also there is potentinal problem of SQL Injection if they 'do not know' how
to write parameterized T-SQL.





"Manoj Kumar" <ManojKumar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:10BF5F7B-D801-4CA8-93B3-F45FF08DD401@xxxxxxxxxxxxxxxx
Hi,

Does any one have any experience with the Hibernate layer [which acts as
an
abstraction layer between DB & application layers]? The factor which is
bothering me is the absence of stored procedures. All transactions are
done
via this Hibernate Layer. What I am looking at is a system which does not
use any
stored procedures at all. This will prevent the db server from
using\reusing
a compiled execution plan coupled with all good stuff such as distribution
statistics etc?

The other way to look at is that the sql queries generated & submitted to
the db engine from Hibernate layer will force the query optimizer to do
its
work and create an execution plan and cache it in procedure cache [do not
know if they can use a sp_executesql in Hibernate layer?]

I assume that this will introduce a lot of load on the db system for
read\write operations. The designers are already noticing some issues at
the
locking\blocking areas with this infrastructure. The real locking\blocking
effects are yet to be seen!

Any thoughts\comments are greatly appreciated.

TIA
--
Manoj Kumar


.

Relevant Pages

  • Re: SQL DB without any stored procedures?!
    ... Hibernate is a Java-based transactional middle tier. ... which map as temporary stored procedures. ... any middle or app layer product that treats a SQL server as a structured file system rather than a transactional database processing engine will perform poorer than a properly architected one. ... via this Hibernate Layer. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL DB without any stored procedures?!
    ... The hibernate layer does the mapping of the underlying object and will ... stored procedures as you mentioned it can really speed up performance. ... Also there is potentinal problem of SQL Injection if they 'do not know' how ... work and create an execution plan and cache it in procedure cache [do not ...
    (microsoft.public.sqlserver.clustering)
  • SQL Injections and Hibernate
    ... How secure is a java web application that uses ONLY hibernate to access a database from sql injections? ... far as I know and understand, the hibernate layer will determine the ...
    (Security-Basics)