Revision 44198 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/AppendOperation.java
AppendOperation.java | ||
---|---|---|
4 | 4 |
import java.sql.Connection; |
5 | 5 |
import java.sql.PreparedStatement; |
6 | 6 |
import java.sql.SQLException; |
7 |
import org.gvsig.expressionevaluator.ExpressionBuilder; |
|
7 | 8 |
import org.gvsig.fmap.dal.DataTypes; |
9 |
import org.gvsig.fmap.dal.SQLBuilder; |
|
8 | 10 |
import org.gvsig.fmap.dal.exception.DataException; |
9 | 11 |
import org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor; |
10 | 12 |
import org.gvsig.fmap.dal.feature.FeatureType; |
... | ... | |
13 | 15 |
import org.gvsig.fmap.dal.store.jdbc.exception.JDBCPreparingSQLException; |
14 | 16 |
import org.gvsig.fmap.dal.store.jdbc2.JDBCHelper; |
15 | 17 |
import org.gvsig.fmap.dal.store.jdbc2.JDBCUtils; |
16 |
import org.gvsig.fmap.dal.store.jdbc2.OperationsFactory; |
|
17 | 18 |
import org.gvsig.fmap.dal.store.jdbc2.OperationsFactory.TableReference; |
18 | 19 |
import org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase; |
19 | 20 |
import org.gvsig.tools.dispose.Disposable; |
... | ... | |
28 | 29 |
protected final FeatureType type; |
29 | 30 |
|
30 | 31 |
protected JDBCSQLBuilderBase sqlbuilder = null; |
32 |
protected ExpressionBuilder expbuilder; |
|
33 |
|
|
31 | 34 |
protected PreparedStatement preparedStatement; |
32 | 35 |
protected String sql; |
33 | 36 |
|
... | ... | |
50 | 53 |
this.connection = this.helper.getConnectionWritable(); |
51 | 54 |
|
52 | 55 |
this.sqlbuilder = this.helper.createSQLBuilder(); |
56 |
this.expbuilder = this.sqlbuilder.expression(); |
|
53 | 57 |
|
54 | 58 |
this.sqlbuilder.insert().table() |
55 | 59 |
.database(this.table.getDatabase()) |
... | ... | |
62 | 66 |
} |
63 | 67 |
if (attr.getType() == DataTypes.GEOMETRY) { |
64 | 68 |
this.sqlbuilder.insert().column().name(attr.getName()).with_value( |
65 |
sqlbuilder.parameter(attr.getName()).as_geometry_variable().srs(
|
|
66 |
sqlbuilder.parameter().value(attr.getSRS())
|
|
69 |
expbuilder.parameter(attr.getName()).as_geometry_variable().srs(
|
|
70 |
expbuilder.parameter().value(attr.getSRS())
|
|
67 | 71 |
) |
68 | 72 |
); |
69 | 73 |
} else { |
70 | 74 |
this.sqlbuilder.insert().column().name(attr.getName()).with_value( |
71 |
sqlbuilder.parameter(attr.getName()).as_variable()
|
|
75 |
expbuilder.parameter(attr.getName()).as_variable()
|
|
72 | 76 |
); |
73 | 77 |
} |
74 | 78 |
} |
Also available in: Unified diff