The following line works fine and gives me all employees:

The next line gives me the error: No column name found for property [Active] [].

The columns are there and the mapping file is correct. Any clues what I did wrong?

UPDATE:
I tried the following:

The SQL query it generated was correct, but I got the following exception: System.IndexOutOfRangeException: EmployeeId0_

Thanks, Cepheus.

Looks like a bug, SQL queries were not tested well enough yet, so there may be other bugs in there. Please report this one to JIRA so it doesn't get lost.

Late Answer, but:

1. if you want to show the Employees who are active try:
IList test = entityService.ExecuteSQLQuery("SELECT {emp.*} FROM Employees {emp} where em.Active = 'true'", "emp", typeof(Employee));

2. Hibernate cant create a Pojo without all Properties?
IList test = entityService.ExecuteSQLQuery("SELECT {emp}.Active AS {emp.Active} FROM Employees {emp}", "emp", typeof(Employee));
would give you a list like:
true
false
false
true
...
->how should hibernate create pojos from this rows?