wood burning stoves 2.0*
The moose likes EJB and other Java EE Technologies and the fly likes How to handle stored procedures Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "How to handle stored procedures" Watch "How to handle stored procedures" New topic
Author

How to handle stored procedures

Hari Dhanakoti
Ranch Hand

Joined: Jan 07, 2008
Posts: 74
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.

Regards,
Hari
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19654
    
  18

Moving to our dedicated EJB forum.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
Kenneth Miller
Greenhorn

Joined: Jun 30, 2009
Posts: 7
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to handle stored procedures
 
Similar Threads
How resultset is returned by stored procedure?
Java & Oracle Stored Procedures
avoid sql injection
Executing procedure in Hibernet with more than one out parameters
how we can call stored procedure in hibernate?