Hibernate. HQL query with transistent object as a parameter

Question

I want to check existance of object in database without knowing his id. I'm using a HQL query for it, but i'm recieving an excenption

org.hibernate.TransientObjectException: 
object references an unsaved transient instance - save the transient instance before flushing

Here is my code exapmle:

ObjectToCheck obj = new ObjectToCheck(); //this is a mapped entity
obj.setName("name");
obj.setValue("value");
List list = session.createQuery("from ObjectToCheck as o where o = ?")
        .setEntity(0, obj)
        .list();

I understand the reason of this exception, but how can i make query with transistent object as a parameter? I want to know, is the equal object in database or not.

Does your object have an id attribute?

Pulkit Goyal
– Pulkit Goyal

2012-02-01 09:38:20 +00:00
Commented Feb 1, 2012 at 9:38 — Pulkit Goyal
– Pulkit Goyal, Commented Feb 1, 2012 at 9:38

JB Nizet · Accepted Answer · 2012-02-01 09:38:06Z

4

I don't think the exception comes from the fact that you're using a transient entity as a parameter of your query (although this query is also wrong, see below).

The exception comes from the fact that Hibernate flushes the session before executing the query, but you have attached a transient entity to an attached one in the session. It thus tries to save the association, but since the object is transient and doesn't have any ID yet, this is not possible.

Now your query: where o = ? won't magically query by name and value. It will query by ID. And this is precisely what you don't want to do. The query should thus be:

select o from ObjectToCheck o where o.name = :name and o.value = :value

And you should bind both parameters. Another way to do this is to use a query by example. See http://docs.jboss.org/hibernate/core/3.6/reference/en-US/html_single/#querycriteria-examples.

answered Feb 1, 2012 at 9:38

JB Nizet

694k94 gold badges1.3k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Pazonec Over a year ago

I've posted too simple example. I have the set of related objects by many to one besides the name and value(like in the yeasterday's question). I'm still trying to make it without loops:(

Rafael Pizao · Accepted Answer · 2018-06-08 14:10:26Z

0

Another (and better) option is:

from ObjectToCheck as o where o.name = :#{#obj.name}

This solution has already been suggested in another post.

answered Jun 8, 2018 at 14:10

Rafael Pizao

88111 silver badges24 bronze badges

Collectives™ on Stack Overflow

Hibernate. HQL query with transistent object as a parameter

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related