Revision 44678 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/jdbc2/spi/operations/CalculateEnvelopeOfColumnOperation.java
| CalculateEnvelopeOfColumnOperation.java | ||
|---|---|---|
| 4 | 4 |
import java.sql.ResultSet; |
| 5 | 5 |
import java.sql.SQLException; |
| 6 | 6 |
import java.sql.Statement; |
| 7 |
import java.util.List; |
|
| 7 | 8 |
import org.apache.commons.lang3.StringUtils; |
| 8 | 9 |
import org.cresques.cts.IProjection; |
| 9 | 10 |
import org.gvsig.expressionevaluator.ExpressionBuilder.Variable; |
| ... | ... | |
| 48 | 49 |
|
| 49 | 50 |
@Override |
| 50 | 51 |
public final Object perform(Connection conn) throws DataException {
|
| 51 |
Envelope env = calculateEnvelopeOfColumn( |
|
| 52 |
conn, |
|
| 53 |
featureType, |
|
| 54 |
table, |
|
| 55 |
columnName, |
|
| 56 |
baseFilter, |
|
| 57 |
limit, |
|
| 58 |
crs |
|
| 59 |
); |
|
| 52 |
Envelope env = calculateEnvelopeOfColumn(conn); |
|
| 60 | 53 |
return env; |
| 61 | 54 |
} |
| 62 | 55 |
|
| 63 |
public Envelope calculateEnvelopeOfColumn( |
|
| 64 |
Connection conn, |
|
| 65 |
FeatureType featureType, |
|
| 66 |
TableReference table, |
|
| 67 |
String columnName, |
|
| 68 |
String baseFilter, |
|
| 69 |
Envelope limit, |
|
| 70 |
IProjection crs |
|
| 71 |
) throws DataException {
|
|
| 72 |
|
|
| 56 |
public String getSQL() {
|
|
| 73 | 57 |
// |
| 74 | 58 |
// Parece ser que en versiones anteriores a SQL Server 2012 no esta |
| 75 | 59 |
// disponible la funcion ST_ExtentAggregate. |
| ... | ... | |
| 136 | 120 |
PROP_TABLE, table |
| 137 | 121 |
); |
| 138 | 122 |
String sql = sqlbuilder.select().toString(); |
| 139 |
|
|
| 123 |
return sql; |
|
| 124 |
} |
|
| 125 |
|
|
| 126 |
public Envelope calculateEnvelopeOfColumn(Connection conn) throws DataException {
|
|
| 127 |
String sql = this.getSQL(); |
|
| 128 |
|
|
| 140 | 129 |
Statement st = null; |
| 141 | 130 |
ResultSet rs = null; |
| 142 | 131 |
try {
|
Also available in: Unified diff