The method shown below is called twice with two set of queries. The difference is in the where clause: the 1st set selects data from 2005 and the 2nd from 2004. Section 19.4 of the 3.0 doc says:
Quote:
Most queries do not benefit from caching, so by default queries are not cached.
I have not enabled query caching. However, the log shows, and using
the debugger confirms, that the 2nd call to the method returns the
same data as the 1st -- despite the evict()'s (which were added later).
Replacing the evicts() with a session.clear() does return the correct results.
Why doesn't evicting these classes work?
Hibernate version:
3.0
Mapping documents:
Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.timestock.tess.objects.HistogramMinMax" mutable="false">
<id name="id" type="java.lang.Long"/>
<property name="sizeMinBucket" type="java.lang.Integer"/>
<property name="sizeMaxBucket" type="java.lang.Integer"/>
<property name="timeMinBucket" type="java.lang.Integer"/>
<property name="timeMaxBucket" type="java.lang.Integer"/>
<property name="throughputMinBucket" type="java.lang.Integer"/>
<property name="throughputMaxBucket" type="java.lang.Integer"/>
</class>
</hibernate-mapping>
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.timestock.tess.objects.HistogramData" mutable="false">
<id name="id" type="java.lang.Long"/>
<property name="tphB0" type="java.lang.Integer"/>
<property name="tphB1" type="java.lang.Integer"/>
<property name="tphB2" type="java.lang.Integer"/>
<property name="tphB3" type="java.lang.Integer"/>
<property name="tphB4" type="java.lang.Integer"/>
<property name="tphB5" type="java.lang.Integer"/>
<property name="tphB6" type="java.lang.Integer"/>
<property name="tphB7" type="java.lang.Integer"/>
<property name="tphB8" type="java.lang.Integer"/>
<property name="tphB9" type="java.lang.Integer"/>
<property name="tphB10" type="java.lang.Integer"/>
<property name="tphB11" type="java.lang.Integer"/>
<property name="tphB12" type="java.lang.Integer"/>
<property name="tphB13" type="java.lang.Integer"/>
<property name="tphB14" type="java.lang.Integer"/>
<property name="tphB15" type="java.lang.Integer"/>
<property name="tphB16" type="java.lang.Integer"/>
<property name="tphB17" type="java.lang.Integer"/>
<property name="tphB18" type="java.lang.Integer"/>
<property name="tphB19" type="java.lang.Integer"/>
<property name="tphB20" type="java.lang.Integer"/>
<property name="tphB21" type="java.lang.Integer"/>
<property name="tphB22" type="java.lang.Integer"/>
<property name="tphB23" type="java.lang.Integer"/>
<property name="tphB24" type="java.lang.Integer"/>
<property name="tphC0" type="java.lang.Integer"/>
<property name="tphC1" type="java.lang.Integer"/>
<property name="tphC2" type="java.lang.Integer"/>
<property name="tphC3" type="java.lang.Integer"/>
<property name="tphC4" type="java.lang.Integer"/>
<property name="tphC5" type="java.lang.Integer"/>
<property name="tphC6" type="java.lang.Integer"/>
<property name="tphC7" type="java.lang.Integer"/>
<property name="tphC8" type="java.lang.Integer"/>
<property name="tphC9" type="java.lang.Integer"/>
<property name="tphC10" type="java.lang.Integer"/>
<property name="tphC11" type="java.lang.Integer"/>
<property name="tphC12" type="java.lang.Integer"/>
<property name="tphC13" type="java.lang.Integer"/>
<property name="tphC14" type="java.lang.Integer"/>
<property name="tphC15" type="java.lang.Integer"/>
<property name="tphC16" type="java.lang.Integer"/>
<property name="tphC17" type="java.lang.Integer"/>
<property name="tphC18" type="java.lang.Integer"/>
<property name="tphC19" type="java.lang.Integer"/>
<property name="tphC20" type="java.lang.Integer"/>
<property name="tphC21" type="java.lang.Integer"/>
<property name="tphC22" type="java.lang.Integer"/>
<property name="tphC23" type="java.lang.Integer"/>
<property name="tshB0" type="java.lang.Integer"/>
<property name="tshB1" type="java.lang.Integer"/>
<property name="tshB2" type="java.lang.Integer"/>
<property name="tshB3" type="java.lang.Integer"/>
<property name="tshB4" type="java.lang.Integer"/>
<property name="tshB5" type="java.lang.Integer"/>
<property name="tshB6" type="java.lang.Integer"/>
<property name="tshB7" type="java.lang.Integer"/>
<property name="tshB8" type="java.lang.Integer"/>
<property name="tshB9" type="java.lang.Integer"/>
<property name="tshB10" type="java.lang.Integer"/>
<property name="tshB11" type="java.lang.Integer"/>
<property name="tshB12" type="java.lang.Integer"/>
<property name="tshB13" type="java.lang.Integer"/>
<property name="tshB14" type="java.lang.Integer"/>
<property name="tshB15" type="java.lang.Integer"/>
<property name="tshB16" type="java.lang.Integer"/>
<property name="tshB17" type="java.lang.Integer"/>
<property name="tshB18" type="java.lang.Integer"/>
<property name="tshB19" type="java.lang.Integer"/>
<property name="tshB20" type="java.lang.Integer"/>
<property name="tshB21" type="java.lang.Integer"/>
<property name="tshB22" type="java.lang.Integer"/>
<property name="tshB23" type="java.lang.Integer"/>
<property name="tshB24" type="java.lang.Integer"/>
<property name="tshC0" type="java.lang.Integer"/>
<property name="tshC1" type="java.lang.Integer"/>
<property name="tshC2" type="java.lang.Integer"/>
<property name="tshC3" type="java.lang.Integer"/>
<property name="tshC4" type="java.lang.Integer"/>
<property name="tshC5" type="java.lang.Integer"/>
<property name="tshC6" type="java.lang.Integer"/>
<property name="tshC7" type="java.lang.Integer"/>
<property name="tshC8" type="java.lang.Integer"/>
<property name="tshC9" type="java.lang.Integer"/>
<property name="tshC10" type="java.lang.Integer"/>
<property name="tshC11" type="java.lang.Integer"/>
<property name="tshC12" type="java.lang.Integer"/>
<property name="tshC13" type="java.lang.Integer"/>
<property name="tshC14" type="java.lang.Integer"/>
<property name="tshC15" type="java.lang.Integer"/>
<property name="tshC16" type="java.lang.Integer"/>
<property name="tshC17" type="java.lang.Integer"/>
<property name="tshC18" type="java.lang.Integer"/>
<property name="tshC19" type="java.lang.Integer"/>
<property name="tshC20" type="java.lang.Integer"/>
<property name="tshC21" type="java.lang.Integer"/>
<property name="tshC22" type="java.lang.Integer"/>
<property name="tshC23" type="java.lang.Integer"/>
<property name="tthB0" type="java.lang.Integer"/>
<property name="tthB1" type="java.lang.Integer"/>
<property name="tthB2" type="java.lang.Integer"/>
<property name="tthB3" type="java.lang.Integer"/>
<property name="tthB4" type="java.lang.Integer"/>
<property name="tthB5" type="java.lang.Integer"/>
<property name="tthB6" type="java.lang.Integer"/>
<property name="tthB7" type="java.lang.Integer"/>
<property name="tthB8" type="java.lang.Integer"/>
<property name="tthB9" type="java.lang.Integer"/>
<property name="tthB10" type="java.lang.Integer"/>
<property name="tthB11" type="java.lang.Integer"/>
<property name="tthB12" type="java.lang.Integer"/>
<property name="tthB13" type="java.lang.Integer"/>
<property name="tthB14" type="java.lang.Integer"/>
<property name="tthB15" type="java.lang.Integer"/>
<property name="tthB16" type="java.lang.Integer"/>
<property name="tthB17" type="java.lang.Integer"/>
<property name="tthB18" type="java.lang.Integer"/>
<property name="tthB19" type="java.lang.Integer"/>
<property name="tthB20" type="java.lang.Integer"/>
<property name="tthB21" type="java.lang.Integer"/>
<property name="tthB22" type="java.lang.Integer"/>
<property name="tthB23" type="java.lang.Integer"/>
<property name="tthB24" type="java.lang.Integer"/>
<property name="tthC0" type="java.lang.Integer"/>
<property name="tthC1" type="java.lang.Integer"/>
<property name="tthC2" type="java.lang.Integer"/>
<property name="tthC3" type="java.lang.Integer"/>
<property name="tthC4" type="java.lang.Integer"/>
<property name="tthC5" type="java.lang.Integer"/>
<property name="tthC6" type="java.lang.Integer"/>
<property name="tthC7" type="java.lang.Integer"/>
<property name="tthC8" type="java.lang.Integer"/>
<property name="tthC9" type="java.lang.Integer"/>
<property name="tthC10" type="java.lang.Integer"/>
<property name="tthC11" type="java.lang.Integer"/>
<property name="tthC12" type="java.lang.Integer"/>
<property name="tthC13" type="java.lang.Integer"/>
<property name="tthC14" type="java.lang.Integer"/>
<property name="tthC15" type="java.lang.Integer"/>
<property name="tthC16" type="java.lang.Integer"/>
<property name="tthC17" type="java.lang.Integer"/>
<property name="tthC18" type="java.lang.Integer"/>
<property name="tthC19" type="java.lang.Integer"/>
<property name="tthC20" type="java.lang.Integer"/>
<property name="tthC21" type="java.lang.Integer"/>
<property name="tthC22" type="java.lang.Integer"/>
<property name="tthC23" type="java.lang.Integer"/>
</class>
</hibernate-mapping>
Code:
protected void computeMedians(Session session, SQLQuery minMaxQuery, SQLQuery dataQuery)
{
int histogramWidth = 9601;
ArrayList<Long> dbIds = new ArrayList<Long>();
HashMap<Long, int[]> tphBuckets = new HashMap<Long, int[]>();
HashMap<Long, int[]> tshBuckets = new HashMap<Long, int[]>();
HashMap<Long, int[]> tthBuckets = new HashMap<Long, int[]>();
HashMap<Long, double[]> tphCounts = new HashMap<Long, double[]>();
HashMap<Long, double[]> tshCounts = new HashMap<Long, double[]>();
HashMap<Long, double[]> tthCounts = new HashMap<Long, double[]>();
// get the min/max buckets
ArrayList<HistogramMinMax> minMaxs =
(ArrayList<HistogramMinMax>) minMaxQuery
.addEntity("hgm", com.timestock.tess.objects.HistogramMinMax.class)
.list();
// do some processing here (code removed for brevity)
// get the histogram data
ArrayList<HistogramData> rows =
(ArrayList<HistogramData>) dataQuery
.addEntity("hgm", com.timestock.tess.objects.HistogramData.class)
.list();
// do some more processing here (code removed for brevity)
session.evict(HistogramData.class);
session.evict(HistogramMinMax.class);
session.getSessionFactory().evict(HistogramData.class);
session.getSessionFactory().evict(HistogramMinMax.class);
}
Full stack trace of any exception that occurs:
Name and version of the database you are using:
MS SQL 2000
The generated SQL (show_sql=true):
see below
Debug level Hibernate log excerpt:
2005-06-09 13:02:40,937 DEBUG [org.hibernate.impl.SessionImpl] - <SQL query:
SELECT s.ts_transet_group_id AS id0_,
MIN(s.ts_tph_b0) AS throughp6_1_0_,
MAX(s.ts_tph_max) AS throughp7_1_0_,
null AS sizeMinB2_1_0_,
null AS sizeMaxB3_1_0_,
null AS timeMinB4_1_0_,
null AS timeMaxB5_1_0_
FROM ts_stats_transetgroup_all_monthly s
WHERE ts_interval_start_time >= ? AND ts_interval_start_time <= ?
AND (0 = ? OR s.ts_transet_group_id = ?)
AND 0 = ? AND 0 = ? AND 0 = ?
GROUP BY s.ts_transet_group_id ORDER BY s.ts_transet_group_id
>
2005-06-09 13:02:40,937 DEBUG [org.hibernate.jdbc.AbstractBatcher] - <about to open PreparedStatement (open PreparedStatements: 0, globally: 0)>
2005-06-09 13:02:40,937 DEBUG [org.hibernate.SQL] - <
SELECT s.ts_transet_group_id AS id0_,
MIN(s.ts_tph_b0) AS throughp6_1_0_,
MAX(s.ts_tph_max) AS throughp7_1_0_,
null AS sizeMinB2_1_0_,
null AS sizeMaxB3_1_0_,
null AS timeMinB4_1_0_,
null AS timeMaxB5_1_0_
FROM ts_stats_transetgroup_all_monthly s
WHERE ts_interval_start_time >= ? AND ts_interval_start_time <= ?
AND (0 = ? OR s.ts_transet_group_id = ?)
AND 0 = ? AND 0 = ? AND 0 = ?
GROUP BY s.ts_transet_group_id ORDER BY s.ts_transet_group_id
>
2005-06-09 13:02:40,937 DEBUG [org.hibernate.jdbc.AbstractBatcher] - <preparing statement>
2005-06-09 13:02:40,937 DEBUG [org.hibernate.type.LongType] - <binding '0' to parameter: 5>
2005-06-09 13:02:40,953 DEBUG [org.hibernate.type.LongType] - <binding '0' to parameter: 3>
2005-06-09 13:02:40,953 DEBUG [org.hibernate.type.LongType] - <binding '0' to parameter: 4>
2005-06-09 13:02:40,953 DEBUG [org.hibernate.type.LongType] - <binding '0' to parameter: 6>
2005-06-09 13:02:40,953 DEBUG [org.hibernate.type.LongType] - <binding '0' to parameter: 7>
2005-06-09 13:02:40,953 DEBUG [org.hibernate.type.TimestampType] - <binding '2005-01-01 00:00:00' to parameter: 1>
2005-06-09 13:02:40,953 DEBUG [org.hibernate.type.TimestampType] - <binding '2005-12-31 23:59:59' to parameter: 2>
2005-06-09 13:02:40,968 DEBUG [org.hibernate.jdbc.AbstractBatcher] - <about to open ResultSet (open ResultSets: 0, globally: 0)>
2005-06-09 13:02:40,968 DEBUG [org.hibernate.loader.Loader] - <processing result set>
2005-06-09 13:02:40,968 DEBUG [org.hibernate.loader.Loader] - <result set row: 0>
2005-06-09 13:02:40,968 DEBUG [org.hibernate.type.LongType] - <returning '632470205094843755' as column: id0_>
2005-06-09 13:02:40,968 DEBUG [org.hibernate.loader.Loader] - <result row: EntityKey[com.timestock.tess.objects.HistogramMinMax#632470205094843755]>
2005-06-09 13:02:40,968 DEBUG [org.hibernate.loader.Loader] - <Initializing object from ResultSet: [com.timestock.tess.objects.HistogramMinMax#632470205094843755]>
2005-06-09 13:02:40,968 DEBUG [org.hibernate.persister.entity.BasicEntityPersister] - <Hydrating entity: [com.timestock.tess.objects.HistogramMinMax#632470205094843755]>
2005-06-09 13:02:40,968 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: sizeMinB2_1_0_>
2005-06-09 13:02:40,968 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: sizeMaxB3_1_0_>
2005-06-09 13:02:40,968 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: timeMinB4_1_0_>
2005-06-09 13:02:40,968 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: timeMaxB5_1_0_>
2005-06-09 13:02:40,968 DEBUG [org.hibernate.type.IntegerType] - <returning '2529' as column: throughp6_1_0_>
2005-06-09 13:02:40,968 DEBUG [org.hibernate.type.IntegerType] - <returning '135000' as column: throughp7_1_0_>
2005-06-09 13:02:40,968 DEBUG [org.hibernate.loader.Loader] - <done processing result set (1 rows)>
2005-06-09 13:02:40,984 DEBUG [org.hibernate.jdbc.AbstractBatcher] - <about to close ResultSet (open ResultSets: 1, globally: 1)>
2005-06-09 13:02:40,984 DEBUG [org.hibernate.jdbc.AbstractBatcher] - <about to close PreparedStatement (open PreparedStatements: 1, globally: 1)>
2005-06-09 13:02:40,984 DEBUG [org.hibernate.jdbc.AbstractBatcher] - <closing statement>
2005-06-09 13:02:40,984 DEBUG [org.hibernate.loader.Loader] - <total objects hydrated: 1>
2005-06-09 13:02:40,984 DEBUG [org.hibernate.engine.TwoPhaseLoad] - <resolving associations for [com.timestock.tess.objects.HistogramMinMax#632470205094843755]>
2005-06-09 13:02:40,984 DEBUG [org.hibernate.engine.TwoPhaseLoad] - <done materializing entity [com.timestock.tess.objects.HistogramMinMax#632470205094843755]>
2005-06-09 13:02:40,984 DEBUG [org.hibernate.engine.PersistenceContext] - <initializing non-lazy collections>
2005-06-09 13:02:40,984 DEBUG [org.hibernate.impl.SessionImpl] - <SQL query:
SELECT s.ts_transet_group_id AS id0_,
s.ts_tph_b0 AS tphB2_0_0_,
s.ts_tph_b1 AS tphB3_0_0_,
s.ts_tph_b2 AS tphB4_0_0_,
s.ts_tph_b3 AS tphB5_0_0_,
s.ts_tph_b4 AS tphB6_0_0_,
s.ts_tph_b5 AS tphB7_0_0_,
s.ts_tph_b6 AS tphB8_0_0_,
s.ts_tph_b7 AS tphB9_0_0_,
s.ts_tph_b8 AS tphB10_0_0_,
s.ts_tph_b9 AS tphB11_0_0_,
s.ts_tph_b10 AS tphB12_0_0_,
s.ts_tph_b11 AS tphB13_0_0_,
s.ts_tph_b12 AS tphB14_0_0_,
s.ts_tph_b13 AS tphB15_0_0_,
s.ts_tph_b14 AS tphB16_0_0_,
s.ts_tph_b15 AS tphB17_0_0_,
s.ts_tph_b16 AS tphB18_0_0_,
s.ts_tph_b17 AS tphB19_0_0_,
s.ts_tph_b18 AS tphB20_0_0_,
s.ts_tph_b19 AS tphB21_0_0_,
s.ts_tph_b20 AS tphB22_0_0_,
s.ts_tph_b21 AS tphB23_0_0_,
s.ts_tph_b22 AS tphB24_0_0_,
s.ts_tph_b23 AS tphB25_0_0_,
s.ts_tph_max AS tphB26_0_0_,
s.ts_tph_c0 AS tphC27_0_0_,
s.ts_tph_c1 AS tphC28_0_0_,
s.ts_tph_c2 AS tphC29_0_0_,
s.ts_tph_c3 AS tphC30_0_0_,
s.ts_tph_c4 AS tphC31_0_0_,
s.ts_tph_c5 AS tphC32_0_0_,
s.ts_tph_c6 AS tphC33_0_0_,
s.ts_tph_c7 AS tphC34_0_0_,
s.ts_tph_c8 AS tphC35_0_0_,
s.ts_tph_c9 AS tphC36_0_0_,
s.ts_tph_c10 AS tphC37_0_0_,
s.ts_tph_c11 AS tphC38_0_0_,
s.ts_tph_c12 AS tphC39_0_0_,
s.ts_tph_c13 AS tphC40_0_0_,
s.ts_tph_c14 AS tphC41_0_0_,
s.ts_tph_c15 AS tphC42_0_0_,
s.ts_tph_c16 AS tphC43_0_0_,
s.ts_tph_c17 AS tphC44_0_0_,
s.ts_tph_c18 AS tphC45_0_0_,
s.ts_tph_c19 AS tphC46_0_0_,
s.ts_tph_c20 AS tphC47_0_0_,
s.ts_tph_c21 AS tphC48_0_0_,
s.ts_tph_c22 AS tphC49_0_0_,
s.ts_tph_c23 AS tphC50_0_0_,
null AS tshB51_0_0_,
null AS tshB52_0_0_,
null AS tshB53_0_0_,
null AS tshB54_0_0_,
null AS tshB55_0_0_,
null AS tshB56_0_0_,
null AS tshB57_0_0_,
null AS tshB58_0_0_,
null AS tshB59_0_0_,
null AS tshB60_0_0_,
null AS tshB61_0_0_,
null AS tshB62_0_0_,
null AS tshB63_0_0_,
null AS tshB64_0_0_,
null AS tshB65_0_0_,
null AS tshB66_0_0_,
null AS tshB67_0_0_,
null AS tshB68_0_0_,
null AS tshB69_0_0_,
null AS tshB70_0_0_,
null AS tshB71_0_0_,
null AS tshB72_0_0_,
null AS tshB73_0_0_,
null AS tshB74_0_0_,
null AS tshB75_0_0_,
null AS tshC76_0_0_,
null AS tshC77_0_0_,
null AS tshC78_0_0_,
null AS tshC79_0_0_,
null AS tshC80_0_0_,
null AS tshC81_0_0_,
null AS tshC82_0_0_,
null AS tshC83_0_0_,
null AS tshC84_0_0_,
null AS tshC85_0_0_,
null AS tshC86_0_0_,
null AS tshC87_0_0_,
null AS tshC88_0_0_,
null AS tshC89_0_0_,
null AS tshC90_0_0_,
null AS tshC91_0_0_,
null AS tshC92_0_0_,
null AS tshC93_0_0_,
null AS tshC94_0_0_,
null AS tshC95_0_0_,
null AS tshC96_0_0_,
null AS tshC97_0_0_,
null AS tshC98_0_0_,
null AS tshC99_0_0_,
null AS tthB100_0_0_,
null AS tthB101_0_0_,
null AS tthB102_0_0_,
null AS tthB103_0_0_,
null AS tthB104_0_0_,
null AS tthB105_0_0_,
null AS tthB106_0_0_,
null AS tthB107_0_0_,
null AS tthB108_0_0_,
null AS tthB109_0_0_,
null AS tthB110_0_0_,
null AS tthB111_0_0_,
null AS tthB112_0_0_,
null AS tthB113_0_0_,
null AS tthB114_0_0_,
null AS tthB115_0_0_,
null AS tthB116_0_0_,
null AS tthB117_0_0_,
null AS tthB118_0_0_,
null AS tthB119_0_0_,
null AS tthB120_0_0_,
null AS tthB121_0_0_,
null AS tthB122_0_0_,
null AS tthB123_0_0_,
null AS tthB124_0_0_,
null AS tthC125_0_0_,
null AS tthC126_0_0_,
null AS tthC127_0_0_,
null AS tthC128_0_0_,
null AS tthC129_0_0_,
null AS tthC130_0_0_,
null AS tthC131_0_0_,
null AS tthC132_0_0_,
null AS tthC133_0_0_,
null AS tthC134_0_0_,
null AS tthC135_0_0_,
null AS tthC136_0_0_,
null AS tthC137_0_0_,
null AS tthC138_0_0_,
null AS tthC139_0_0_,
null AS tthC140_0_0_,
null AS tthC141_0_0_,
null AS tthC142_0_0_,
null AS tthC143_0_0_,
null AS tthC144_0_0_,
null AS tthC145_0_0_,
null AS tthC146_0_0_,
null AS tthC147_0_0_,
null AS tthC148_0_0_
FROM ts_stats_transetgroup_all_monthly s
WHERE ts_interval_start_time >= ? AND ts_interval_start_time <= ?
AND (0 = ? OR s.ts_transet_group_id = ?)
AND 0 = ? AND 0 = ? AND 0 = ?
>
2005-06-09 13:02:40,984 DEBUG [org.hibernate.jdbc.AbstractBatcher] - <about to open PreparedStatement (open PreparedStatements: 0, globally: 0)>
2005-06-09 13:02:40,984 DEBUG [org.hibernate.SQL] - <
SELECT s.ts_transet_group_id AS id0_,
s.ts_tph_b0 AS tphB2_0_0_,
s.ts_tph_b1 AS tphB3_0_0_,
s.ts_tph_b2 AS tphB4_0_0_,
s.ts_tph_b3 AS tphB5_0_0_,
s.ts_tph_b4 AS tphB6_0_0_,
s.ts_tph_b5 AS tphB7_0_0_,
s.ts_tph_b6 AS tphB8_0_0_,
s.ts_tph_b7 AS tphB9_0_0_,
s.ts_tph_b8 AS tphB10_0_0_,
s.ts_tph_b9 AS tphB11_0_0_,
s.ts_tph_b10 AS tphB12_0_0_,
s.ts_tph_b11 AS tphB13_0_0_,
s.ts_tph_b12 AS tphB14_0_0_,
s.ts_tph_b13 AS tphB15_0_0_,
s.ts_tph_b14 AS tphB16_0_0_,
s.ts_tph_b15 AS tphB17_0_0_,
s.ts_tph_b16 AS tphB18_0_0_,
s.ts_tph_b17 AS tphB19_0_0_,
s.ts_tph_b18 AS tphB20_0_0_,
s.ts_tph_b19 AS tphB21_0_0_,
s.ts_tph_b20 AS tphB22_0_0_,
s.ts_tph_b21 AS tphB23_0_0_,
s.ts_tph_b22 AS tphB24_0_0_,
s.ts_tph_b23 AS tphB25_0_0_,
s.ts_tph_max AS tphB26_0_0_,
s.ts_tph_c0 AS tphC27_0_0_,
s.ts_tph_c1 AS tphC28_0_0_,
s.ts_tph_c2 AS tphC29_0_0_,
s.ts_tph_c3 AS tphC30_0_0_,
s.ts_tph_c4 AS tphC31_0_0_,
s.ts_tph_c5 AS tphC32_0_0_,
s.ts_tph_c6 AS tphC33_0_0_,
s.ts_tph_c7 AS tphC34_0_0_,
s.ts_tph_c8 AS tphC35_0_0_,
s.ts_tph_c9 AS tphC36_0_0_,
s.ts_tph_c10 AS tphC37_0_0_,
s.ts_tph_c11 AS tphC38_0_0_,
s.ts_tph_c12 AS tphC39_0_0_,
s.ts_tph_c13 AS tphC40_0_0_,
s.ts_tph_c14 AS tphC41_0_0_,
s.ts_tph_c15 AS tphC42_0_0_,
s.ts_tph_c16 AS tphC43_0_0_,
s.ts_tph_c17 AS tphC44_0_0_,
s.ts_tph_c18 AS tphC45_0_0_,
s.ts_tph_c19 AS tphC46_0_0_,
s.ts_tph_c20 AS tphC47_0_0_,
s.ts_tph_c21 AS tphC48_0_0_,
s.ts_tph_c22 AS tphC49_0_0_,
s.ts_tph_c23 AS tphC50_0_0_,
null AS tshB51_0_0_,
null AS tshB52_0_0_,
null AS tshB53_0_0_,
null AS tshB54_0_0_,
null AS tshB55_0_0_,
null AS tshB56_0_0_,
null AS tshB57_0_0_,
null AS tshB58_0_0_,
null AS tshB59_0_0_,
null AS tshB60_0_0_,
null AS tshB61_0_0_,
null AS tshB62_0_0_,
null AS tshB63_0_0_,
null AS tshB64_0_0_,
null AS tshB65_0_0_,
null AS tshB66_0_0_,
null AS tshB67_0_0_,
null AS tshB68_0_0_,
null AS tshB69_0_0_,
null AS tshB70_0_0_,
null AS tshB71_0_0_,
null AS tshB72_0_0_,
null AS tshB73_0_0_,
null AS tshB74_0_0_,
null AS tshB75_0_0_,
null AS tshC76_0_0_,
null AS tshC77_0_0_,
null AS tshC78_0_0_,
null AS tshC79_0_0_,
null AS tshC80_0_0_,
null AS tshC81_0_0_,
null AS tshC82_0_0_,
null AS tshC83_0_0_,
null AS tshC84_0_0_,
null AS tshC85_0_0_,
null AS tshC86_0_0_,
null AS tshC87_0_0_,
null AS tshC88_0_0_,
null AS tshC89_0_0_,
null AS tshC90_0_0_,
null AS tshC91_0_0_,
null AS tshC92_0_0_,
null AS tshC93_0_0_,
null AS tshC94_0_0_,
null AS tshC95_0_0_,
null AS tshC96_0_0_,
null AS tshC97_0_0_,
null AS tshC98_0_0_,
null AS tshC99_0_0_,
null AS tthB100_0_0_,
null AS tthB101_0_0_,
null AS tthB102_0_0_,
null AS tthB103_0_0_,
null AS tthB104_0_0_,
null AS tthB105_0_0_,
null AS tthB106_0_0_,
null AS tthB107_0_0_,
null AS tthB108_0_0_,
null AS tthB109_0_0_,
null AS tthB110_0_0_,
null AS tthB111_0_0_,
null AS tthB112_0_0_,
null AS tthB113_0_0_,
null AS tthB114_0_0_,
null AS tthB115_0_0_,
null AS tthB116_0_0_,
null AS tthB117_0_0_,
null AS tthB118_0_0_,
null AS tthB119_0_0_,
null AS tthB120_0_0_,
null AS tthB121_0_0_,
null AS tthB122_0_0_,
null AS tthB123_0_0_,
null AS tthB124_0_0_,
null AS tthC125_0_0_,
null AS tthC126_0_0_,
null AS tthC127_0_0_,
null AS tthC128_0_0_,
null AS tthC129_0_0_,
null AS tthC130_0_0_,
null AS tthC131_0_0_,
null AS tthC132_0_0_,
null AS tthC133_0_0_,
null AS tthC134_0_0_,
null AS tthC135_0_0_,
null AS tthC136_0_0_,
null AS tthC137_0_0_,
null AS tthC138_0_0_,
null AS tthC139_0_0_,
null AS tthC140_0_0_,
null AS tthC141_0_0_,
null AS tthC142_0_0_,
null AS tthC143_0_0_,
null AS tthC144_0_0_,
null AS tthC145_0_0_,
null AS tthC146_0_0_,
null AS tthC147_0_0_,
null AS tthC148_0_0_
FROM ts_stats_transetgroup_all_monthly s
WHERE ts_interval_start_time >= ? AND ts_interval_start_time <= ?
AND (0 = ? OR s.ts_transet_group_id = ?)
AND 0 = ? AND 0 = ? AND 0 = ?
>
2005-06-09 13:02:40,984 DEBUG [org.hibernate.jdbc.AbstractBatcher] - <preparing statement>
2005-06-09 13:02:40,984 DEBUG [org.hibernate.type.LongType] - <binding '0' to parameter: 5>
2005-06-09 13:02:40,984 DEBUG [org.hibernate.type.LongType] - <binding '0' to parameter: 3>
2005-06-09 13:02:40,984 DEBUG [org.hibernate.type.LongType] - <binding '0' to parameter: 4>
2005-06-09 13:02:40,984 DEBUG [org.hibernate.type.LongType] - <binding '0' to parameter: 6>
2005-06-09 13:02:41,000 DEBUG [org.hibernate.type.LongType] - <binding '0' to parameter: 7>
2005-06-09 13:02:41,000 DEBUG [org.hibernate.type.TimestampType] - <binding '2005-01-01 00:00:00' to parameter: 1>
2005-06-09 13:02:41,000 DEBUG [org.hibernate.type.TimestampType] - <binding '2005-12-31 23:59:59' to parameter: 2>
2005-06-09 13:02:41,015 DEBUG [org.hibernate.jdbc.AbstractBatcher] - <about to open ResultSet (open ResultSets: 0, globally: 0)>
2005-06-09 13:02:41,015 DEBUG [org.hibernate.loader.Loader] - <processing result set>
2005-06-09 13:02:41,015 DEBUG [org.hibernate.loader.Loader] - <result set row: 0>
2005-06-09 13:02:41,015 DEBUG [org.hibernate.type.LongType] - <returning '632470205094843755' as column: id0_>
2005-06-09 13:02:41,015 DEBUG [org.hibernate.loader.Loader] - <result row: EntityKey[com.timestock.tess.objects.HistogramData#632470205094843755]>
2005-06-09 13:02:41,015 DEBUG [org.hibernate.loader.Loader] - <Initializing object from ResultSet: [com.timestock.tess.objects.HistogramData#632470205094843755]>
2005-06-09 13:02:41,015 DEBUG [org.hibernate.persister.entity.BasicEntityPersister] - <Hydrating entity: [com.timestock.tess.objects.HistogramData#632470205094843755]>
2005-06-09 13:02:41,015 DEBUG [org.hibernate.type.IntegerType] - <returning '2532' as column: tphB2_0_0_>
2005-06-09 13:02:41,015 DEBUG [org.hibernate.type.IntegerType] - <returning '16471' as column: tphB3_0_0_>
2005-06-09 13:02:41,015 DEBUG [org.hibernate.type.IntegerType] - <returning '28942' as column: tphB4_0_0_>
2005-06-09 13:02:41,015 DEBUG [org.hibernate.type.IntegerType] - <returning '34931' as column: tphB5_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '38226' as column: tphB6_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '41378' as column: tphB7_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '46421' as column: tphB8_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '52193' as column: tphB9_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '57000' as column: tphB10_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '61226' as column: tphB11_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '64647' as column: tphB12_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '66521' as column: tphB13_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '68537' as column: tphB14_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '71400' as column: tphB15_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '75262' as column: tphB16_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '89800' as column: tphB17_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '101931' as column: tphB18_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '114647' as column: tphB19_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '120908' as column: tphB20_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '124368' as column: tphB21_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '126477' as column: tphB22_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '127954' as column: tphB23_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '130088' as column: tphB24_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '131868' as column: tphB25_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '134176' as column: tphB26_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '25' as column: tphC27_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '32' as column: tphC28_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '27' as column: tphC29_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '18' as column: tphC30_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '22' as column: tphC31_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '24' as column: tphC32_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '27' as column: tphC33_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '23' as column: tphC34_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '29' as column: tphC35_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '31' as column: tphC36_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '19' as column: tphC37_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '21' as column: tphC38_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '27' as column: tphC39_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '30' as column: tphC40_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '25' as column: tphC41_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '20' as column: tphC42_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '30' as column: tphC43_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '28' as column: tphC44_0_0_>
2005-06-09 13:02:41,031 DEBUG [org.hibernate.type.IntegerType] - <returning '29' as column: tphC45_0_0_>
2005-06-09 13:02:41,046 DEBUG [org.hibernate.type.IntegerType] - <returning '25' as column: tphC46_0_0_>
2005-06-09 13:02:41,046 DEBUG [org.hibernate.type.IntegerType] - <returning '17' as column: tphC47_0_0_>
2005-06-09 13:02:41,046 DEBUG [org.hibernate.type.IntegerType] - <returning '31' as column: tphC48_0_0_>
2005-06-09 13:02:41,046 DEBUG [org.hibernate.type.IntegerType] - <returning '24' as column: tphC49_0_0_>
2005-06-09 13:02:41,046 DEBUG [org.hibernate.type.IntegerType] - <returning '26' as column: tphC50_0_0_>
2005-06-09 13:02:41,046 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshB51_0_0_>
2005-06-09 13:02:41,046 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshB52_0_0_>
2005-06-09 13:02:41,062 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshB53_0_0_>
2005-06-09 13:02:41,062 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshB54_0_0_>
2005-06-09 13:02:41,062 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshB55_0_0_>
2005-06-09 13:02:41,062 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshB56_0_0_>
2005-06-09 13:02:41,062 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshB57_0_0_>
2005-06-09 13:02:41,062 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshB58_0_0_>
2005-06-09 13:02:41,062 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshB59_0_0_>
2005-06-09 13:02:41,062 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshB60_0_0_>
2005-06-09 13:02:41,062 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshB61_0_0_>
2005-06-09 13:02:41,062 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshB62_0_0_>
2005-06-09 13:02:41,062 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshB63_0_0_>
2005-06-09 13:02:41,062 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshB64_0_0_>
2005-06-09 13:02:41,062 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshB65_0_0_>
2005-06-09 13:02:41,062 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshB66_0_0_>
2005-06-09 13:02:41,078 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshB67_0_0_>
2005-06-09 13:02:41,078 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshB68_0_0_>
2005-06-09 13:02:41,078 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshB69_0_0_>
2005-06-09 13:02:41,078 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshB70_0_0_>
2005-06-09 13:02:41,078 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshB71_0_0_>
2005-06-09 13:02:41,078 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshB72_0_0_>
2005-06-09 13:02:41,078 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshB73_0_0_>
2005-06-09 13:02:41,078 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshB74_0_0_>
2005-06-09 13:02:41,078 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshB75_0_0_>
2005-06-09 13:02:41,078 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshC76_0_0_>
2005-06-09 13:02:41,078 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshC77_0_0_>
2005-06-09 13:02:41,078 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshC78_0_0_>
2005-06-09 13:02:41,078 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshC79_0_0_>
2005-06-09 13:02:41,078 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshC80_0_0_>
2005-06-09 13:02:41,093 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshC81_0_0_>
2005-06-09 13:02:41,093 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshC82_0_0_>
2005-06-09 13:02:41,093 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshC83_0_0_>
2005-06-09 13:02:41,093 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshC84_0_0_>
2005-06-09 13:02:41,093 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshC85_0_0_>
2005-06-09 13:02:41,093 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshC86_0_0_>
2005-06-09 13:02:41,093 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshC87_0_0_>
2005-06-09 13:02:41,093 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshC88_0_0_>
2005-06-09 13:02:41,093 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshC89_0_0_>
2005-06-09 13:02:41,093 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshC90_0_0_>
2005-06-09 13:02:41,093 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshC91_0_0_>
2005-06-09 13:02:41,093 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshC92_0_0_>
2005-06-09 13:02:41,093 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshC93_0_0_>
2005-06-09 13:02:41,093 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshC94_0_0_>
2005-06-09 13:02:41,109 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshC95_0_0_>
2005-06-09 13:02:41,109 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshC96_0_0_>
2005-06-09 13:02:41,109 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshC97_0_0_>
2005-06-09 13:02:41,109 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshC98_0_0_>
2005-06-09 13:02:41,109 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tshC99_0_0_>
2005-06-09 13:02:41,109 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthB100_0_0_>
2005-06-09 13:02:41,109 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthB101_0_0_>
2005-06-09 13:02:41,109 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthB102_0_0_>
2005-06-09 13:02:41,109 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthB103_0_0_>
2005-06-09 13:02:41,109 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthB104_0_0_>
2005-06-09 13:02:41,109 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthB105_0_0_>
2005-06-09 13:02:41,109 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthB106_0_0_>
2005-06-09 13:02:41,109 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthB107_0_0_>
2005-06-09 13:02:41,109 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthB108_0_0_>
2005-06-09 13:02:41,125 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthB109_0_0_>
2005-06-09 13:02:41,125 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthB110_0_0_>
2005-06-09 13:02:41,125 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthB111_0_0_>
2005-06-09 13:02:41,125 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthB112_0_0_>
2005-06-09 13:02:41,125 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthB113_0_0_>
2005-06-09 13:02:41,125 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthB114_0_0_>
2005-06-09 13:02:41,125 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthB115_0_0_>
2005-06-09 13:02:41,125 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthB116_0_0_>
2005-06-09 13:02:41,125 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthB117_0_0_>
2005-06-09 13:02:41,125 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthB118_0_0_>
2005-06-09 13:02:41,125 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthB119_0_0_>
2005-06-09 13:02:41,125 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthB120_0_0_>
2005-06-09 13:02:41,125 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthB121_0_0_>
2005-06-09 13:02:41,125 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthB122_0_0_>
2005-06-09 13:02:41,140 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthB123_0_0_>
2005-06-09 13:02:41,140 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthB124_0_0_>
2005-06-09 13:02:41,140 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthC125_0_0_>
2005-06-09 13:02:41,140 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthC126_0_0_>
2005-06-09 13:02:41,140 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthC127_0_0_>
2005-06-09 13:02:41,140 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthC128_0_0_>
2005-06-09 13:02:41,140 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthC129_0_0_>
2005-06-09 13:02:41,140 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthC130_0_0_>
2005-06-09 13:02:41,140 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthC131_0_0_>
2005-06-09 13:02:41,140 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthC132_0_0_>
2005-06-09 13:02:41,140 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthC133_0_0_>
2005-06-09 13:02:41,140 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthC134_0_0_>
2005-06-09 13:02:41,140 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthC135_0_0_>
2005-06-09 13:02:41,140 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthC136_0_0_>
2005-06-09 13:02:41,156 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthC137_0_0_>
2005-06-09 13:02:41,156 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthC138_0_0_>
2005-06-09 13:02:41,156 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthC139_0_0_>
2005-06-09 13:02:41,156 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthC140_0_0_>
2005-06-09 13:02:41,156 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthC141_0_0_>
2005-06-09 13:02:41,156 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthC142_0_0_>
2005-06-09 13:02:41,156 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthC143_0_0_>
2005-06-09 13:02:41,156 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthC144_0_0_>
2005-06-09 13:02:41,156 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthC145_0_0_>
2005-06-09 13:02:41,156 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthC146_0_0_>
2005-06-09 13:02:41,156 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthC147_0_0_>
2005-06-09 13:02:41,156 DEBUG [org.hibernate.type.IntegerType] - <returning null as column: tthC148_0_0_>
2005-06-09 13:02:41,156 DEBUG [org.hibernate.loader.Loader] - <result set row: 1>
2005-06-09 13:02:41,156 DEBUG [org.hibernate.type.LongType] - <returning '632470205094843755' as column: id0_>
2005-06-09 13:02:41,156 DEBUG [org.hibernate.loader.Loader] - <result row: EntityKey[com.timestock.tess.objects.HistogramData#632470205094843755]>
2005-06-09 13:02:41,187 DEBUG [org.hibernate.loader.Loader] - <result set row: 2>
2005-06-09 13:02:41,187 DEBUG [org.hibernate.type.LongType] - <returning '632470205094843755' as column: id0_>
2005-06-09 13:02:41,187 DEBUG [org.hibernate.loader.Loader] - <result row: EntityKey[com.timestock.tess.objects.HistogramData#632470205094843755]>
2005-06-09 13:02:41,187 DEBUG [org.hibernate.loader.Loader] - <result set row: 3>
2005-06-09 13:02:41,187 DEBUG [org.hibernate.type.LongType] - <returning '632470205094843755' as column: id0_>
2005-06-09 13:02:41,187 DEBUG [org.hibernate.loader.Loader] - <result row: EntityKey[com.timestock.tess.objects.HistogramData#632470205094843755]>
2005-06-09 13:02:41,187 DEBUG [org.hibernate.loader.Loader] - <result set row: 4>
2005-06-09 13:02:41,187 DEBUG [org.hibernate.type.LongType] - <returning '632470205094843755' as column: id0_>
2005-06-09 13:02:41,187 DEBUG [org.hibernate.loader.Loader] - <result row: EntityKey[com.timestock.tess.objects.HistogramData#632470205094843755]>
2005-06-09 13:02:41,187 DEBUG [org.hibernate.loader.Loader] - <result set row: 5>
2005-06-09 13:02:41,187 DEBUG [org.hibernate.type.LongType] - <returning '632470205094843755' as column: id0_>
2005-06-09 13:02:41,187 DEBUG [org.hibernate.loader.Loader] - <result row: EntityKey[com.timestock.tess.objects.HistogramData#632470205094843755]>
2005-06-09 13:02:41,187 DEBUG [org.hibernate.loader.Loader] - <result set row: 6>
2005-06-09 13:02:41,187 DEBUG [org.hibernate.type.LongType] - <returning '632470205094843755' as column: id0_>
2005-06-09 13:02:41,203 DEBUG [org.hibernate.loader.Loader] - <result row: EntityKey[com.timestock.tess.objects.HistogramData#632470205094843755]>
2005-06-09 13:02:41,203 DEBUG [org.hibernate.loader.Loader] - <result set row: 7>
2005-06-09 13:02:41,203 DEBUG [org.hibernate.type.LongType] - <returning '632470205094843755' as column: id0_>
2005-06-09 13:02:41,203 DEBUG [org.hibernate.loader.Loader] - <result row: EntityKey[com.timestock.tess.objects.HistogramData#632470205094843755]>
2005-06-09 13:02:41,203 DEBUG [org.hibernate.loader.Loader] - <done processing result set (8 rows)>
2005-06-09 13:02:41,203 DEBUG [org.hibernate.jdbc.AbstractBatcher] - <about to close ResultSet (open ResultSets: 1, globally: 1)>
2005-06-09 13:02:41,203 DEBUG [org.hibernate.jdbc.AbstractBatcher] - <about to close PreparedStatement (open PreparedStatements: 1, globally: 1)>
2005-06-09 13:02:41,203 DEBUG [org.hibernate.jdbc.AbstractBatcher] - <closing statement>
2005-06-09 13:02:41,203 DEBUG [org.hibernate.loader.Loader] - <total objects hydrated: 1>
2005-06-09 13:02:41,203 DEBUG [org.hibernate.engine.TwoPhaseLoad] - <resolving associations for [com.timestock.tess.objects.HistogramData#632470205094843755]>
2005-06-09 13:02:41,203 DEBUG [org.hibernate.engine.TwoPhaseLoad] - <done materializing entity [com.timestock.tess.objects.HistogramData#632470205094843755]>
2005-06-09 13:02:41,203 DEBUG [org.hibernate.engine.PersistenceContext] - <initializing non-lazy collections>
2005-06-09 13:02:41,265 DEBUG [org.hibernate.impl.SessionImpl] - <SQL query:
SELECT s.ts_transet_group_id AS id0_,
MIN(s.ts_tph_b0) AS throughp6_1_0_,
MAX(s.ts_tph_max) AS throughp7_1_0_,
null AS sizeMinB2_1_0_,
null AS sizeMaxB3_1_0_,
null AS timeMinB4_1_0_,
null AS timeMaxB5_1_0_
FROM ts_stats_transetgroup_all_monthly s
WHERE ts_interval_start_time >= ? AND ts_interval_start_time <= ?
AND (0 = ? OR s.ts_transet_group_id = ?)
AND 0 = ? AND 0 = ? AND 0 = ?
GROUP BY s.ts_transet_group_id ORDER BY s.ts_transet_group_id
>
2005-06-09 13:02:41,265 DEBUG [org.hibernate.jdbc.AbstractBatcher] - <about to open PreparedStatement (open PreparedStatements: 0, globally: 0)>
2005-06-09 13:02:41,265 DEBUG [org.hibernate.SQL] - <
SELECT s.ts_transet_group_id AS id0_,
MIN(s.ts_tph_b0) AS throughp6_1_0_,
MAX(s.ts_tph_max) AS throughp7_1_0_,
null AS sizeMinB2_1_0_,
null AS sizeMaxB3_1_0_,
null AS timeMinB4_1_0_,
null AS timeMaxB5_1_0_
FROM ts_stats_transetgroup_all_monthly s
WHERE ts_interval_start_time >= ? AND ts_interval_start_time <= ?
AND (0 = ? OR s.ts_transet_group_id = ?)
AND 0 = ? AND 0 = ? AND 0 = ?
GROUP BY s.ts_transet_group_id ORDER BY s.ts_transet_group_id
>
2005-06-09 13:02:41,265 DEBUG [org.hibernate.jdbc.AbstractBatcher] - <preparing statement>
2005-06-09 13:02:41,265 DEBUG [org.hibernate.type.LongType] - <binding '0' to parameter: 5>
2005-06-09 13:02:41,265 DEBUG [org.hibernate.type.LongType] - <binding '0' to parameter: 3>
2005-06-09 13:02:41,265 DEBUG [org.hibernate.type.LongType] - <binding '0' to parameter: 4>
2005-06-09 13:02:41,265 DEBUG [org.hibernate.type.LongType] - <binding '0' to parameter: 6>
2005-06-09 13:02:41,265 DEBUG [org.hibernate.type.LongType] - <binding '0' to parameter: 7>
2005-06-09 13:02:41,265 DEBUG [org.hibernate.type.TimestampType] - <binding '2004-01-01 00:00:00' to parameter: 1>
2005-06-09 13:02:41,265 DEBUG [org.hibernate.type.TimestampType] - <binding '2004-12-31 23:59:59' to parameter: 2>
2005-06-09 13:02:41,265 DEBUG [org.hibernate.jdbc.AbstractBatcher] - <about to open ResultSet (open ResultSets: 0, globally: 0)>
2005-06-09 13:02:41,265 DEBUG [org.hibernate.loader.Loader] - <processing result set>
2005-06-09 13:02:41,265 DEBUG [org.hibernate.loader.Loader] - <result set row: 0>
2005-06-09 13:02:41,281 DEBUG [org.hibernate.type.LongType] - <returning '632470205094843755' as column: id0_>
2005-06-09 13:02:41,281 DEBUG [org.hibernate.loader.Loader] - <result row: EntityKey[com.timestock.tess.objects.HistogramMinMax#632470205094843755]>
2005-06-09 13:02:41,281 DEBUG [org.hibernate.loader.Loader] - <done processing result set (1 rows)>
2005-06-09 13:02:41,281 DEBUG [org.hibernate.jdbc.AbstractBatcher] - <about to close ResultSet (open ResultSets: 1, globally: 1)>
2005-06-09 13:02:41,281 DEBUG [org.hibernate.jdbc.AbstractBatcher] - <about to close PreparedStatement (open PreparedStatements: 1, globally: 1)>
2005-06-09 13:02:41,281 DEBUG [org.hibernate.jdbc.AbstractBatcher] - <closing statement>
2005-06-09 13:02:41,281 DEBUG [org.hibernate.loader.Loader] - <total objects hydrated: 0>
2005-06-09 13:02:41,296 DEBUG [org.hibernate.engine.PersistenceContext] - <initializing non-lazy collections>
2005-06-09 13:02:41,296 DEBUG [org.hibernate.impl.SessionImpl] - <SQL query:
SELECT s.ts_transet_group_id AS id0_,
s.ts_tph_b0 AS tphB2_0_0_,
s.ts_tph_b1 AS tphB3_0_0_,
s.ts_tph_b2 AS tphB4_0_0_,
s.ts_tph_b3 AS tphB5_0_0_,
s.ts_tph_b4 AS tphB6_0_0_,
s.ts_tph_b5 AS tphB7_0_0_,
s.ts_tph_b6 AS tphB8_0_0_,
s.ts_tph_b7 AS tphB9_0_0_,
s.ts_tph_b8 AS tphB10_0_0_,
s.ts_tph_b9 AS tphB11_0_0_,
s.ts_tph_b10 AS tphB12_0_0_,
s.ts_tph_b11 AS tphB13_0_0_,
s.ts_tph_b12 AS tphB14_0_0_,
s.ts_tph_b13 AS tphB15_0_0_,
s.ts_tph_b14 AS tphB16_0_0_,
s.ts_tph_b15 AS tphB17_0_0_,
s.ts_tph_b16 AS tphB18_0_0_,
s.ts_tph_b17 AS tphB19_0_0_,
s.ts_tph_b18 AS tphB20_0_0_,
s.ts_tph_b19 AS tphB21_0_0_,
s.ts_tph_b20 AS tphB22_0_0_,
s.ts_tph_b21 AS tphB23_0_0_,
s.ts_tph_b22 AS tphB24_0_0_,
s.ts_tph_b23 AS tphB25_0_0_,
s.ts_tph_max AS tphB26_0_0_,
s.ts_tph_c0 AS tphC27_0_0_,
s.ts_tph_c1 AS tphC28_0_0_,
s.ts_tph_c2 AS tphC29_0_0_,
s.ts_tph_c3 AS tphC30_0_0_,
s.ts_tph_c4 AS tphC31_0_0_,
s.ts_tph_c5 AS tphC32_0_0_,
s.ts_tph_c6 AS tphC33_0_0_,
s.ts_tph_c7 AS tphC34_0_0_,
s.ts_tph_c8 AS tphC35_0_0_,
s.ts_tph_c9 AS tphC36_0_0_,
s.ts_tph_c10 AS tphC37_0_0_,
s.ts_tph_c11 AS tphC38_0_0_,
s.ts_tph_c12 AS tphC39_0_0_,
s.ts_tph_c13 AS tphC40_0_0_,
s.ts_tph_c14 AS tphC41_0_0_,
s.ts_tph_c15 AS tphC42_0_0_,
s.ts_tph_c16 AS tphC43_0_0_,
s.ts_tph_c17 AS tphC44_0_0_,
s.ts_tph_c18 AS tphC45_0_0_,
s.ts_tph_c19 AS tphC46_0_0_,
s.ts_tph_c20 AS tphC47_0_0_,
s.ts_tph_c21 AS tphC48_0_0_,
s.ts_tph_c22 AS tphC49_0_0_,
s.ts_tph_c23 AS tphC50_0_0_,
null AS tshB51_0_0_,
null AS tshB52_0_0_,
null AS tshB53_0_0_,
null AS tshB54_0_0_,
null AS tshB55_0_0_,
null AS tshB56_0_0_,
null AS tshB57_0_0_,
null AS tshB58_0_0_,
null AS tshB59_0_0_,
null AS tshB60_0_0_,
null AS tshB61_0_0_,
null AS tshB62_0_0_,
null AS tshB63_0_0_,
null AS tshB64_0_0_,
null AS tshB65_0_0_,
null AS tshB66_0_0_,
null AS tshB67_0_0_,
null AS tshB68_0_0_,
null AS tshB69_0_0_,
null AS tshB70_0_0_,
null AS tshB71_0_0_,
null AS tshB72_0_0_,
null AS tshB73_0_0_,
null AS tshB74_0_0_,
null AS tshB75_0_0_,
null AS tshC76_0_0_,
null AS tshC77_0_0_,
null AS tshC78_0_0_,
null AS tshC79_0_0_,
null AS tshC80_0_0_,
null AS tshC81_0_0_,
null AS tshC82_0_0_,
null AS tshC83_0_0_,
null AS tshC84_0_0_,
null AS tshC85_0_0_,
null AS tshC86_0_0_,
null AS tshC87_0_0_,
null AS tshC88_0_0_,
null AS tshC89_0_0_,
null AS tshC90_0_0_,
null AS tshC91_0_0_,
null AS tshC92_0_0_,
null AS tshC93_0_0_,
null AS tshC94_0_0_,
null AS tshC95_0_0_,
null AS tshC96_0_0_,
null AS tshC97_0_0_,
null AS tshC98_0_0_,
null AS tshC99_0_0_,
null AS tthB100_0_0_,
null AS tthB101_0_0_,
null AS tthB102_0_0_,
null AS tthB103_0_0_,
null AS tthB104_0_0_,
null AS tthB105_0_0_,
null AS tthB106_0_0_,
null AS tthB107_0_0_,
null AS tthB108_0_0_,
null AS tthB109_0_0_,
null AS tthB110_0_0_,
null AS tthB111_0_0_,
null AS tthB112_0_0_,
null AS tthB113_0_0_,
null AS tthB114_0_0_,
null AS tthB115_0_0_,
null AS tthB116_0_0_,
null AS tthB117_0_0_,
null AS tthB118_0_0_,
null AS tthB119_0_0_,
null AS tthB120_0_0_,
null AS tthB121_0_0_,
null AS tthB122_0_0_,
null AS tthB123_0_0_,
null AS tthB124_0_0_,
null AS tthC125_0_0_,
null AS tthC126_0_0_,
null AS tthC127_0_0_,
null AS tthC128_0_0_,
null AS tthC129_0_0_,
null AS tthC130_0_0_,
null AS tthC131_0_0_,
null AS tthC132_0_0_,
null AS tthC133_0_0_,
null AS tthC134_0_0_,
null AS tthC135_0_0_,
null AS tthC136_0_0_,
null AS tthC137_0_0_,
null AS tthC138_0_0_,
null AS tthC139_0_0_,
null AS tthC140_0_0_,
null AS tthC141_0_0_,
null AS tthC142_0_0_,
null AS tthC143_0_0_,
null AS tthC144_0_0_,
null AS tthC145_0_0_,
null AS tthC146_0_0_,
null AS tthC147_0_0_,
null AS tthC148_0_0_
FROM ts_stats_transetgroup_all_monthly s
WHERE ts_interval_start_time >= ? AND ts_interval_start_time <= ?
AND (0 = ? OR s.ts_transet_group_id = ?)
AND 0 = ? AND 0 = ? AND 0 = ?
>
2005-06-09 13:02:41,296 DEBUG [org.hibernate.jdbc.AbstractBatcher] - <about to open PreparedStatement (open PreparedStatements: 0, globally: 0)>
2005-06-09 13:02:41,296 DEBUG [org.hibernate.SQL] - <
SELECT s.ts_transet_group_id AS id0_,
s.ts_tph_b0 AS tphB2_0_0_,
s.ts_tph_b1 AS tphB3_0_0_,
s.ts_tph_b2 AS tphB4_0_0_,
s.ts_tph_b3 AS tphB5_0_0_,
s.ts_tph_b4 AS tphB6_0_0_,
s.ts_tph_b5 AS tphB7_0_0_,
s.ts_tph_b6 AS tphB8_0_0_,
s.ts_tph_b7 AS tphB9_0_0_,
s.ts_tph_b8 AS tphB10_0_0_,
s.ts_tph_b9 AS tphB11_0_0_,
s.ts_tph_b10 AS tphB12_0_0_,
s.ts_tph_b11 AS tphB13_0_0_,
s.ts_tph_b12 AS tphB14_0_0_,
s.ts_tph_b13 AS tphB15_0_0_,
s.ts_tph_b14 AS tphB16_0_0_,
s.ts_tph_b15 AS tphB17_0_0_,
s.ts_tph_b16 AS tphB18_0_0_,
s.ts_tph_b17 AS tphB19_0_0_,
s.ts_tph_b18 AS tphB20_0_0_,
s.ts_tph_b19 AS tphB21_0_0_,
s.ts_tph_b20 AS tphB22_0_0_,
s.ts_tph_b21 AS tphB23_0_0_,
s.ts_tph_b22 AS tphB24_0_0_,
s.ts_tph_b23 AS tphB25_0_0_,
s.ts_tph_max AS tphB26_0_0_,
s.ts_tph_c0 AS tphC27_0_0_,
s.ts_tph_c1 AS tphC28_0_0_,
s.ts_tph_c2 AS tphC29_0_0_,
s.ts_tph_c3 AS tphC30_0_0_,
s.ts_tph_c4 AS tphC31_0_0_,
s.ts_tph_c5 AS tphC32_0_0_,
s.ts_tph_c6 AS tphC33_0_0_,
s.ts_tph_c7 AS tphC34_0_0_,
s.ts_tph_c8 AS tphC35_0_0_,
s.ts_tph_c9 AS tphC36_0_0_,
s.ts_tph_c10 AS tphC37_0_0_,
s.ts_tph_c11 AS tphC38_0_0_,
s.ts_tph_c12 AS tphC39_0_0_,
s.ts_tph_c13 AS tphC40_0_0_,
s.ts_tph_c14 AS tphC41_0_0_,
s.ts_tph_c15 AS tphC42_0_0_,
s.ts_tph_c16 AS tphC43_0_0_,
s.ts_tph_c17 AS tphC44_0_0_,
s.ts_tph_c18 AS tphC45_0_0_,
s.ts_tph_c19 AS tphC46_0_0_,
s.ts_tph_c20 AS tphC47_0_0_,
s.ts_tph_c21 AS tphC48_0_0_,
s.ts_tph_c22 AS tphC49_0_0_,
s.ts_tph_c23 AS tphC50_0_0_,
null AS tshB51_0_0_,
null AS tshB52_0_0_,
null AS tshB53_0_0_,
null AS tshB54_0_0_,
null AS tshB55_0_0_,
null AS tshB56_0_0_,
null AS tshB57_0_0_,
null AS tshB58_0_0_,
null AS tshB59_0_0_,
null AS tshB60_0_0_,
null AS tshB61_0_0_,
null AS tshB62_0_0_,
null AS tshB63_0_0_,
null AS tshB64_0_0_,
null AS tshB65_0_0_,
null AS tshB66_0_0_,
null AS tshB67_0_0_,
null AS tshB68_0_0_,
null AS tshB69_0_0_,
null AS tshB70_0_0_,
null AS tshB71_0_0_,
null AS tshB72_0_0_,
null AS tshB73_0_0_,
null AS tshB74_0_0_,
null AS tshB75_0_0_,
null AS tshC76_0_0_,
null AS tshC77_0_0_,
null AS tshC78_0_0_,
null AS tshC79_0_0_,
null AS tshC80_0_0_,
null AS tshC81_0_0_,
null AS tshC82_0_0_,
null AS tshC83_0_0_,
null AS tshC84_0_0_,
null AS tshC85_0_0_,
null AS tshC86_0_0_,
null AS tshC87_0_0_,
null AS tshC8
Login
FAQ
Search