Win a copy of Practical SVG this week in the HTML/CSS/JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

EJB3 and Stored Procedures

 
robbie keane
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have written a single table EJB 3 code and it works perfectly fine with the basic CRUD operations. Now i want to enhance this code by calling Stored procedures but I'm not too sure how to go about it. I used Eclipse ganymede as IDE and use 'JPA Tools' plugin to create the Entities. Since my Stored Proc has sqls that are join of 5 or more tables (each having around 10 columns), how do i generate an entity for it (the returned result set). Is native call the only way for making calls (a conventioanl way) and no way EJB 3 supprt it? Can you direct me to some useful url which has some code examples of accomplishing this?


Thanks in advance.

Cheers.
Robbie
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!