Search...
FAQs Subscribe
Pie
FAQs
Recent topics Flagged topics Hot topics Best topics
Search...
Search within OCEEJBD Search Coderanch
Advance search Google search
Register / Login
This week's book giveaway is in the Agile and Other Processes forum.
We're giving away four copies of Darcy DeClute's Scrum Master Certification Guide: The Definitive Resource for Passing the CSM and PSM Exams and have Darcy DeClute on-line!
See this thread for details.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
book review grid thread boost building better world book meaningless drivel advertise on coderanch
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Devaka Cooray
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Jeanne Boyarsky
  • Tim Cooke
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Tim Moores
  • Mikalai Zaikin
  • Carey Brown
Bartenders:

Problem javax.persistence.NoResultException: No entity found for query

 
Amirr Rafique
Ranch Hand
Posts: 324
posted 14 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Hi mates

I am getting following exception. Please help me out in understanding the reason



Below is my bean code.

"Know where to find the solution and how to use it - that's the secret of success."

 
Niranjan Deshpande
Ranch Hand
Posts: 1277
posted 14 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Are you missing the SELECT clause in the query?

SCJP 1.4 - 95% [ My Story ] - SCWCD 1.4 - 91% [ My Story ]
Performance is a compulsion, not a option, if my existence is to be justified.

 
Promod kumar
Ranch Hand
Posts: 90
posted 14 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
I see this in the stack, Caused by: javax.persistence.NoResultException: No entity found for query. If there is no result to your query, then a NoResultExceptions is thrown. Try replacing this (since cabin id=1 was persisted using manager)


with

 
Niranjan Deshpande
Ranch Hand
Posts: 1277
posted 14 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
how does this work even if there is no SELECT clause?

SCJP 1.4 - 95% [ My Story ] - SCWCD 1.4 - 91% [ My Story ]
Performance is a compulsion, not a option, if my existence is to be justified.

 
Promod kumar
Ranch Hand
Posts: 90
posted 14 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Niranjan,
I just tried it and it works, I guess it defaults to "select entity" if select is missing. I was not aware of it before reading this thread. I am pasting the HQL and the generated SQL from my jboss log.

2009-04-15 11:51:38,025 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] HQL: FROM com.ejb3inaction.actionbazaar.persistence.Category c WHERE c.categoryName =?1
2009-04-15 11:51:38,025 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] SQL: select category0_.CATEGORY_ID as CATEGORY1_2_, category0_.CREATED_BY as CREATED4_2_, category0_.CATEGORY_NAME as CATEGORY2_2_, category0_.PARENT_ID as PARENT5_2_, category0_.CREATE_DATE as CREATE3_2_ from CATEGORIES category0_ where category0_.CATEGORY_NAME=?

 
Hong Anderson
Ranch Hand
Posts: 1936
posted 14 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Next time, you can take a look at SQL log. This is one drawback of ORM, you don't write SQL, it generates for you, sometimes you don't know what is going on. Actually it's both drawback and advantage .

SCJA 1.0, SCJP 1.4, SCWCD 1.4, SCBCD 1.3, SCJP 5.0, SCEA 5, SCBCD 5; OCUP - Fundamental, Intermediate and Advanced; IBM Certified Solution Designer - OOAD, vUML 2; SpringSource Certified Spring Professional

 
Amirr Rafique
Ranch Hand
Posts: 324
posted 14 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Guys I am not able to understand it. I have two entity managers(manager and createdMngr) both are connected to same persistence unit. I am using manager to persistence cabin with id 1 and using createdMngr I am trying to query using other persistence manager. Why I am not able to find it

"Know where to find the solution and how to use it - that's the secret of success."

 
Amirr Rafique
Ranch Hand
Posts: 324
posted 14 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Following is my persistence.xml

"Know where to find the solution and how to use it - that's the secret of success."

 
Promod kumar
Ranch Hand
Posts: 90
posted 14 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Amirr,
Each EntityManager has an associated PersistenceContext. In this case there are 2 EntityManagers and they have two separate PersistenceContexts which are unaware of each other even though their PersistenceUnits are the same. So to get it to work if you do something like this then it will work since the cabin will be saved to the DB and the query retrieves it from DB when you use the query with createdMngr.



