Assume you have a stored procedure in your Derby/JavaDB instance with following signature:
This stored procedure returns a resultset that you want to map with your Entity class, say, Airline.
Firstly I should let you know that, till date, Apache Derby [my version is 10.5] does not support Named Parameter in Callable Statements.
Here is the sample:
StoredProcedureCall storedProcedureCall = new StoredProcedureCall();
ReadAllQuery readAllQuery = new ReadAllQuery(Airline.class,
EntityManagerFactory entityManagerFactory = Persistence
List airLines = (List) getSession().executeQuery(readAllQuery);
for (Iterator iterator = airLines.iterator(); iterator
Airline airline = (Airline) iterator.next();
//Now you have your Airline Entity
Points to Note:
1. “UnamedArgumentValue” to set the parameter value at line 3 as Derby/JavaDB does not support Named Parameter in Callable Statements
2. At line 4 We are passing the Entity Type we are expecting to get populated.
This document could also be helpful if you are getting error message like:
1. Internal Exception: java.sql.SQLSyntaxErrorException: Syntax error: Encountered “=” at line 1, column