How can mapped result from SQL native query to java POJO class (no entity)

Question

I have simple java pojo and it's no entity.

class MyClass {
    // fields, getter, setter and etc...
}

Also I have DAO with some function for execute native SQL query (createNativeQuery)

How can mapped result from SQL native query to MyClass without @Entity ?

artbristol · Accepted Answer · 2011-06-21 13:48:17Z

1

If the bean field names are the same as the DB table's column names, you can use Spring JDBC's org.springframework.jdbc.core.BeanPropertyRowMapper<T>.

You call org.springframework.jdbc.core.simple.SimpleJdbcOperations.queryForObject(String, RowMapper<T>, Object...)) with the BeanPropertyRowMapper object and it calls all the setters for you, using reflection.

answered Jun 21, 2011 at 13:48

artbristol

32.5k5 gold badges73 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Matteo Alessani · Accepted Answer · 2013-09-18 12:02:16Z

1

If its JPA, I'd used: Query query = getEntityManager().createNativeQuery(sql.toString(), MyClass.class);

It works if MyClass is an EntityBean :-(

edited Sep 18, 2013 at 12:02

Matteo Alessani

10.5k4 gold badges42 silver badges57 bronze badges

answered Jul 26, 2011 at 8:57

Carlos Jaime C. De Leon

2,9064 gold badges42 silver badges58 bronze badges

1 Comment

storm_buster Over a year ago

Unless MyClass.class is annoted with @Entity it will not work

Mitch · Accepted Answer · 2011-06-21 13:38:23Z

0

You can simply issue a query and call the getters/setters in your POJO class. Pseudo-code:

get connection
ResultSet rs = execute query
if (rs.next()) {
  setField1(rs.getString("field1"));
  etc....
}

answered Jun 21, 2011 at 13:38

Mitch

1,0391 gold badge10 silver badges25 bronze badges

1 Comment

Terrell Plotzki Over a year ago

If you can't make it an entity I think this is your only route. Without bringing in another framework as proposed in the other answer.

aamadmi · Accepted Answer · 2014-04-20 13:01:38Z

0

You can use EclipseLink query redirector. The following link explains it. The author has also provided code which is pretty generic and works quite well.

http://onpersistence.blogspot.in/2010/07/eclipselink-jpa-native-constructor.html

answered Apr 20, 2014 at 13:01

aamadmi

2,7402 gold badges19 silver badges21 bronze badges

Collectives™ on Stack Overflow

How can mapped result from SQL native query to java POJO class (no entity)

4 Answers 4

Comments

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related