hibernate sqlquery to DB without mapping

Question

I would like to test SQLQuery of Hibernate API, I managed to do so :

    SQLQuery query = session.createSQLQuery("Select * from table;");

    List<Object[]> l = query.list();
    Iterator<Object[]> it = l.iterator();

    while(it.hasNext()) {
        Object[] o = it.next();
        System.out.println(o[0] + " - " + o[1]);
    }

I managed to get the values in the table, from the two columns. But is there a way to get the column numbers of the tables and also their names?

(I know it's pretty stupid because Hibernate's major benefit is ORM and I'm just here trying to query some unmapped information)

You can create your own ResultTransformer which has access to array of column aliases if that works for you. — a1ex07, Nov 26 '14 at 17:27

score 2 · Accepted Answer · answered Nov 26 '14 at 17:29

2

Use following sql query to get columns name :

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = 'YourTableName'

answered Nov 26 '14 at 17:29

Bhavin Panchani

1,332
11
17

score 0 · Answer 2 · answered Nov 26 '14 at 17:17

0

Since hibernate is not managing the entities you cannot ask hibernate of the table metadata, you can execute seperate sql select queries (database specific) to get the table metadata.

answered Nov 26 '14 at 17:17

Sajan Chandran

11,287
3
29
38

hibernate sqlquery to DB without mapping

2 Answers2