Bear in mind that the ability to do finders like this (BMP style finders
for a CMP bean) is a JBoss specific feature.
Now, to your problem:
I'm not at all a MySQL expert, but is it possible that there's a
permission/namespace problem there? For example, if JBoss created the
table that corresponds to your bean as one user, and you created the
intermediate tables as another user, some databases (Oracle, IIRC) would
put them in different schemas, and you'd need to either create aliases
so that they show up together, or use 'schema.tablename' notation to
reference them. Another possibility is that (again if the tables were
created by different users) JBoss is not allowed to see the ones you
created manually.
Ray wrote:
> Yep, I did ...
>
> I've got the finder declared in the jaws.xml file
> working OK, but it's defining it in the bean that's
> the problem.
>
> Unfortunately, the example given:
> ------------------------------------------
> public class PopulationEJB implements EJBObject {
> public Collection ejbFindByProvinceAndType(String
> provinceId, int type) {
> // .. fill Collection with primary keys of
> result objects
> return aResultCollection;
> }
> }
> ---------------------------------------------
>
> .. has a big whole in the interesting bit.
Confidential e-mail for addressee only. Access to this e-mail by anyone else is
unauthorized.
If you have received this message in error, please notify the sender immediately by
reply e-mail
and destroy the original communication.
