File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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: 1676
    
    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: 1676
    
    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?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to call stored procedure with multiple in and out parameters using entity manager