Hibernate Community • View topic - Query cache works with HQL but not with Criteria

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Query cache works with HQL but not with Criteria

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

elean

Post subject: Query cache works with HQL but not with Criteria

Posted: Thu Apr 16, 2009 4:24 pm

Newbie

Joined: Mon Apr 14, 2008 2:01 pm
Posts: 4

Hibernate version: 3.2.5

If I use the following HQL query everything works like a charm:

Code:

Query query = session.createQuery("from Employment where since > :now");
query.setDate("now", new Date() );
query.setCacheable(true);

Cache statistics:

Code:

org.hibernate.stat.StatisticsImpl  - query cache puts: 1
org.hibernate.stat.StatisticsImpl  - query cache hits: 3
org.hibernate.stat.StatisticsImpl  - query cache misses: 1

Generated SQL:

Code:

    select
        employment0_.id as id5_,
        employment0_.companyName as companyN2_5_,
        employment0_.since as since5_,
        employment0_.till as till5_ 
    from
        Employment employment0_ 
    where
        employment0_.since>?

But with the criteria API it won't work:

Code:

Criteria criteria = session.createCriteria(Employment.class);
criteria.add(Restrictions.gt("since", new Date()));
criteria.setCacheable(true);

Cache statistics:

Code:

org.hibernate.stat.StatisticsImpl  - query cache puts: 4
org.hibernate.stat.StatisticsImpl  - query cache hits: 0
org.hibernate.stat.StatisticsImpl  - query cache misses: 4

Generated SQL:

Code:

    select
        this_.id as id5_0_,
        this_.companyName as companyN2_5_0_,
        this_.since as since5_0_,
        this_.till as till5_0_ 
    from
        Employment this_ 
    where
        this_.since>?

Is it a bug or am I missing something ?

Top

elean

Post subject: Re: Query cache works with HQL but not with Criteria

Posted: Sat May 02, 2009 7:47 am

Newbie

Joined: Mon Apr 14, 2008 2:01 pm
Posts: 4

It appears that answer to my question is "Yes you're missing something" ;).

If you use Criteria a type is implicitly inferred and by default an instance of Date is mapped as Temporal.TIMESTAMP. So the behaviour is correct and criteria is diferent every time thus not cached.

When using Query "setDate" the "SQL Date" (just day/month/year) is used so caching works. The same effect as with Criteria query is achieved if "setTimestamp" is used instead.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum