return « Stored Procedure « JPA Q&A





1. Hibernate call to Stored Procedure that does not return anything    coderanch.com

Hi All, I am trying to call store procedure in hibernate .but i am not getting result. please give me solution. public List getList() { System.out.println("I am inside getList() class"); List list = null; try { Session session = HibernateUtill.currentSession(); SQLQuery sq= (SQLQuery) session.getNamedQuery("selectAllEmployees_SP"); list= sq.list(); System.out.println("results----- ."+list); HibernateUtill.closeSession(); } catch (Exception e) { e.printStackTrace(); } return list; } this is ...

2. stored procedure returning subset of properties    forum.hibernate.org

I have a stored prodedure for returning just a few properties of cats and a few properties of its kittens given an owner name select {cat.name}, {cat.kittens.*} from Cat cat, Owner owner where cat.owner = owner.name cat has properties: name, breed, collection of kittens, owner, kitten is a cat owner has properties: name and address I am not sure how to ...

3. Hibernate call to Stored Procedure that does not return anyt    forum.hibernate.org

Hi all, I need to call an Oracle stored procedure. The proc does not return anything, It takes 4 input and updates some dates on tables. I find examples of this but all have something like: { ? = call PRC_UNFIT_FILER(?,?,?,?) } What syntax do I use if the proc does not return a value? I am using Hibernate3. My map ...