Hibernate + JBC not reading from cache: spatial or view tabl

[nicholeuf]

Hibernate 3.3.1.GA
Hibernate-spatial 1.0-M2
Spring 2.5.6
JBC 3.0.3.GA

I am noticing that Hibernate + JBC is not retrieving a particular cached query. They query involves a view table and it also involves querying on a spatial field. I have searched the forums and am finding nothing about this topic.

Note that the same configuration does retrieve cached results from a query on a normal table but most of those queries involve string fields.

Has anybody else encountered an issue with the query cache not using results in the cache when the query involves a view or a spatial column?

Thank you in advance,

Nichole

[galder.zamarreno]

Hmmmm, I'm not sure what's the effect of querying view tables and spatial fields and I dunno whether the question has really anything to do with JBoss Cache itself. Have you tried to cache the query using standard hash table cache provider and see if that works? If it does, then there might some issue with JBC. If not, then the problem/question is more to do with Hibernate and how it deals with these type of queries.

[nicholeuf]

The same setup is caching other queries so it is this query in particular that is causing an issue.

[galder.zamarreno]

I don't you understood what I meant. I'm not asking whether other queries get cached or not. You already mentioned that they do. What I'm asking is the following:

Can you use a different cache provider, i.e. HashtableCacheProvider (i.e. see http://docs.jboss.org/hibernate/stable/core/reference/en/html_single/#performance-cache ) and see if the query you're having issues with gets cached or not?