Hibernate/Spring - It takes 16 ms to execute the query, but 12 secs to process the ResulSet of 307 rows (13 columns, DB2 mostly String).

This is what I get from the Logs:


[10/17/08 14:52:03:789 EDT] 00000056 SystemOut O 2008-10-17 14:52:03,789 DEBUG SessionImpl - opened session at timestamp: 12242695237
...
...
[10/17/08 14:52:03:805 EDT] 00000056 SystemOut O 2008-10-17 14:52:03,805 DEBUG ConnectionManager - opening JDBC connection
...
...
[10/17/08 14:52:03:805 EDT] 00000056 SystemOut O 2008-10-17 14:52:03,805 DEBUG AbstractBatcher - preparing statement

[10/17/08 14:52:03:821 EDT] 00000056 PmiRmArmWrapp I PMRM0003I: parent:ver=1,ip=172.29.0.177,time=1224267689365,pid=8864,reqid=8194,event=1 - current:ver=1,ip=172.29.0.177,time=1224267689365,pid=8864,reqid=8195,event=1 type=JDBC detail=executeQuery elapsed=16

[10/17/08 14:52:03:836 EDT] 00000056 SystemOut O 2008-10-17 14:52:03,836 DEBUG AbstractBatcher - about to open ResultSet (open ResultSets: 0, globally: 0)

[10/17/08 14:52:03:836 EDT] 00000056 SystemOut O 2008-10-17 14:52:03,836 DEBUG Loader - processing result set

[10/17/08 14:52:03:836 EDT] 00000056 SystemOut O 2008-10-17 14:52:03,836 DEBUG Loader - result set row:...
...
...
[10/17/08 14:52:15:367 EDT] 00000056 SystemOut O 2008-10-17 14:52:15,367 DEBUG Loader - result set row: 307