Named query definition & configuration problem

[deepakjacob]

I would give Costins suggestion a try, up the logging to get some more information. It's hard to see what is going wrong here.

private Map checkNamedQueries() throws HibernateException {
		Map errors = new HashMap();

		// Check named HQL queries
		log.debug("Checking " + namedQueries.size() + " named HQL queries");
		Iterator itr = namedQueries.entrySet().iterator();
		while ( itr.hasNext() ) {
			final Map.Entry entry = ( Map.Entry ) itr.next();
			final String queryName = ( String ) entry.getKey();
			final NamedQueryDefinition qd = ( NamedQueryDefinition ) entry.getValue();
			// this will throw an error if there's something wrong.
			try {
				log.debug("Checking named query: " + queryName);
				//TODO: BUG! this currently fails for named queries for non-POJO entities
				queryPlanCache.getHQLQueryPlan( qd.getQueryString(), false, CollectionHelper.EMPTY_MAP );
			}
			catch ( QueryException e ) {
				errors.put( queryName, e );
			}
			catch ( MappingException e ) {
				errors.put( queryName, e );
			}
		}

There is a bug in the Hibernate 3 SessionFactoryImpl implemenation.
I got a bug in a NamedQuery. Are you referring to the same ?

[karldmoore]

I think this problem was actually referring to starting the application. Hibernate was actually complaining that there was a problem with the named queries. I didn't managed to replicate this locally however. What is the problem that you are having?

[deepakjacob]

I think this problem was actually referring to starting the application. Hibernate was actually complaining that there was a problem with the named queries. I didn't managed to replicate this locally however. What is the problem that you are having?

'named queries for non-POJO entities' Means I have an annotated POJO like the following and it simply failed to execute.

@Entity
@Table(name = "employee")
@NamedNativeQuery(name = "findEmployeesInSalaryRange", query = "select e from employee as e where e.salary between :minSalary and :maxSalary")
public class Employee extends BaseObject {

//properties

}

If you refer to the above method (in my pervious message) Gavin acknowledges the same in the comment.

[deepakjacob]

I think this problem was actually referring to starting the application. Hibernate was actually complaining that there was a problem with the named queries. I didn't managed to replicate this locally however. What is the problem that you are having?

'named queries for non-POJO entities' Means I have an annotated POJO like the following and it simply failed to execute.

@Entity
@Table(name = "employee")
@NamedQuery(name = "findEmployeesInSalaryRange", query = "select e from employee as e where e.salary between :minSalary and :maxSalary")
public class Employee extends BaseObject {

//properties

}

Earlier query is a NamedQuery and not a NamedNativeQuery. Sorry for the mistake. This error came as I was experimenting whether NamedNativeQuery will work or not..


NB: NamedNativeQuery is not currently supported by hibernate, this also fails