APIJSON icon indicating copy to clipboard operation
APIJSON copied to clipboard

关于兼容达梦DM8的问题请教

Open gxmanito opened this issue 10 months ago • 3 comments

Description

APIJSON:7.4.0 数据库:达梦DM8 JDK:1.8

你好,请教一下,关于apijson和达梦DM8的整合,目前来看文档没具体介绍到;

方案:是否把isOracle改为true,AbstractSQLConfig.DEFAULT_DATABASE=ORACLE,连接池改一下即可,还有其他注意事项吗?

Image

Image

Image

gxmanito avatar Feb 25 '25 06:02 gxmanito

参数 { "@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]

gxmanito avatar Feb 28 '25 07:02 gxmanito

应该是 JOIN 后两个 station_code 重名导致报错,可以给副表的 station_code 设置别名试试

TommyLemon avatar Feb 28 '25 16:02 TommyLemon

我是database切成达梦也会有这样的问题,保持database是默认mysql就能用,索性还是先用着mysql吧

ForJ-W avatar Mar 26 '25 04:03 ForJ-W