Hi,

I am trying to convert criteria to Native SQL.

CriteriaImpl c = (CriteriaImpl) criteria;
SessionImpl s = (SessionImpl)c.getSession();
SessionFactoryImplementor factory = (SessionFactoryImplementor)s.getSessionFactory();
String[] implementors = factory.getImplementors( c.getEntityOrClassName() );
CriteriaLoader loader = new CriteriaLoader((OuterJoinLoadable)factory.getEntityPersister(implementors[0]),
factory, c, implementors[0], s.getEnabledFilters());
Field f = OuterJoinLoader.class.getDeclaredField("sql");
f.setAccessible(true);
return (String) f.get(loader);

Problem with the above code it doesn't take care of the parameters. Is there anyway to replace of the parameters?

If there is any other better way of doing this translation?

Regards,
Joy

I used nativ SQL from a Criteria in my last project to do aritmetic operations with Projections.sqlProjection().
With CriteriaQueryTranslator it's also possible to access nativ SQL. I described this at http://blog.bambo.it/2009/12/generic-subcriterias-for-hibernate.html and http://blog.bambo.it/2009/12/arithmetic-operations-using-generic.html.