static void display(ComboPooledDataSource cpds) throws Exception {
System.err.println("numConnections: " + cpds.getNumConnections());
System.err.println("numBusyConnections: " + cpds.getNumBusyConnections());
System.err.println("numIdleConnections: " + cpds.getNumIdleConnections());
System.err.println(
"numUnclosedOrphanedConnections: " + cpds.getNumUnclosedOrphanedConnections());
System.err.println();
}
/**
* Get Status
*
* @return status info
*/
@Override
public String getStatus() {
if (m_ds == null) {
return null;
}
StringBuffer sb = new StringBuffer();
try {
sb.append("# Connections: ").append(m_ds.getNumConnections());
sb.append(" , # Busy Connections: ").append(m_ds.getNumBusyConnections());
sb.append(" , # Idle Connections: ").append(m_ds.getNumIdleConnections());
sb.append(" , # Orphaned Connections: ").append(m_ds.getNumUnclosedOrphanedConnections());
} catch (Exception e) {
}
return sb.toString();
} // getStatus
/**
* String Representation
*
* @return info
*/
@Override
public String toString() {
StringBuffer sb = new StringBuffer("DB_Oracle[");
sb.append(m_connectionURL);
try {
StringBuffer logBuffer = new StringBuffer(50);
logBuffer.append("# Connections: ").append(m_ds.getNumConnections());
logBuffer.append(" , # Busy Connections: ").append(m_ds.getNumBusyConnections());
logBuffer.append(" , # Idle Connections: ").append(m_ds.getNumIdleConnections());
logBuffer
.append(" , # Orphaned Connections: ")
.append(m_ds.getNumUnclosedOrphanedConnections());
} catch (Exception e) {
sb.append("=").append(e.getLocalizedMessage());
}
sb.append("]");
return sb.toString();
} // toString
public int getNumUnclosedOrphanedConnections(String username, String password)
throws SQLException {
return combods.getNumUnclosedOrphanedConnections(username, password);
}
