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
– a1ex07, Commented Nov 26, 2014 at 17:27

Bhavin Panchani · Accepted Answer · 2014-11-26 17:29:50Z

2

Use following sql query to get columns name :

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

answered Nov 26, 2014 at 17:29

Bhavin Panchani

1,36211 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sajan Chandran · Accepted Answer · 2014-11-26 17:17:52Z

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, 2014 at 17:17

Sajan Chandran

11.5k3 gold badges34 silver badges41 bronze badges

Collectives™ on Stack Overflow

hibernate sqlquery to DB without mapping

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related