I have relied mostly on testing to come to the above conclusion, I would like someone else to validate if this explanation is accurate.
 
Hong Anderson
Ranch Hand
Posts: 1936
posted 14 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
When persisted, have the transaction been committed?
Can you post your codes?

SCJA 1.0, SCJP 1.4, SCWCD 1.4, SCBCD 1.3, SCJP 5.0, SCEA 5, SCBCD 5; OCUP - Fundamental, Intermediate and Advanced; IBM Certified Solution Designer - OOAD, vUML 2; SpringSource Certified Spring Professional

 
Promod kumar
Ranch Hand
Posts: 90
posted 14 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Kengkaj,

Here is my code. I verified the DB and the sysout statements.

public void addCustomer(String firstName, String lastName) {
System.out.println("In addCustomer");
Customer cust = new Customer();
cust.setFirstName(firstName);
cust.setLastName(lastName);
EntityManager createdMngr = emf.createEntityManager();
em.persist(cust);
em.flush();
Query query = createdMngr
.createQuery("select c from Customer c where c.firstName = ?1");
query.setParameter(1, "Vijay");
Customer customer = (Customer) query.getSingleResult();
System.out.println("The customerlast name is: "
+ customer.getLastName());
createdMngr.close();

}

 
Amit Ghorpade
Bartender
Posts: 2856
10
I like...
Firefox Browser Fedora Java
posted 14 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
"Promod Mahajan " please check your private messages for an important administrative matter. You can check them by clicking the My Private Messages link above.

SCJP, SCWCD.
|Asking Good Questions|

 
Hong Anderson
Ranch Hand
Posts: 1936
posted 14 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Promod,
You should query from another method, not within the same method with persisting.
And you haven't closed entity manager, using Application Managed Entity Manager, you have to close it yourself.

SCJA 1.0, SCJP 1.4, SCWCD 1.4, SCBCD 1.3, SCJP 5.0, SCEA 5, SCBCD 5; OCUP - Fundamental, Intermediate and Advanced; IBM Certified Solution Designer - OOAD, vUML 2; SpringSource Certified Spring Professional

 
Promod kumar
Ranch Hand
Posts: 90
posted 14 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
kengkaj,
You can run the query from within the same method/transaction. In this case before executing the query, the EntityManager first flushes all the pending updates and then runs the query.
Yes, I did forget to close the em, Thanks for pointing it out.
 
Hong Anderson
Ranch Hand
Posts: 1936
posted 14 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
I don't know, your code seems correct excepts you need to put createdMngr.close(); in finally block.
Try to check generated SQL and copy/paste SQL to run against DB.

SCJA 1.0, SCJP 1.4, SCWCD 1.4, SCBCD 1.3, SCJP 5.0, SCEA 5, SCBCD 5; OCUP - Fundamental, Intermediate and Advanced; IBM Certified Solution Designer - OOAD, vUML 2; SpringSource Certified Spring Professional

 
Promod kumar
Ranch Hand
Posts: 90
posted 14 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Kengkaj,
I think there is some confusion here. My code works and is giving the expected result. I was trying to answer Amirr.
When you asked to post the code, I thought you were asking me, may be you were asking the original poster Amirr.
 
Amirr Rafique
Ranch Hand
Posts: 324
posted 14 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Following code has solved the problem


Thanks for your help

"Know where to find the solution and how to use it - that's the secret of success."

 
Hong Anderson
Ranch Hand
Posts: 1936
posted 14 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Promod, I got confused, I actually wanted to ask the topic creator .

SCJA 1.0, SCJP 1.4, SCWCD 1.4, SCBCD 1.3, SCJP 5.0, SCEA 5, SCBCD 5; OCUP - Fundamental, Intermediate and Advanced; IBM Certified Solution Designer - OOAD, vUML 2; SpringSource Certified Spring Professional

 
Yup, yup, yup. Tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
reply
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!
Similar Threads
More...