String qryString = "select {cov}.covno, {cov}.covdesc, {polcov}.limitsno from Coveragelku {cov}, Policycoverage {polcov}";

Query qry = session.createSQLQuery(qryString).addEntity("cov", Coverage.class).addEntity("polcov", Policycoverage.class);

List list = qry.list();

-----------------

Above code executes the query as --

DEBUG - closing statement
DEBUG - could not execute query [select cov.covno, cov.covdesc, polcov.limitsno from Coveragelku cov, Policycoverage polcov]
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid column name: covno0_
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

Why is it converting to covno0_ ?

Please help...

Have you tried to execute "select {cov.covno} ..." ?

Yes. That didn't work either.

String qryString = "select {cov.covno}, {cov.covdesc}, {polcov.limitsno} from Coveragelku {cov}, Policycoverage {polcov}";
Query qry = session.createSQLQuery(qryString).addEntity("cov", Coverage.class).addEntity("polcov", Policycoverage.class);
List list = qry.list();

above code gives below error...

DEBUG - select covno0_, covdesc3_0_, limitsno2_1_ from Coveragelku cov, Policycoverage polcov
Hibernate: select covno0_, covdesc3_0_, limitsno2_1_ from Coveragelku cov, Policycoverage polcov
DEBUG - preparing statement
DEBUG - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
DEBUG - closing statement
DEBUG - could not execute query [select covno0_, covdesc3_0_, limitsno2_1_ from Coveragelku cov, Policycoverage polcov]
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid column name 'covno0_'.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

Folks, pleas help!!

If my understanding is correct, native SQL queries are the ones written in database specific SQL format... said that, hibernate shouldnt be modifying the SQL.....

I'm confused why the query is being modified with "covno0_, covdesc3_0_, limitsno2_1_" ?

If this is Hibernate 3, you may wish to read chapter 16 of the doc for that
version.

I'm sorry... i dont understand what criteria queries have to do with what I'm looking for.... may be, you could elaborate a little, please....

I'm sorry... i dont understand what criteria queries have to do with what I'm looking for.... may be, you could elaborate a little, please....

Chapter 17 (Native SQL) [which is Chapter 16 in my 3.0 doc] has
the following example:

Notice that this query is different than the one you included in
your postings. If you make yours look like the one above,
it'll probably work -- it has for me.