I'm doing this:

string strSql = "select {nf.*} from ADFinance.Faturamento.NotaFiscal {nf}";
IQuery q = NHibernateSessionManager.Instance.GetSession().CreateSQLQuery(strSql, "nf", typeof(NotaFiscal));

Assert.Greater(q.List().Count, 0);


I'm receiving the following erro:

ADFinance.Testes.Core.Faturamento.NotaFiscalTestes.SelecionaComCapaLote : NHibernate.ADOException : error in FindBySQL
----> System.Data.OracleClient.OracleException : ORA-00933: SQL command not properly ended

Does anyone know what is the problem??


Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

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

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

anyone know??

i need some help...

Enable show_sql and look at the generated SQL statement. Attempt to run that in SQL*Plus

You can enable show_sql in your nhibernate config section.