« Return to Thread: migrating jdbc queries to jpa native queries

migrating jdbc queries to jpa native queries

by ymajoros :: Rate this Message:

Reply to Author | View in Thread

 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
_______________________________________________
eclipselink-users mailing list
eclipselink-users@...
https://dev.eclipse.org/mailman/listinfo/eclipselink-users

 « Return to Thread: migrating jdbc queries to jpa native queries