@Entity @Table(name = "ALL_TABLES" ) public class AllTables { @Id @Column(name = "TABLE_NAME" , nullable = false ) private String tableName; @Formula(value = "(SYSDATE())" ) private String daysOld; //getters and setters } String sql = "select table_name , sysdate() from all_tables where table_name = 'AUDIT_ACTIONS' " ; SQLQuery q = s.createSQLQuery( sql ).addEntity( "t" ,AllTables.class ); workaround 1 – using @SqlResultSetMapping: String sql = "select table_name as t_name, sysdate() as t_time from all_tables where table_name = 'AUDIT_ACTIONS' " ; @SqlResultSetMapping(name = "all" , entities = @EntityResult(entityClass = AllTables.class, fields = { @FieldResult(name = "tableName" , column = "t_name" ), @FieldResult(name = "daysOld" , column = "t_time" ) })) workaround 2 -- provide alias for each scalar property: String sql = "select t.table_name as {t.tableName} , sysdate() as {t.daysOld} from all_tables t where t.table_name = 'AUDIT_ACTIONS' "; SQLQuery q = s.createSQLQuery( sql ).addEntity( "t",AllTables.class ); workaround 3 -- query directly: String sql = "select table_name , sysdate() from all_tables where table_name = 'AUDIT_ACTIONS' "; SQLQuery q = s.createSQLQuery( sql );

When an entity has attributes mapped as @Formula, and using native query, but select clause elements do not have an alias, and _addEntity_ is used, a NullPointerException would be thrown, for example: <programlisting lang="java"> @Entity @Table(name = "ALL_TABLES")  public class AllTables { @Id @Column(name = "TABLE_NAME", nullable = false) private String tableName; @Formula(value = "(SYSDATE())") private String daysOld; //getters and setters  } </programlisting> <programlisting lang="java">String sql = "select table_name , sysdate() from all_tables where table_name = 'AUDIT_ACTIONS' "; SQLQuery q = s.createSQLQuery( sql ).addEntity( "t",AllTables.class ); <programlisting lang="java"> To resolve this issue would require major changes to Hibernate so this issue will remain unresolved. Use one of the following workarounds to avoid this issue: Workaround option 1: Use @SqlResultSetMapping: <programlisting lang="java"> String sql = "select table_name as t_name, sysdate() as t_time from all_tables where table_name = 'AUDIT_ACTIONS' "; @SqlResultSetMapping(name = "all", entities = @EntityResult(entityClass = AllTables.class, fields = { @FieldResult(name = "tableName", column = "t_name"), @FieldResult(name = "daysOld", column = "t_time") })) </programlisting> Workaround option 2: Provide an alias for each scalar property: <programlisting lang="java"> String sql = "select t.table_name as {t.tableName}, sysdate() as {t.daysOld} from all_tables t where t.table_name = 'AUDIT_ACTIONS' "; SQLQuery q = s.createSQLQuery( sql ).addEntity( "t",AllTables.class ); </programlisting> Workaround option 3: Query directly: <programlisting lang="java"> String sql = "select table_name , sysdate() from all_tables where table_name = 'AUDIT_ACTIONS' "; SQLQuery q = s.createSQLQuery( sql ); </programlisting>