Re: [eclipselink-users] migrating jdbc queries to jpa native queries

[James Sutherland <jamesssss@xxxxxxxxx>]

EclipseLink provides a Query hint that allows the results to be returned as a
List of Maps (DatabaseRecords) instead of a List of Object[].

"eclipselink.result-type"="Map"

See, org.eclipse.persistence.ResultType , QueryHints


ymajoros wrote:
> 
>  Hi,
> 
>  Is there a simple way to migrate code like this to jpa/eclipselink?
> 
> // get connection, statement
>  ResultSet rs = statement.executeQuery(maCommande);
>   while (rs.next()) {
>                     String code = rs.getString("code_etude");
>    // ...
>   }
> 
>  In order to use jpa-provided connection pools, to have all statements 
> closed in all cases without try-finally blocks, ...
> 
>  Is there a simple solution? Native queries return an array with unnamed 
> columns, we really want to use methods like 
> rs.getString("my_column_name"). We can't use SqlResultSetMapping, as the 
> queries are too complex to be mapped.
> 
>  Yannick
> 
> 


-----
http://wiki.eclipse.org/User:James.sutherland.oracle.com James Sutherland 
http://www.eclipse.org/eclipselink/
 EclipseLink ,  http://www.oracle.com/technology/products/ias/toplink/
TopLink 
Wiki:  http://wiki.eclipse.org/EclipseLink EclipseLink , 
http://wiki.oracle.com/page/TopLink TopLink 
Forums:  http://forums.oracle.com/forums/forum.jspa?forumID=48 TopLink , 
http://www.nabble.com/EclipseLink-f26430.html EclipseLink 
Book:  http://en.wikibooks.org/wiki/Java_Persistence Java Persistence 
-- 
View this message in context: http://www.nabble.com/migrating-jdbc-queries-to-jpa-native-queries-tp24371649p24374654.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.