Hi,
I misunderstood, I thought you wanted to just define the query in jaws.xml.
If this won't work,
maybe you should show your code and indicate where the exception happens.
david jencks
On 2001.06.07 10:22:13 -0400 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.
>
> 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
>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user