HI.

I'm a begginer using nhibernate.

Basically i'm changing an old project to use nhibernate, to study and test purposes.

I'm getting the exception subject of this post.

Thank you for any help.

Alexandre

Hibernate version:
1.2.0.4000

Mapping documents:

Code between sessionFactory.openSession() and session.close():

ISession session = _factory.OpenSession();
ISQLQuery query = session.CreateSQLQuery("SELECT DISTINCT TNSECAO.CODSECAO, TNSECAO.DESCRSECAO FROM TNSECLINHA INNER JOIN TNSECAO ON TNSECLINHA.CODSECAODESTINO = TNSECAO.CODSECAO WHERE (TNSECLINHA.CODSECAOORIGEM = " + CodOrigem + ") ORDER BY DESCRSECAO");
List<Tnsecao> listaObjetos = ConvertIListToGenericList(query.List());
session.Close();
return listaObjetos;

Full stack trace of any exception that occurs:

" em NHibernate.Impl.SqlQueryImpl.VerifyParameters()\r\n em NHibernate.Impl.SqlQueryImpl.List()\r\n em DAL.Tnsecao.ListDestinos(Decimal CodOrigem) na C:\\Users\\Alexandre\\Desktop\\Gerador\\Passagemweb\\Tnsecao.cs:linha 194\r\n em Transnorte.ucSelecaoViagem.ddlOrigem_SelectedIndexChanged(Object sender, EventArgs e) na C:\\Users\\Alexandre\\Documents\\Visual Studio 2005\\Projects\\Transnorte\\Transnorte\\ucSelecaoViagem.ascx.vb:linha 32\r\n em System.Web.UI.WebControls.ListControl.OnSelectedIndexChanged(EventArgs e)\r\n em System.Web.UI.WebControls.DropDownList.RaisePostDataChangedEvent()\r\n em System.Web.UI.WebControls.DropDownList.System.Web.UI.IPostBackDataHandler.RaisePostDataChangedEvent()\r\n em System.Web.UI.Page.RaiseChangedEvents()\r\n em System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)"

Name and version of the database you are using:

MS Sql Server 2005 Express

The generated SQL (show_sql=true):

"SELECT DISTINCT TNSECAO.CODSECAO, TNSECAO.DESCRSECAO FROM TNSECLINHA INNER JOIN TNSECAO ON TNSECLINHA.CODSECAODESTINO = TNSECAO.CODSECAO WHERE (TNSECLINHA.CODSECAOORIGEM = 23) ORDER BY DESCRSECAO"

Debug level Hibernate log excerpt:

{"Return types of SQL query were not specified [SELECT DISTINCT TNSECAO.CODSECAO, TNSECAO.DESCRSECAO FROM TNSECLINHA INNER JOIN TNSECAO ON TNSECLINHA.CODSECAODESTINO = TNSECAO.CODSECAO WHERE (TNSECLINHA.CODSECAOORIGEM = 23) ORDER BY DESCRSECAO]"}

I found the solution.

Here goes if anyone came across the same problem.

Changed the code to between open() and close() session as below:



The documentation about this is not so clear (maybe to me, on the first reading). And i have not found much code hints on the Internet.