alibaba / yugong

阿里巴巴去Oracle数据迁移同步工具(全量+增量,目标支持MySQL/DRDS)
GNU General Public License v2.0
2.5k stars 957 forks source link

join表报错表不存在,但是是存在的,sql也可以执行 #145

Open wasdzgr opened 3 years ago

wasdzgr commented 3 years ago
        String bb_value = (String) jdbcTemplate.query("select GUID from ZSSF0002T where GUID='99999'", new ResultSetExtractor() {
            public Object extractData(ResultSet rs) throws SQLException, DataAccessException {
                if (rs.next()) {
                    return rs.getString("GUID");
                }
                return null;
            }
        });
        ColumnMeta bbMeta = new ColumnMeta("BB", Types.VARCHAR);
        ColumnValue bbColumn = new ColumnValue(bbMeta, bb_value);
        record.addColumn(bbColumn);
wasdzgr commented 3 years ago

错误信息 Caused by: Error : 942, Position : 17, Sql = select GUID from ZSSF0002T where GUID='99999', OriginalSql = select GUID from ZSSF0002T where GUID='99999', Error Msg = ORA-00942: 表或视图不存在