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

Reply via email to