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(); }
public Connection getConnection(AccessConfiguration configuration) throws DAOException { init(configuration); Connection connection = null; try { if (logger.isTraceEnabled()) logger.trace("Getting connection from pool "); if (logger.isTraceEnabled()) logger.trace(" getMaxPoolSize: " + cpds.getMaxPoolSize()); if (logger.isTraceEnabled()) logger.trace(" getNumConnections: " + cpds.getNumConnections()); if (logger.isTraceEnabled()) logger.trace(" getNumBusyConnections: " + cpds.getNumBusyConnections()); connection = cpds.getConnection(); if (logger.isTraceEnabled()) logger.trace("Opened connections: " + cpds.getNumConnections()); } catch (SQLException sqle) { close(connection); throw new DAOException( " getConnection: " + sqle + "\n\ndriver: " + configuration.getDriver() + " - uri: " + configuration.getUri() + " - login: "******" - password: "******"\n"); } if (connection == null) { throw new DAOException( "Connection is NULL !" + "\n\ndriver: " + configuration.getDriver() + " - uri: " + configuration.getUri() + " - login: "******" - password: "******"\n"); } return connection; }
/** * 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 getNumConnections(String username, String password) throws SQLException { return combods.getNumConnections(username, password); }