*
The moose likes Object Relational Mapping and the fly likes how to call stored procedure with multiple in and out parameters using entity manager Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "how to call stored procedure with multiple in and out parameters using entity manager" Watch "how to call stored procedure with multiple in and out parameters using entity manager" New topic
Author

how to call stored procedure with multiple in and out parameters using entity manager

Hardik Dhanuka
Greenhorn

Joined: Nov 06, 2012
Posts: 2
We are facing an issue while calling the stored procedure from the application.
The database is oracle 10g
This proc has 2 input parameters and 2 output parameters.

Input 1:- DB-List
Input 2:- String

Output 1:-Again a DB-List
Output 2:- Number

When we are trying to use
Query q = session.createSQLQuery("{call proc_name(?,?,?,?)}");
We cannot distinguish between in parameters and out parameters.
So how should we handle it by using this.

Also,
We tried to use callable statement as follows:-

We get the following error:-
javax.ejb.EJBException: java.lang.ClassCastException: $Proxy50 cannot be cast to oracle.jdbc.OracleConnection

Can you please provide some suggestions.

Bill Gorder
Bartender

Joined: Mar 07, 2010
Posts: 1648
    
    7

Not sure what versions of things you are using. Have a look at this.
http://stackoverflow.com/questions/6707115/get-hold-of-a-jdbc-connection-object-from-a-stateless-bean


[How To Ask Questions][Read before you PM me]
Hardik Dhanuka
Greenhorn

Joined: Nov 06, 2012
Posts: 2
Hi Bill,
We tried this using unwrap as well as session.doWork.
But its still giving us the error :-
This happens specifically when we try to get the connection for Array Descriptor.
Bill Gorder
Bartender

Joined: Mar 07, 2010
Posts: 1648
    
    7

You tried this?


From what was said it seems to be the recommended approach. Do you need the OracleConnection or can you make do with java.sql.Connection?
 
Don't get me started about those stupid light bulbs.
 
subject: how to call stored procedure with multiple in and out parameters using entity manager
 
Similar Threads
How to read a pl/sql table which is an OUT parameter from a stored proc from java?
Insertion Values not get stored in sql server using stored procdure in struts2
Using Boolean in Callable Statments
does Hibernate supports Stored Procedures?
JPA + Stored Procedure