How to set column name using setString() hibernate

Question

<sql-query name="sql">
   select :COLUMN_NAME from table.
</sql-query>

I want to set COLUMN_NAME using

this.sessionFactory.getCurrentSession().getNamedQuery("sql")
                .setString("COLUMN_NAME", "id");

I got a wrong result when I use this code (I know where I fail). Is there any way to set COLUMN_NAME using getNamedQuery() and setString().

"got a wrong result" where it went wrong please post the error. — Vishrant
– Vishrant, Commented Mar 4, 2014 at 15:32

Amin Abu-Taleb · Accepted Answer · 2014-03-04 15:00:18Z

0

Have you tried setParameter method?

this.sessionFactory.getCurrentSession().getNamedQuery("sql")
                .setParameter("COLUMN_NAME", "id");

Further info

answered Mar 4, 2014 at 15:00

Amin Abu-Taleb

4,5116 gold badges36 silver badges52 bronze badges

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

3 Comments

maskapsiz Over a year ago

No it doesn't work. it seems COLUMN_NAME as String like select "COLUMN_NAME" from table so it returns COLUMN_NAME word.

Amin Abu-Taleb Over a year ago

So you want to change the name of the column dynamically, why?

maskapsiz Over a year ago

Because table has columns like col1 col2 col3 ... col100. I only want to use 3 columns but these 3 colums can be col5 col10 col30 or col7 col8 col9 or any other option so I want to change sql column name dynamically and call sql like "select col1, col5, col99 from table"

Vishrant · Accepted Answer · 2014-03-04 15:38:51Z

0

You must add <return-scalar column="name_first" type="string" /> to get specific column. like

    <sql-query name="sql">
       <return-scalar column="COLUMN_NAME" type="java.lang.String" />
       select :COLUMN_NAME from table.
    </sql-query>

Or you can use setResultTransformer method if you had created a bean class for that table.

answered Mar 4, 2014 at 15:38

Vishrant

16.9k12 gold badges87 silver badges139 bronze badges

3 Comments

maskapsiz Over a year ago

it return org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions ERROR: Invalid column name but column name is true

Vishrant Over a year ago

You will have to map your table column in your .hbm file or through annotations

Vishrant Over a year ago

After reading your other comment I only want to use 3 columns but these 3... I have a question, will the Data Type of these column will be same, or it will change like sometime it will be Integer sometime Date or something.

Collectives™ on Stack Overflow

How to set column name using setString() hibernate

2 Answers 2

3 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related