Hi, I have a simple table named PRODUCT consisting of two columns PRODUCTID and PRODUCTNAME. I have written a CMP entity bean and have deployed it on Weblogic 7. I have one finder method findByName which takes the Product Name returns a Collection. Through my client when I call the finder method it does not return any records.
The query under my EJB QL is SELECT OBJECT(o) FROM Product AS o where o.productName = ?1
where Product is the name of the Abstract schema and is same as that of the table.
I modified the query to SELECT OBJECT(o) FROM Product AS o where o.productName like ?1 and SELECT OBJECT(o) FROM Product AS o where o.productName <> ?1
but still I am not getting any records.
I am able to insert records in the DB by calling the create() method on the home interface. But when I call findByPrimaryKey() method and pass the Product Id which exists in the table it gives me a SQLException saying No Data Found.
Are the queries executed by the container logged somewhere and can I see which query it is executing.