This week's book giveaway is in the OCAJP forum.
We're giving away four copies of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) and have Khalid A Mughal & Rolf W Rasmussen on-line!
See this thread for details.
Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

EJB QL Problems

 
Jayesh Netravali
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

My database is MS Access.

Thanks in advance.
Jayesh.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic