Hi All,

I use hibernate 3.2 and have following requirement.

We want to write a native SQL inside the java class which should return me the collection of the DataTransferObject.

I got it running using following code.

Query query = getHibernateTemplate().getSessionFactory().getCurrentSession().getNamedQuery("getArticles");
query.setParameter("clientId",clientId);
query.setResultTransformer((new AliasToBeanResultTransformer(ArticleDTO.class)));
query.list();

sql-xml.

<sql-query name="getArticles">
<return-scalar column="articleId" type="long"/>
.... some other properties

<![CDATA[
SELECT id AS articleId,
FROM articles
WHERE clientid= :clientId
]]>
</sql-query>

Here query.list method returns me the collection of the ArticleDTO.

I need to know how can I do it inside java class without putting sql in xml file.

Thanks in advance

You could use annotationsto avoid xml.

Also you could just create a query programmatically: