Re: [Hibernate-devel] Re: Stored Procedures

[Viktor S. <phr...@im...>]

Gavin_King/Cirrus%CI...@ci... wrote:

>Well, I've often wondered if the interface(s) to
>
>  cirrus.hibernate.impl.ClassPersister
>  cirrus.hibernate.impl.CollectionPersister
>
>used by SessionImpl could be abstracted, making Hibernate much more modular
>internally. I hadn't done this because
>
>(a) nobody had asked for such a feature + I am following an XPish approach
>

i think if hibernate could automatically generate those stored procs we 
could call it XP compliant :-) basically if hibernate can pre-generate 
certain queries (specific to a sql dialect ofcoz) which the developer 
marks as such in the mapping file somehow, all you need to do, is 
execute the sql script in the DB, and hibernate can take advantage of 
SPs. as far as performance goes, it can be a significant improvement on 
most DB servers... and would also be quite a unique feature for hibernate.

best regards,
    viktor