private static boolean hasField(ResultSetMetaData resultSetMetaData, String fieldName) throws SQLException { return getFieldIndex(resultSetMetaData, fieldName) != -1; }
private static boolean hasField(ResultSetMetaData resultSetMetaData, String fieldName) throws SQLException { return getFieldIndex(resultSetMetaData, fieldName) != -1; }
private static boolean hasField(ResultSetMetaData resultSetMetaData, String fieldName) throws SQLException { return getFieldIndex(resultSetMetaData, fieldName) != -1; }
@Override public Geometry getGeometry() throws SQLException { if(firstGeometryIndex == -1) { try(Connection connection = dataSource.getConnection()) { List<String> geoFields = SFSUtilities.getGeometryFields(connection, location); if(!geoFields.isEmpty()) { firstGeometryIndex = JDBCUtilities.getFieldIndex(getMetaData(), geoFields.get(0)); } else { throw new SQLException("No geometry column found"); } } } return getGeometry(firstGeometryIndex); }
@Override public Geometry getGeometry() throws SQLException { if(firstGeometryIndex == -1) { try(Connection connection = dataSource.getConnection()) { List<String> geoFields = SFSUtilities.getGeometryFields(connection, location); if(!geoFields.isEmpty()) { firstGeometryIndex = JDBCUtilities.getFieldIndex(getMetaData(), geoFields.get(0)); } else { throw new SQLException("No geometry column found"); } } } return getGeometry(firstGeometryIndex); }
private void doUpdate(Long pk, Object value, boolean callListeners) throws SQLException { try(Connection connection = dataManager.getDataSource().getConnection(); PreparedStatement st = connection.prepareStatement("UPDATE "+tableLocation+" SET "+TableLocation.quoteIdentifier(columnName, isH2)+" = ? WHERE "+pkName+" = ?")) { st.setObject(1, value); st.setLong(2, pk); st.execute(); if(callListeners) { try (Statement stat = connection.createStatement(); ResultSet rs = stat.executeQuery("SELECT * from " + tableLocation.toString(isH2) + " LIMIT 0")) { // Fire with the new PK Value Long pkToFire = pk; if( columnName.equals(pkName)) { pkToFire = Long.valueOf(value.toString()); } dataManager.fireTableEditHappened(new TableEditEvent(tableLocation.toString(isH2), JDBCUtilities.getFieldIndex(rs.getMetaData(), columnName), pkToFire, pkToFire, TableModelEvent.UPDATE)); } } } }
int geoFieldIndex = JDBCUtilities.getFieldIndex(resultSetMetaData, spatialFieldNames.get(0));
ProgressVisitor copyProgress = progress.subProcess(recordCount); ResultSetMetaData resultSetMetaData = rs.getMetaData(); int geoFieldIndex = JDBCUtilities.getFieldIndex(resultSetMetaData, spatialFieldNames.get(0));
ProgressVisitor copyProgress = progress.subProcess(recordCount); ResultSetMetaData resultSetMetaData = rs.getMetaData(); int geoFieldIndex = JDBCUtilities.getFieldIndex(resultSetMetaData, spatialFieldNames.get(0));
ProgressVisitor copyProgress = progress.subProcess(recordCount); ResultSetMetaData resultSetMetaData = rs.getMetaData(); int geoFieldIndex = JDBCUtilities.getFieldIndex(resultSetMetaData, spatialFieldNames.get(0));
ProgressVisitor copyProgress = progress.subProcess(recordCount); ResultSetMetaData resultSetMetaData = rs.getMetaData(); int geoFieldIndex = JDBCUtilities.getFieldIndex(resultSetMetaData, spatialFieldNames.get(0));
int geoFieldIndex = JDBCUtilities.getFieldIndex(resultSetMetaData, spatialFieldNames.get(0)); cacheMetadata(resultSetMetaData); while (rs.next()) {
int geoFieldIndex = JDBCUtilities.getFieldIndex(resultSetMetaData, spatialFieldNames.get(0)); int recordCount = JDBCUtilities.getRowCount(connection, tableName); ProgressVisitor copyProgress = progress.subProcess(recordCount);
try { ResultSetMetaData resultSetMetaData = rs.getMetaData(); int geoFieldIndex = JDBCUtilities.getFieldIndex(resultSetMetaData, spatialFieldNames.get(0)); cacheMetadata(resultSetMetaData); while (rs.next()) {
try { ResultSetMetaData resultSetMetaData = resultSet.getMetaData(); int geoFieldIndex = JDBCUtilities.getFieldIndex(resultSetMetaData, spatialFieldNames.get(0)); ArrayList<Integer> columnIndexes = new ArrayList<Integer>(); DbaseFileHeader header = DBFDriverFunction.dBaseHeaderFromMetaData(resultSetMetaData, columnIndexes);
try { ResultSetMetaData resultSetMetaData = resultSet.getMetaData(); int geoFieldIndex = JDBCUtilities.getFieldIndex(resultSetMetaData, spatialFieldNames.get(0)); ArrayList<Integer> columnIndexes = new ArrayList<Integer>(); DbaseFileHeader header = DBFDriverFunction.dBaseHeaderFromMetaData(resultSetMetaData, columnIndexes);
try { ResultSetMetaData resultSetMetaData = rs.getMetaData(); int geoFieldIndex = JDBCUtilities.getFieldIndex(resultSetMetaData, spatialFieldNames.get(0)); ArrayList<Integer> columnIndexes = new ArrayList<Integer>(); DbaseFileHeader header = DBFDriverFunction.dBaseHeaderFromMetaData(resultSetMetaData, columnIndexes);
try { ResultSetMetaData resultSetMetaData = rs.getMetaData(); int geoFieldIndex = JDBCUtilities.getFieldIndex(resultSetMetaData, spatialFieldNames.get(0)); ArrayList<Integer> columnIndexes = new ArrayList<Integer>(); DbaseFileHeader header = DBFDriverFunction.dBaseHeaderFromMetaData(resultSetMetaData, columnIndexes);
try { ResultSetMetaData resultSetMetaData = rs.getMetaData(); int geoFieldIndex = JDBCUtilities.getFieldIndex(resultSetMetaData, spatialFieldNames.get(0)); ArrayList<Integer> columnIndexes = new ArrayList<Integer>(); DbaseFileHeader header = DBFDriverFunction.dBaseHeaderFromMetaData(resultSetMetaData, columnIndexes);
try { ResultSetMetaData resultSetMetaData = rs.getMetaData(); int geoFieldIndex = JDBCUtilities.getFieldIndex(resultSetMetaData, spatialFieldNames.get(0)); ArrayList<Integer> columnIndexes = new ArrayList<Integer>(); DbaseFileHeader header = DBFDriverFunction.dBaseHeaderFromMetaData(resultSetMetaData, columnIndexes);