Revision 47606 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/SRSSolverBase.java

View differences:

SRSSolverBase.java
110 110
        try {
111 111
            String[] s = applicationAbbrev.split(":");
112 112
            sql = "select srid, auth_name, auth_srid from spatial_ref_sys where upper(auth_name) = upper('" + s[0] +"') and auth_srid = "+s[1]+" ";
113
            Statement st = connection.createStatement();
113
            Statement st = connection.createStatement(sql);
114 114
            ResultSet rs = JDBCUtils.executeQuery(st, sql);
115 115
            if ( rs.next() ) {
116 116
                Integer srid = rs.getInt("srid");
......
126 126
    protected String searchApplicationAbbrev(JDBCConnection connection, Integer databaseCode) {
127 127
        String sql = "select srid, auth_name, auth_srid from spatial_ref_sys where srid = " + databaseCode;
128 128
        try {
129
            Statement st = connection.createStatement();
129
            Statement st = connection.createStatement(sql);
130 130
            ResultSet rs = JDBCUtils.executeQuery(st, sql);
131 131
            if ( rs.next() ) {
132 132
                int auth_code = rs.getInt("auth_srid");

Also available in: Unified diff