Yes and It returns the data I want perfectly......
----- Original Message -----
From: "Toby" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 17, 2001 12:00 PM
Subject: RE: [JBoss-user] CAN I USE JOINS IN BEANS:
> Have you run the query against the database (SQL*PLUS) before testing your
> finder?
> -ryan
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Indika
> Fernando
> Sent: Thursday, May 17, 2001 1:04 AM
> To: [EMAIL PROTECTED]
> Subject: [JBoss-user] CAN I USE JOINS IN BEANS:
>
>
> Ho everyone!
> I am using Bean Manage Persistence(BMP) with a jboss server and an
> oracle database ..when I use a simple query like
> SELECT catID from Category where catName=music ;
> the querry is executed and the Category object is returned .
> but when I use the following querry it returns a null
> the querry is:
> SELECT Category.catID from Category,CategoryUser WHERE
> Category.catID=CategoryUser.catID AND Category.catName=music AND
> CategoryUser.publicField=true
>
> I have two tables called Category and CategoryUser and the sql is executed
> from the CategoryBean beans ejbFindByCatName() :
>
> thanx in advance
> INDI
> hope the given information is enough for u guys...
>
>
>
> _______________________________________________
> 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
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
