how do I get a pojo object with few columns data using hibernate

Question

0.00/5 (No votes)

See more:

suppose i have a pojo like

@Entity
@Table(name = "college", catalog = "practice")

public class College implements java.io.Serializable
{

private int id;
private String name;
private String caddress;
private String ccode;
}
and getters and setters

Now i want an object of this pojo from this query

XML

SQLQuery query = session.createSQLQuery("select id,name from  College");
       query.addEntity(College.class);

       List<College> employees = query.list();

But this query will give the result in list(because i have not provided all columns)<Object[]> but i want a pojo object having the value of provided columns

How to do that........
please reply
thanks in Advance

Posted 4-Feb-15 0:04am

Member 11426328

Updated 4-Feb-15 0:22am

Deepu S Nair

v3

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Pravin S K · Answer 1 · 2015-02-04T20:58:00

we can take an alternate approach for that first we will fetch the result in to map and then covert to pojo by using jackson api for example

Java

SQLQuery query = session.createSQLQuery("select id,name from  College");
       query.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
 List<map><string,>> list = query.list();

for (Map<string,> map : list)
        {

          
            ObjectMapper m = new ObjectMapper();
           
            College anotherBean = m.convertValue(map, College.class);
            colleges.add(anotherBean);

            System.out.println(anotherBean);

          
        }</map>

how do I get a pojo object with few columns data using hibernate

1 solution

Solution 2

Add your solution here

Preview 0

how do I get a pojo object with few columns data using hibernate

1 solution

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us