How to handle stored procedures

[Hari Dhanakoti]

Hi,
I am new to use stored procedures in EJB3. I can get the required output with help of single parameter and i am unable to retrieve more than one parameter sent as a parameter to the stored procedures
Can any one please share the syntax how to handle multiple parameters in stored procedures.

[Rob Spoor]

Moving to our dedicated EJB forum.

[Kenneth Miller]

Hi,
There is no support for stored procedures in JPA. However I found using spring jdbc template for stored procedures a breeze.
http://static.springsource.org/spring/docs/2.0.x/reference/jdbc.html
I think you should be able to intergrate jdbc template quite nicely into EJB3.
HTH.
Regards,
Kenneth