Hi,

I have just started using hibernate and I have a simple application that creates a few tables, (POJO classes mapped) and inserting data in the tables , so far this is successfull. I end the application and start a new test program:
I initialize
(EntityManagerFactory emf = Persistence.createEntityManagerFactory("hibernatetest");
EntityManager = emf.createEntityManager(); )
and next I do a query upon the database I created before and this is the exception thrown:

javax.persistence.NoResultException: No entity found for query
at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.java:84)

That is perfectly understanble, for the data I had previously saved in the database it's cleared off and deleted. Has anyone experienced this before?
Why does the data disappear from the database ? Help Pleaseeee!

Thank you,

Tux

I don't think that's your problem. what is the query like and how do you do it?



Farzad-

I don't think that's your problem. what is the query like and how do you do it?



Farzad-[/quote]

Hi
Thanks for the prompt reply!

my query looks like this:


public User findUser(String username){


User user = new User();
Query query = em.createNamedQuery("User.byname");
query.setParameter("thename", username);
try {
user = (User)query.getSingleResult();
} catch (NoResultException e) {
e.printStackTrace();
}

return user;
}

I have created a named query that look like this:

(this is the User entity that I am trying to map, insert data and then query)

@Entity
@NamedQuery(name="User.byname",
query="Select r from User r where r.name = :thename")
The Id of the User is the username and that's assigend not auto generated.
Any ideas ?
Thanks a lot!

tux

I don't see much here except the database you're connected to does not have the user. Are you sure the data exists in the database?



Farzad-

Hi!

Thanks for the replies! Found the error - it was in the persistence.xml where I had set the value to create and drop tables!

Cheers,
Tux