2007-07-25 23:31:42,566 DEBUG [RMI TCP Connection(7021)-63.252.235.30] com.mchange.v2.resourcepool.BasicResourcePool: resourc
e age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@41931a ---> age: 49067 max: 600000 [com.mchange.v2.resourcepool
.BasicResourcePool@113a410]
2007-07-25 23:31:42,566 DEBUG [RMI TCP Connection(7021)-63.252.235.30] com.mchange.v2.resourcepool.BasicResourcePool: trace c
om.mchange.v2.resourcepool.BasicResourcePool@113a410 [managed: 16, unused: 14, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.Ne
wPooledConnection@41931a)
2007-07-25 23:31:42,566 DEBUG [RMI TCP Connection(7021)-63.252.235.30] PollerBackEnd.org.opennms.netmgt.dao.support.JdbcFilte
rDao: Filter: SQL statement:
SELECT DISTINCT ipInterface.ipAddr FROM ipInterface, category_node, categories WHERE (categories.categoryName = 'pavlov') AND
category_node.nodeID = ipInterface.nodeID AND categories.categoryID = category_node.categoryID AND category_node.nodeID = ip
Interface.nodeID
2007-07-25 23:31:42,567 DEBUG [RMI TCP Connection(7021)-63.252.235.30] com.mchange.v2.resourcepool.BasicResourcePool: trace c
om.mchange.v2.resourcepool.BasicResourcePool@113a410 [managed: 16, unused: 14, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.Ne
wPooledConnection@41931a)
2007-07-25 23:31:42,568 DEBUG [RMI TCP Connection(7021)-63.252.235.30] org.hibernate.SQL: select this_.id as id7_1_, this_.ip
InterfaceId as ipInterf9_7_1_, this_.serviceId as serviceId7_1_, this_.notify as notify7_1_, this_.lastGood as lastGood7_1_,
this_.lastFail as lastFail7_1_, this_.qualifier as qualifier7_1_, this_.source as source7_1_, this_.status as status7_1_, onm
sservic2_.serviceId as serviceId9_0_, onmsservic2_.serviceName as serviceN2_9_0_ from ifServices this_ inner join service onm
sservic2_ on this_.serviceId=onmsservic2_.serviceId
2007-07-25 23:31:42,577 DEBUG [RMI TCP Connection(7021)-63.252.235.30] org.hibernate.SQL: select onmsipinte0_.id as id4_0_, o
nmsipinte0_.ipAddr as ipAddr4_0_, onmsipinte0_.isSnmpPrimary as isSnmpPr3_4_0_, onmsipinte0_.ipHostName as ipHostName4_0_, on
msipinte0_.isManaged as isManaged4_0_, onmsipinte0_.ipStatus as ipStatus4_0_, onmsipinte0_.ipLastCapsdPoll as ipLastCa7_4_0_,
onmsipinte0_.snmpInterfaceId as snmpInte8_4_0_, onmsipinte0_.nodeId as nodeId4_0_ from ipInterface onmsipinte0_ where onmsip
inte0_.id=?