Hello, I need help with defining a finder query. Here's the set up: CMP DataWatchItem has a member String called name. Its primary key is GUID guid (a homegrown globally unique identifier, that is Serializable). DataWatchItem works fine -- it can be created, found, and used. CMP DataWatchLogItem, has a member DataWatchItem called source. Its primary key is also a GUID. It also works fine. I want to define a finder method on DataWatchLogItem, findByName (String searchName). The logic is simple -- return a collection of DataWatchLogItem such that source.name equals searchName. How do I express this in orion-ejb-jar.xml? I tried <finder-method query="$source->getUsername() = $1"> It deploys but gives a runtime error 10/28/00 4:48 PM Error in bean DataWatchLogItem: Database Error java.sql.SQLException: General error in statement [select DataWatchLogItem.guid, DataWatchLogItem.source, DataWatchLogItem.runOn, DataWatchLogItem.evaluatedValue, DataWatchLogItem.errorString from DataWatchLogItem where DataWatchLogItem.source->getUsername() = 'vdhanda'] When I use, <finder-method query="$source.username = $1"> On deployment, I get the error: Auto-deploying lib (No previous deployment found)... Error compiling file:/C:/dev/lib/: Unable to process query: source was not a property/field mapped field (invalid '.' use) at column 16 in query '?source.username = ?1' Is expressing such a query possible in Orion? Thanks, Vidur -- Vidur Dhanda Active Solutions tel: 617/566-1252 [EMAIL PROTECTED] www.active-solutions-inc.com
