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.
I'm using standard SQL statements to pick up the info
from the database, then working through the result set
and placing the primary keys in the collection.
Now, I reckon this is wrong because I'm accessing the
tables directly in the SQL, rather than going through
the entity beans (rather like using BMP), because I
haven't defined entity beans for the intermediate
tables in the join.
The query doesn't complain when I try do a SELECT on
table that has a corresponding, but tells me that the
table does not exist when I try to query on a table
with no corresponding entity bean.
With an example, I could work out what I'm doing wrong
... :-)
--- David Jencks <[EMAIL PROTECTED]> wrote: >
Hi,
> Did you consult the documentation,
> Customizing Jaws/declaringfinders/custom finders
> with join queries?
>
> david jencks
>
> On 2001.06.07 05:34:00 -0400 Ray wrote:
> > Hi again .... :-)
> >
> > Still working on my problem with customer finders
> >
> > Has anyone got an example of a cusotmer finder
> that
> > uses SQL joins? This appears to be my problem.
> >
> > Did you have to define entity beans for the
> > intermediate tables?
> >
> > Any examples would be much appreciated .... :-)
> >
> >
> >
> >
> >
>
____________________________________________________________
> > Do You Yahoo!?
> > Get your free @yahoo.co.uk address at
> http://mail.yahoo.co.uk
> > or your free @yahoo.ie address at
> http://mail.yahoo.ie
> >
> > _______________________________________________
> > JBoss-user mailing list
> > [EMAIL PROTECTED]
> >
>
http://lists.sourceforge.net/lists/listinfo/jboss-user
> >
>
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
>
http://lists.sourceforge.net/lists/listinfo/jboss-user
____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
