HQL to SQl Convertor

Discussion in 'Programming' started by harishsyndrome, Nov 29, 2009.

0
  1. #1
    harishsyndrome, Nov 29, 2009 IP
  2. inpun

    inpun Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    You can just add the following option to your config file:
    <property name="hibernate. show.sql" value="true"></property>
    And SQL will be displayed in log file.
     
    inpun, Nov 30, 2009 IP
  3. harishsyndrome

    harishsyndrome Peon

    Messages:
    128
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Yes there is an Option

    But for that u need to create a Session and other things..

    You need a Hibernate.conf.xml and the mapping files of the Classes and objects u using in that

    Here u dont need any thing connection

    Just input a query , the equivalent SQL query is returned
     
    harishsyndrome, Dec 1, 2009 IP
  4. devunion

    devunion Greenhorn

    Messages:
    13
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    13
    #4
    Anyway, you can get all necessary code from Hibernate shources. You don't need to write such converter by yourself. All work is already done by Hibernate developers.
     
    devunion, Dec 7, 2009 IP