Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

EJB3 and Stored Procedures  RSS feed

 
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
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!