Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to handle stored procedures

 
Hari Dhanakoti
Ranch Hand
Posts: 74
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Pie
Posts: 20531
54
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to our dedicated EJB forum.
 
Kenneth Miller
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic