/ - Diff - Application: gvSIG desktop - gvSIG

     import java.util.Arrays;
     import java.util.Date;
     import java.util.List;
     import java.util.logging.Level;
     import org.apache.commons.lang3.StringUtils;
     import org.cresques.cts.IProjection;
-...
                 return st.executeUpdate();
+            }
             public void closeConnection(Connection connection) {
                 this.getResource().closeConnection(connection);
+            }
             public void execute(String sql) throws JDBCExecuteSQLException {
                 try {
                     Connection conn = this.getConnection();
                     Statement st = conn.createStatement();
                     JDBCHelper.execute(st, sql);
                     this.closeConnection(conn);
                 } catch (Exception ex) {
                    throw new JDBCExecuteSQLException(sql, ex);
+                }
+            }
     	protected void initializeResource() throws InitializeException {
     		ResourceManagerProviderServices manager = (ResourceManagerProviderServices) DALLocator
     				.getResourceManager();
-...
     					throw e;
     				} finally {
     					try {
     						if (conn != null) {
     							conn.close();
+    						}
     					} catch (Exception e1) {
     						logger.error("Exception on close connection", e1);
+    					}
     					// this.end();
                                         closeConnection(conn);
+    				}
+    			}
     		});

     	public Connection getJDBCConnection() throws AccessResourceException {
     		return (Connection) get();
+    	}
             public void closeConnection(Connection connection) {
                 try {
                     logger.debug("before-close connection"+ this.getStatusInformation());
                     connection.close();
                     logger.debug("after close connection "+ this.getStatusInformation());
                 } catch (Exception ex) {
                     logger.warn("Problems closing connection.",ex);
+                }
+            }
     	private void debugPoolStatus(String src) {
     		if (logger.isDebugEnabled() && dataSource instanceof BasicDataSource) {
     			BasicDataSource ds = (BasicDataSource) dataSource;
     			logger.debug(src + "  actives:" + ds.getNumActive() + "("
     					+ ds.getMaxActive() + ") idle:" + ds.getNumIdle() + "("
     					+ ds.getMaxIdle() + ")");
     		if (logger.isDebugEnabled() ) {
     			logger.debug(src + "  " + this.getStatusInformation());
+    		}
+    	}
             public String getStatusInformation() {
     		if ( !(dataSource instanceof BasicDataSource) ) {
                         return "Connected: " + this.isConnected();
+                    }
             	BasicDataSource ds = (BasicDataSource) dataSource;
                     String s = "Connected: " + this.isConnected() + ", " +
                             "actives: "+ ds.getNumActive() + "/"+ ds.getMaxActive() + ", " +
                             "idle: " + ds.getNumIdle() + "/"+ ds.getMaxIdle() ;
                     return s;
+            }
     	protected synchronized Object getTheConnection() throws DataException {
     		try {

trunk/org.gvsig.desktop/org.gvsig.desktop.compat.cdc/org.gvsig.fmap.dal/org.gvsig.fmap.dal.db/org.gvsig.fmap.dal.db.jdbc/src/main/java/org/gvsig/fmap/dal/store/jdbc/JDBCAppender.java
69	69	} catch (SQLException ex) {
70	70	throw new PerformEditingException(this.getSourceId().toString(), ex);
71	71	} finally {
	72	this.provider.getHelper().closeConnection(this.connection);
72	73	this.connection = null;
73	74	this.provider.getHelper().getResource().endUse();
74	75	}

                 );
                 if (this.options.canCreatetable()) {
                     logger.debug("Creating table");
                     taskStatus.message("Creating table");
                     this.createTable(explorer);
+                }
-...
                     sourceGeometryIndex = sourceFeatureType.getDefaultGeometryAttributeIndex();
+                }
                 logger.debug("Inserting rows");
                 taskStatus.message("Inserting rows");
                 it = featureSet.fastIterator();
                 while (it.hasNext()) {
-...
                 target.finishEditing();
                 if (this.options.getUpdateTableStatistics()) {
                     logger.debug("Updating statistics");
                     taskStatus.message("Updating statistics");
                     explorer.updateTableStatistics(openParams.tableID());
+                }
                 logger.debug("finish");
                 if (exporttoServiceFinishAction != null) {
                     exporttoServiceFinishAction.finished(

Application: gvSIG desktop

Revision 41880