关于兼容达梦DM8的问题请教
Description
APIJSON:7.4.0 数据库:达梦DM8 JDK:1.8
你好,请教一下,关于apijson和达梦DM8的整合,目前来看文档没具体介绍到;
方案:是否把isOracle改为true,AbstractSQLConfig.DEFAULT_DATABASE=ORACLE,连接池改一下即可,还有其他注意事项吗?
参数 { "@explain": true, "[]": { "join": "&/StationExtension/stationCode@", "Station": { "stationEnabled": 1, "@column": "stationCode,stationName" }, "StationExtension": { "stationCode@": "/Station/stationCode", "@column": "stationCode" } } }
[执行语句1] SELECT * FROM (SELECT "Station".*, ROWNUM "RN" FROM (SELECT "Station"."station_code", "Station"."station_name", "StationExtension"."station_code" FROM "base_station" "Station" INNER JOIN "base_station_extension" "StationExtension" ON "StationExtension"."station_code" = "Station"."station_code" WHERE (("Station"."station_enabled" = 1) AND ("Station"."tenant_id" = 1001) )) "Station" WHERE ROWNUM <= 1000) WHERE "RN" > 0 执行失败,失败原因: [-2112]:第9行附近出现错误: 有歧义的列名[station_code]
应该是 JOIN 后两个 station_code 重名导致报错,可以给副表的 station_code 设置别名试试
我是database切成达梦也会有这样的问题,保持database是默认mysql就能用,索性还是先用着mysql吧