createSQLQuery « Map « JPA Q&A

1. NHibernate - CreateSQLQuery exception "No persister for ..", why?

I'm trying to create a SQL query in NHibernate using CreateSQLQuery:

var query = session.CreateSQLQuery(
    "select as loss.Id, loss.start_date as loss.Date, " + 
    " ...

2. createSQLQuery mapping to wrong table name

Newbie Joined: Mon Sep 27, 2004 6:49 pm Posts: 3 The table name is actually sales_total_block_data, but it tries to use the alias name directly. What am I doing wrong? Hibernate version: Hibernate 2.1.6 (09.08.2004) production Mapping documents: