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?