is it possible to write an EJB-QL query that uses normal CMP entity beans, together with plain database fields (not wrapped with an e-bean).
With other words, I need to write a where clause that does something like this:
WHERE myBean.thingyFK.value = ?1
'myBean' is a normal entity bean and has a foreign key to a database table 'thingy'. From this table, I need the column 'value'. The table 'thingy' has no entity bean. (And it is not possible to introduce a new entity bean for this...)
Otherwise I'll have to use a fastlane or something, but at this point I rather want the EJB-QL solution.