// Locks
Query lck=new QueryImpl(new Collection.Key[]{KeyConstants._web,KeyConstants._application,KeyConstants._name,START_TIME,KeyConstants._timeout,KeyConstants._type}, 0, "requests");
sct.setEL(LOCKS, lck);
// Loop webs
ConfigWebImpl web;
Struct pcs;
PageContextImpl _pc;
int row,openConnections=0;
CFMLFactoryImpl factory;
ActiveQuery[] queries;
ActiveQuery aq;
ActiveLock[] locks;
ActiveLock al;
for(int i=0;i<webs.length;i++){
// Loop requests
web=(ConfigWebImpl) webs[i];
factory=(CFMLFactoryImpl)web.getFactory();
pcs = factory.getRunningPageContexts();
Iterator<Object> it = pcs.valueIterator();
while(it.hasNext()){
_pc = (PageContextImpl) it.next();
if(_pc.isGatewayContext()) continue;
// Request
row = req.addRow();
req.setAt(KeyConstants._web, row, web.getLabel());
req.setAt(KeyConstants._uri, row, getPath(_pc.getHttpServletRequest()));
req.setAt(START_TIME, row, new DateTimeImpl(pc.getStartTime(),false));
req.setAt(KeyConstants._timeout, row, new Double(pc.getRequestTimeout()));
// Query
queries = _pc.getActiveQueries();
if(queries!=null) {
for(int y=0;y<queries.length;y++){
aq=queries[y];
row = qry.addRow();
qry.setAt(KeyConstants._web, row, web.getLabel());
qry.setAt(KeyConstants._application, row, _pc.getApplicationContext().getName());
qry.setAt(START_TIME, row, new DateTimeImpl(web,aq.startTime,true));
qry.setAt(KeyConstants._sql, row, aq.sql);
}
}
// Lock
locks = _pc.getActiveLocks();
if(locks!=null) {
for(int y=0;y<locks.length;y++){
al=locks[y];
row = lck.addRow();
lck.setAt(KeyConstants._web, row, web.getLabel());
lck.setAt(KeyConstants._application, row, _pc.getApplicationContext().getName());
lck.setAt(KeyConstants._name, row, al.name);
lck.setAt(START_TIME, row, new DateTimeImpl(web,al.startTime,true));
lck.setAt(KeyConstants._timeout, row, Caster.toDouble(al.timeoutInMillis/1000));
lck.setAt(KeyConstants._type, row, al.type==LockManager.TYPE_EXCLUSIVE?"exclusive":"readonly");
}
}
}
openConnections+=web.getDatasourceConnectionPool().openConnections();
// Template Cache
Mapping[] mappings = ConfigImpl.getAllMappings(web);
long[] tce = templateCacheElements(mappings);
row = tc.addRow();
tc.setAt(KeyConstants._web, row, web.getLabel());
tc.setAt(KeyConstants._size, row, new Double(tce[1]));
tc.setAt(ELEMENTS, row, new Double(tce[0]));
// Scope Application
getAllApplicationScopes(web,factory.getScopeContext(),app);