sql in hibernate without mapping

cobse · **Joined:** Thu May 25, 2006 12:21 pm **Posts:** 11

can we write sql query in hibernate without using mapping.

like:
select * from emp;

where emp is my table name.

CWitherow · **Posted:** Fri Jul 21, 2006 4:24 pm

Yes. The result will be an one or more Object[] -- not very friendly to use.

cobse · **Joined:** Thu May 25, 2006 12:21 pm **Posts:** 11

thanks CWitherow ,

Do you know how i can use it.

As i am not sure how to use it.

I tried it but it throws an error saying no mapping found.

CWitherow · **Posted:** Tue Jul 25, 2006 12:28 pm

Code:

List results =
    session
        .createSQLQuery("SELECT col1, col2 FROM table1")
        .addScalar("col1", Hibernate.STRING)
        .addScalar("col2", Hibernate.INTEGER)
        .list();

for (Iterator iter = results.iterator; iter.hasNext(); ) {
    Object[] objs = (Object[])iter.next();
    String col1Value = (String)objs[0];
    Integer col2Value = (Integer)objs[1];
    ...
}

Note that the query is SQL, not HQL. You still need a SessionFactory and a Session.

Curtis ...

cobse · **Joined:** Thu May 25, 2006 12:21 pm **Posts:** 11

thanks Curtis.

It was a great help!