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