Hi,
The following isn't working, even though some very similar code in
net.sf.basedb.core.LabeledExtract works fine (I assume). I'm just restricting
on a hard-coded "name" at the moment for testing:
ItemQuery<net.sf.basedb.core.Hybridization> itemQuery =
Hybridization.getQuery();
itemQuery.include(Include.SHARED);
itemQuery.setDistinct(true);
itemQuery.join(Hql.innerJoin("creationEvent.sources",
Item.LABELEDEXTRACT.getAlias()));
itemQuery.restrict(
Restrictions.eq(
Hql.property(Item.LABELEDEXTRACT.getAlias(), "name"),
Expressions.string("uci_tissues_fb_3.s1.e1.lbe1")
)
);
... = itemQuery.list(dc);
[java] Exception in thread "main" net.sf.basedb.core.BaseException: could
not resolve property: name of: component[usedQuantity,dummy] [SELECT DISTINCT
hyb FROM net.sf.basedb.core.data.HybridizationData hyb INNER JOIN
hyb.creationEvent.sources lbe WHERE (lbe.name =
:P1555286c83a454f1a9e048f5efbcde73)]
[java] at
net.sf.basedb.core.HibernateUtil.createQuery(HibernateUtil.java:1349)
[java] at
net.sf.basedb.core.AbstractEntityQuery.getMainHqlQuery(AbstractEntityQuery.java:349)
[java] at net.sf.basedb.core.ItemQuery.list(ItemQuery.java:93)
If I print out the query it looks like this
[java] ItemQuery: SELECT DISTINCT hyb.null FROM
net.sf.basedb.core.data.HybridizationData hyb INNER JOIN creationEvent.sources
lbe WHERE (lbe.name =
:P1555286c83a454f1a9e048f5efbcde73(uci_tissues_fb_3.s1.e1.lbe1))
Once we get this working, we want to join all the way to Sample - do you think
that will be possible?
many thanks,
Bob.
--
Bob MacCallum | VectorBase Developer | Kafatos/Christophides Groups |
Division of Cell and Molecular Biology | Imperial College London |
Phone +442075941945 | Email [EMAIL PROTECTED]
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
basedb-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/basedb-devel
