[jboss-user] [JBossCache] - Query cache and long query strings

klaus_erber do-not-reply at jboss.com
Wed Nov 1 10:16:37 EST 2006


Hello,

we have a problem with to cache queries with long query strings. I normal cache entry looks like this (output from printDetails()):


  |           /sql: select zoneaggreg0_.zone as zone34_, zoneaggreg0_.site as site34_, zoneaggreg0_.intervalstart as interval3_34_, zoneaggreg0_.entId as entId34_, zoneaggreg0_.intervalType as interval5_34_, zoneaggreg0_.version as version34_, zoneaggreg0_.anzahl as anzahl34_, zoneaggreg0_.intervallaenge as interval8_34_ from stat_zone_aggregate zoneaggreg0_ where zoneaggreg0_.zone=? and zoneaggreg0_.site=? and zoneaggreg0_.entId=?; parameters: ; named parameters: {3=2, 2=2, 1=0}
  | item: [11623924548, [Ljava.lang.Object;@1481b9a, [Ljava.lang.Object;@10c2a7a, [Ljava.lang.Object;@1b8e577, [Ljava.lang.Object;@1e0f6df, [Ljava.lang.Object;@6fd685, ...
  | 

On longer queries, we get following output:


  |           /sql: select zoneaggreg0_.zone as zone34_, zoneaggreg0_.site as site34_, zoneaggreg0_.intervalstart as interval3_34_, zoneaggreg0_.entId as entId34_, zoneaggreg0_.intervalType as interval5_34_, zoneaggreg0_.version as version34_, zoneaggreg0_.anzahl as anzahl34_, zoneaggreg0_.intervallaenge as interval8_34_ from stat_zone_aggregate zoneaggreg0_ where zoneaggreg0_.zone=? and zoneaggreg0_.site=? and zoneaggreg0_.entId=? and zoneaggreg0_.intervalType=? and zoneaggreg0_.intervalstart>=? and zoneaggreg0_.intervalstart=? and zoneaggreg0_.intervalstart
  | 

The cache key seems to be cut off. This is not a display problem. We get no cache hits on such a query.

Is this a Bug? Or a wrong way to use it?

regards
Klaus Erber

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3982387#3982387

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3982387



More information about the jboss-user mailing list