Hi

Can anyone explain what will be the disadvantages invoking stored procedurs using hibernate.
Please explain me the pros and cons of Hibernate for stored procedure and the best way to invoke stored Procedures in Java.

Thanks & REgards

[quote="kalramadevi03"]Hi

Can anyone explain what will be the disadvantages invoking stored procedurs using hibernate.
Please explain me the pros and cons of Hibernate for stored procedure and the best way to invoke stored Procedures in Java.

Thanks & REgards[/quote]

Hello:

I have did one process that i invoke Store Procedure.

According to my experience, I can do my Store Procedure in which I specific any "columns names" from a "select" sentence. But, some time i have to invoke other store procedured did by other, and i found some Store Procedure is no "column name" specific, so... in my Hibernate Mapping SQL-Query context, when i Put:

<return-scalar column="someColumnName" type="string"/>
<return-scalar column="" type="string"/> --> Columns wich has no column name
<return-scalar column="" type="string"/> --> Columns wich has no column name

The Store Procedure Context is like:

select "ssss" as 'someColumnName', 3+5,5+6 from Table x

So... Did you see, that was a great "Cons" using Hibernate to invoke Store Procedure (when it was not did by yourself), because for Hibernate, you must specific properties to return.

Requests for comments.

But I think the same can be acheived using JDBC too right? I mean invoking a procedure using callableStatement and obtaining a resultset.

Can you help me out in explaing how hibernate is better that using JDBC for store Procedures?

[quote="kalramadevi03"]But I think the same can be acheived using JDBC too right? I mean invoking a procedure using callableStatement and obtaining a resultset.

Can you help me out in explaing how hibernate is better that using JDBC for store Procedures?[/quote]

I am sorry... i wanted to say that is "great Const" for Hibernate Calling to Store Procedure.


I my enterprise, the developer team has did a great scalar test for calling Store Procedure with Hibernate, and with JDBC.

The results shows that using Hibernate the performance is 40% less than JDBC.

So, i think, if you use Hibernate, you can do your HQL, because, that is faster than JDBC. But, if you use Store Procedure to doing a Query, i suggest you use JDBC to invoke it.

Requests for comments.

OK

Thanks a lot you had made my task lighter.