/ - Diff - | gvSIG desktop 1 - gvSIG

     		try {
     			if (!cnn.isClosed()) {
     				cnn.close();
     				OracleResource.CONN_COUNT--;
     				logger.debug("ORACLE CONN_COUNT +- = " + OracleResource.CONN_COUNT);
     				OracleResource.CONN__COUNT--;
     				if (OracleResource.CONN__COUNT > 5) {
     					logger.info("ORACLE CONN_COUNT +- = " + OracleResource.CONN__COUNT);
+    				}
+    			}
     		} catch (Exception ex) {
     			logger.warn("While disposing Ora helper: " + ex.getMessage());

     		return ods;
+    	}
     	public static int CONN_COUNT = 0;
     	public static int CONN__COUNT = 0;
     	protected synchronized Object getTheConnection() throws DataException {
     		if (conn == null) {
     			conn = (Connection) super.getTheConnection();
     			CONN_COUNT++;
     			logger.debug("ORACLE CONN_COUNT +- = " + CONN_COUNT);
     			CONN__COUNT++;
     			if (CONN__COUNT > 5) {
     				logger.info("ORACLE CONN_COUNT +- = " + CONN__COUNT);
+    			}
+    		}
     		return conn;

     		sqlCount++;
     		if (System.currentTimeMillis() - lastPrint > 5000) {
     		if (System.currentTimeMillis() - lastPrint > TIME_GAP) {
     			logger.info("Executing SQL # " + sqlCount + ": " + sql.toString());
     			lastPrint = System.currentTimeMillis();
+    		}
-...
     		return sql.toString();
+    	}
     	private static int TIME_GAP = 10000;
     	private static long lastPrint = 0;
     	private static long sqlCount = 0;

| gvSIG desktop 1