Hi, I'm trying to use session.createSqlQuery() in order to use oracle's "connect by" syntax. I seem to run into a problem when retrieving an entity which contains a formula field (formula + exception included below). Temporarily removing the formula field or setting it to transient makes the problem go away. Also, retrieving the entity using a non-native query seems to work fine - it's just the combination of the formula field and either .createNativeQuery or createSqlQuery that does it.

Has anyone gotten this combination to work?
Hibernate version:
3.2.0 GA, annotation 3.2.0-GA, entitymanager 3.2.0-GA
Mapping documents: (done through annotations)

@Entity
@Table(name = "FOLDER")
@AttributeOverride(name="name", column=@Column(name="FOLDER_NAME"))
public class SimpleFolder implements Folder {
.....

@Formula("(select count(f2.folder_id) from folder f2 where f2.parent_folder_id = folder_id)")
private Boolean hasChildren = Boolean.FALSE;
}


Code between sessionFactory.openSession() and session.close():
session.createSQLQuery("select {f.*}"
+
" from folder f connect by " +
"prior parent_folder_id = folder_id " +
"start with folder_id = " + childId).addEntity(SimpleFolder.class).list();

Full stack trace of any exception that occurs:
java.lang.NullPointerException
at org.hibernate.loader.DefaultEntityAliases.intern(DefaultEntityAliases.java:133)
at org.hibernate.loader.DefaultEntityAliases.getSuffixedPropertyAliases(DefaultEntityAliases.java:106)
at org.hibernate.loader.DefaultEntityAliases.<init>(DefaultEntityAliases.java:52)
at org.hibernate.loader.ColumnEntityAliases.<init>(ColumnEntityAliases.java:16)
at org.hibernate.loader.custom.sql.SQLQueryReturnProcessor.generateCustomReturns(SQLQueryReturnProcessor.java:174)
at org.hibernate.loader.custom.sql.SQLCustomQuery.<init>(SQLCustomQuery.java:129)
at org.hibernate.engine.query.NativeSQLQueryPlan.<init>(NativeSQLQueryPlan.java:43)
at org.hibernate.engine.query.QueryPlanCache.getNativeSQLQueryPlan(QueryPlanCache.java:114)
at org.hibernate.impl.AbstractSessionImpl.getNativeSQLQueryPlan(AbstractSessionImpl.java:137)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:150)
at......


Name and version of the database you are using:
Oracle 10G
The generated SQL (show_sql=true):
doesn't get to that point
Debug level Hibernate log excerpt:

I am also getting the exact same bug however I am using hbm mapping files instead of annontations.

I am also getting the exact same bug however I am using hbm mapping files instead of annontations. Did you manage to resolve this problem?

Hi,
I managed to get this to work w/ some slight changes to the syntax:

BAD (wasn't working)


GOOD (worked)


Hope that helps.