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
