/ - Diff - Application: gvSIG desktop - gvSIG

     import java.awt.event.KeyEvent;
     import java.awt.event.KeyListener;
     import java.awt.geom.Rectangle2D;
     import java.sql.DatabaseMetaData;
     import java.sql.ResultSet;
     import java.sql.SQLException;
     import java.sql.Types;
-...
     			throw new SQLException("Unknown connection type: " + conex.getClass().getName());
+    		}
     		String[] ret_types = {"TABLE", "VIEW"};
     		String[] ret_types = {"TABLE", "VIEW", "SYSTEM TABLE" /* odbc */ };
     		ResultSet rs = null;
     		try {
     //		    DatabaseMetaData dmd = jdbc_conn.getConnection().getMetaData();
     //		    ResultSet rs2 = dmd.getTables(null, null, "%", null);
     //		    while (rs2.next())
     //		        System.out.println(rs2.getString(3) + " " + rs2.getString(4));
     //		    rs2 = dmd.getTables(null, null, null, null);
     //		    int colcnt = rs2.getMetaData().getColumnCount();
     //		    while (rs2.next()) {
     //		    	for (int i=0; i<colcnt; i++) {
     //		    		System.out.println(rs2.getMetaData().getColumnName(i+1) + " : " + rs2.getString(i+1));
     //		    	}
     //		    }
     			// jdbc_conn.getConnection().getMetaData().
     			rs = jdbc_conn.getConnection().getMetaData().getTables(
     					null,
     					src.getSchema().length() == 0 ? null : src.getSchema(),
-...
     			if (lm.getElementAt(i) instanceof TablesListItemSimple) {
     				item = (TablesListItemSimple) lm.getElementAt(i);
     				if (item.isSelected()) {
     					return item.getTableName();
     					return quoteTableName(item.getTableName());
+    				}
+    			}
+    		}
-...
     			ConnectionJDBC conn = (ConnectionJDBC) iconn;
     			AlphanumericDBDriver alpha_drv = (AlphanumericDBDriver) drv;
     			tn = acttab.getTableName();
     			tn = quoteTableName(acttab.getTableName());
     			String _sql = "SELECT * FROM " + tn + " WHERE (0=1)";
     			FieldDescription[] fd = null;
-...
     		getFieldsScrollPane().updateUI();
+    	}
     	public static String quoteTableName(String _tn) {
     		String[] pointspl = _tn.split("\\.");
     		String resp = "";
     		for (int i=0; i<pointspl.length; i++) {
     			if (i!=0) {
     				resp = resp + ".";
+    			}
     			resp = resp + "\"" + pointspl[i] + "\"";
+    		}
     		return resp;
+    	}

     import java.sql.DriverManager;
     import java.sql.SQLException;
     import org.apache.log4j.Logger;
     /**
      * DOCUMENT ME!
+     *
      * @author Vicente Caballero Navarro
      */
     public class ConnectionJDBC implements IConnection {
     	private static Logger logger = Logger.getLogger(ConnectionJDBC.class.getName());
         private Connection connection;
     	private String connectionStr;
     	private String user;
-...
+    	}
     	public void setDataConnection(Connection _conn, String user, String _pw) throws DBException {
     		connection = _conn;
     		try {
     			connection = _conn;
     			connection.setAutoCommit(false);
     			this.connectionStr = null;
     			this.user = user;
     			this._pw = _pw;
     		} catch (SQLException e) {
     			throw new DBException(e);
     		} catch (Exception ex) {
     			logger.error("Autocommit not allowed for this driver: " + ex.getMessage());
+    		}
     		this.connectionStr = null;
     		this.user = user;
     		this._pw = _pw;
+    	}
     	/**

branches/gvSIG_1.11.0_Mejoras_gvSIG-EIEL/libraries/libFMap/src/com/iver/cit/gvsig/fmap/drivers/DefaultJDBCDriver.java
616	616	}
617	617
618	618	newConn = cwp.getConnection();
619		//((ConnectionJDBC)newConn).getConnection().setAutoCommit(false);
620	619
621	620	DBLayerDefinition lyrDef = new DBLayerDefinition();
622	621	if (getLyrDef() == null) {

     import java.sql.ResultSetMetaData;
     import java.sql.SQLException;
     import org.apache.log4j.Logger;
     import sun.jdbc.odbc.JdbcOdbcConnection;
     import com.hardcode.gdbms.engine.values.Value;
     import com.iver.cit.gvsig.exceptions.visitors.ProcessWriterVisitorException;
     import com.iver.cit.gvsig.exceptions.visitors.StartWriterVisitorException;
-...
     import com.iver.cit.gvsig.fmap.core.IRow;
     import com.iver.cit.gvsig.fmap.drivers.XTypes;
     import com.iver.cit.gvsig.fmap.edition.IRowEdited;
     import com.iver.cit.gvsig.fmap.layers.SelectableDataSource;
     public class JdbcWriter extends AbstractWriter {
     	private static Logger logger = Logger.getLogger(JdbcWriter.class.getName());
     	Connection conn;
     	ResultSet rs;
     	Value[] record;
-...
     			try {
     				conn.setAutoCommit(false);
     			} catch (SQLException e) {
     				throw new StartWriterVisitorException(getName(),e);
     				if (conn instanceof JdbcOdbcConnection) {
     					logger.warn("Driver does not allow autocommit method: " + conn.getClass().getName());
     				} else {
     					throw new StartWriterVisitorException(getName(),e);
+    				}
+    			}
     			/* Statement st = conn.createStatement();
-...
+    		}
+    	}
+    }
     // [eiel-gestion-conexiones]

Application: gvSIG desktop

Revision 34778