Closed real9527 closed 1 month ago
DROP TABLE IF EXISTS "dual"; CREATE TABLE "dual" ( "id" int8 NOT NULL ); -- dual 插入一条记录 INSERT INTO "dual" VALUES (0);
亲测可以解决
DROP TABLE IF EXISTS "dual"; CREATE TABLE "dual" ( "id" int8 NOT NULL ); -- dual 插入一条记录 INSERT INTO "dual" VALUES (0);
亲测可以解决
可以,推荐这种方式哈。
Druid配置的validation-query: SELECT 1 FROM DUAL 可能对PostgreSQL无效,需要对表DUAL中插入一条数据,不然返回值为空,则判断为Druid连接失败