Please see below scenario

Table A
---------
col1 number,
col2 varchar2,
col3 date,
...
...
...
col10 varchar2


Query
-------

select col1,col2,col5 from A.

Question
======

Can I use addEntity() for above Query not for {select * from A}.

I need some columns only with ORM .

Yes You can use it.
The list() function of the org.hibernate.Query/SQLQuery to retrieve the selective columns as a list.

Hi Sarika,

Thanks for your reply. Sorry this is not correct answer for my question. Please see below once.

When we call query.list() for {select col1,col2,col5 from A} then we get objects[] in a List. These all are scalar values . But I need A.java beans[POJO] instead of object[] array.

Can we can get java beans[POJO] instead of object[]s ?

Yes, you can if you do a native query and map the query to a sqlResultMapping-class (have a look at the JPA spec). This class should be a simple pojo and not an entity.

Carlo

=============================
if this answer helped you don't forget
to give me some credits.