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

View differences:

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