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
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
