I have a couple of tables with large numbers of columns. Hibernate lists all the solumns in the target tables when converting HQL to SQL. I remember there was a way to force Hibernate just to use "select * from ..." instead of listing all the columns in the SELECT clause. How do I do this?

Thanks.

Alec

select cat from Cat cat is somehow equlvalent to select * from CAT_TABLE

"select cat from Cat" HQL query will be translated to "select name, gender, age, from cat" SQL query.

What I need is and HQL query that would be translated into "select * from cat"! I remember there was a way to force Hibernate to use "select *" instead of listing all the columns, but can't remember how to do this.

Why do you want to do this?

I want to replace a list off columns in the SELECT clause with a * in order to reduce the size of the query sent to the DB server. By default Hibernate uses column names to retrieve data from the result set, so there is no need to list all columns in the SELECT clause anyway.
So, the question persists, how do I configure Hibernate to use "SELECT *" instead of "SELECT list_of_all_columns"

Thanks.

Alec

You cannot.
Hibernate has to use alias to correctly match columns to java properties.
Plus I'm not sure the column order is well known when you use *

select * is bad practice. Hibernate never uses this.

I think it makes sense to use select * and then use column names to retrieve values from the result set. Or, if Hibernate lists all the column names in the select clause, then column indices should be used to retrieve values from the results set. As far as I know Hibernate looks up values by column names, so using "select *" makes sense.

Hibernate use the index to retrieve column. Use of Driver metadata may be slow.