The session about native query seems contains a lot of issues:

1. There are lots of usage of Hibernate.TYPENAME (e.g. Hibernate.LONG) which does not exists in 4.2
2. In section 18.1.4, the table alias provided to addEntity() does not match with the table alias in the SQL