Hi,
I'm new to Hibernate and was hoping someone could explain what I'm doing wrong here.
I have a stored procedure that I want to execute from Hibernate which I've defined in a named query.
Code as follows:
hibernate.cfg.xml .hbm.xml file Stored procedure: AssetSettlementInfo.java: Executing Code: My .cfg.xml files lives in the root of my classpath and my hbm,xml files lives in the same folder as its corresponding class file.
When I try to invoke my getStatus() method I get the following stack trace:
Can someone try to explain what I�m doing wrong here?
Further to this I suspect I�m also calling the stored procedure incorrectly.
I�ve followed these two good examples of working with stored procedures and Hibernate
http://www.hibernate.org/hib_docs/v3/reference/en/html/querysql.html#sp_query https://coderanch.com/t/216142/ORM/java/Executing-stored-procedures-hibernate Am I correctly passing my bind parameter to the stored proc?
I�m doing it like this:
My stored proc does a join across two tables. Do I need to define two
Java objects that map to each database table, or do I only need to define one object that matches the columns in my ref cursor returned by the stored proc?
Many thanks
Oliver