Hibernate Community • View topic - How to convert HQL to SQL

View unanswered posts | View active topics

Board index » Projects » Search, Validator, Shards

All times are UTC - 5 hours [ DST ]

How to convert HQL to SQL

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

chenbibi

Post subject: How to convert HQL to SQL

Posted: Fri Mar 18, 2005 12:37 pm

Newbie

Joined: Thu Mar 03, 2005 2:26 pm
Posts: 4

Hi,

Is there a way in Hibernate 3.0 to convert HQL to SQL? We have a search framework that constructs HQL. However we need to add additional sub-query(which is a native sql) in the sql that is generated from that HQL. Is there a way we can get generated sql from HQL?

Thanks,
Jian

Top

sjivan

Post subject:

Posted: Sat Apr 16, 2005 7:45 pm

Regular

Joined: Mon Sep 20, 2004 8:42 am
Posts: 58
Location: Boston, US

I am interested in this as well.

Is there an API that given HQL/Hibernate Query object returns the underlying SQL string?

Thanks,
Sanjiv

Top

snpesnpe

Post subject:

Posted: Sat Apr 16, 2005 10:38 pm

Expert

Joined: Sat Jun 12, 2004 4:49 pm
Posts: 915

This is example (see hibernate test) :

Code:

Map replacements = null;
        boolean scalar=false;
        String query = "select ..";
    QueryTranslator newQueryTranslator;
    QueryTranslatorFactory ast = new ASTQueryTranslatorFactory();
    String hql = query;
    SessionFactoryImplementor factory = getSessionFactoryImplementor();
    newQueryTranslator = ast.createQueryTranslator( hql, Collections.EMPTY_MAP, factory );
    newQueryTranslator.compile( replacements, scalar );
    String sql = newQueryTranslator.getSQLString();

regards

Top

Page 1 of 1

[ 3 posts ]

Board index » Projects » Search, Validator, Shards

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum