Problems with SQL generated from CreateQuery method

mdsrlz · **Posted:** Tue Jan 17, 2006 3:01 pm

Hi.

I'm using the following SQL with the CreateQuery method:

Code:

string query = "FROM Atividade ORDER BY AtiId";

Well, the NHibernate generates the SQL using AtiId instead of ATI_ID (the name of the field into the database). The XML mapping is correct.

To resolve this, I used it:

Code:

string query = "FROM Atividade AS atividade ORDER BY atividade.AtiId";

Is it correct?

Thanks!

sergey · **Posted:** Tue Jan 17, 2006 3:16 pm

Yes. In HQL you can't just refer to properties without specifying which object they belong to.

mdsrlz · **Posted:** Tue Jan 17, 2006 3:27 pm

sergey wrote:

Yes. In HQL you can't just refer to properties without specifying which object they belong to.

Hi!

And without the object, the query will be generated with tha same name of the "property"?

For example, the query above would be:

Code:

SELECT * FROM atividade ORDER BY AtiId

Is it true?

I have another question... do you know how can I do to see what SQL NHibernate generates?

Thanks Sergey!

michal · **Posted:** Tue Jan 17, 2006 5:50 pm

Hi,

As Sergey mentioned "you can't just refer to properties without specifying which object they belong to" - in the book "Hibernate in action" it is explained very nice - to treat "alias" in HQL as something like "object reference" (BTW - I just read the book almost at one sitting and I _really_ recommend doing so , it is just amazing, java instead of .net is not an issue at all here)

About watching the SQL generated - 1) use log4net -> http://www.hibernate.org/364.html , 2) for MS sql you can try sql profiler 3) there is NH configuration parameter "show_sql=true" but personally I never tried this

mdsrlz · **Posted:** Wed Jan 18, 2006 11:37 am

michal wrote:

About watching the SQL generated - 1) use log4net -> http://www.hibernate.org/364.html , 2) for MS sql you can try sql profiler 3) there is NH configuration parameter "show_sql=true" but personally I never tried this

And NHibernate Query Analyzer, do you know?

Thanks! :~)