Lavie Tobey

Hello,

I have a working HQL query that I'm trying to convert to a QBC. The HQL is below. I've taken several stabs at the QBC, and I've included my attempts, too. Any help getting this working (along with an explanation) would be superb!

Thanks!
Lavie

This returns a list of Task objects.

from Task t where t.loc.locSeq = :Location and t.status < 6 and t.type in ( :Categories ) and t in ( select ta.task from TaskAllocation ta where ta.participant.participantSeq = :-P articipantId )


Sorry about the formatting :-/
DetachedCriteria sub1 = DetachedCriteria.forClass(Task.class) .createAlias("TaskAllocation", "ta") .setProjection(Property.forName("ta.task")) .add(Restrictions.eq("ta.participant.participantSeq", new Long(239321)) ); List list = session.createCriteria(Task.class) .createAlias("Task", "t") .add(Restrictions.eq("t.loc.locSeq" , new Long(14836))) .add(Restrictions.gt("t.status" , new Integer(6)) ) .add(Restrictions.in("t.type", new String[] {"Report"} ) ) .add(Property.forName("t").in(sub1)).list();

For this attempt above, which I think is the closest I came, I got the error:
org.hibernate.QueryException: could not resolve property: Task of: com.mckesson.hac.worklist.om.Task at org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:44) at org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:38) at org.hibernate.persister.entity.AbstractEntityPersister.getSubclassPropertyTableNumber(AbstractEntityPersister.java:1379) at org.hibernate.persister.entity.BasicEntityPropertyMapping.toColumns(BasicEntityPropertyMapping.java:31) at org.hibernate.persister.entity.AbstractEntityPersister.toColumns(AbstractEntityPersister.java:1354) at org.hibernate.loader.criteria.CriteriaQueryTranslator.getColumns(CriteriaQueryTranslator.java:434) at org.hibernate.loader.criteria.CriteriaQueryTranslator.getColumnsUsingProjection(CriteriaQueryTranslator.java:394) at org.hibernate.criterion.SimpleExpression.toSqlString(SimpleExpression.java:45) at org.hibernate.loader.criteria.CriteriaQueryTranslator.getWhereCondition(CriteriaQueryTranslator.java:334) at org.hibernate.loader.criteria.CriteriaJoinWalker.<init>(CriteriaJoinWalker.java:90) at org.hibernate.loader.criteria.CriteriaJoinWalker.<init>(CriteriaJoinWalker.java:59) at org.hibernate.loader.criteria.CriteriaLoader.<init>(CriteriaLoader.java:67) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1550) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283) at staff.StaffIdManager.getTasksByCriteria(StaffIdManager.java:85) at staff.StaffIdManager.main(StaffIdManager.java:23)

[ October 20, 2008: Message edited by: Lavie Tobey ]
[ October 20, 2008: Message edited by: Lavie Tobey ]

I was afraid of that

Thanks for the response!

Hey All -

This is my first post here, so go easy on me

The system I am working on has 2 main databases (we'll call them DB1 and DB2), with tables spread among several schemas. DB2 is accessed via synonyms in DB1, so the application only logs into DB1. To complicate things, tables in DB1 have foreign key mappings into tables in DB2. The tables in DB2 don't have primary keys, only unique indexes.

So, middlegen is not giving me very accurate HBM files. It is basically giving me a class that has no relation to any other table, and it has a composite-id made out of every column.

Has anyone out there dealt with this? I'm not really sure what other information you might need to help me with this, so please ask if I left some stuff out (which I'm sure I did).

Thanks a ton!
Lavie