分布式事务seata之oracle版本踩坑之路

目前遇到的坑有 seata版本问题，低版本不支持oracle数据库、undo_log表的序列名问题、oracle数据库驱动等问题；先记录下，有别的坑再继续记录

1、seata 依赖及版本，对应的seata-server使用seata-server-1.4.2

        <dependency>
            <groupId>com.alibaba.cloud</groupId>
            <artifactId>spring-cloud-starter-alibaba-seata</artifactId>
            <version>2.1.0.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba.cloud</groupId>
            <artifactId>spring-cloud-alibaba-seata</artifactId>
            <version>2.2.0.RELEASE</version>
        </dependency>

虽然官方说支持oracle，实践发现spring-cloud-alibaba-seata使用2.1.0.RELEASE提示"seata Just support MySQL by now"

2、undo_log表结构及序列，查看源码OracleUndoLogManager类发现序列名为UNDO_LOG_SEQ

CREATE TABLE "UNDO_LOG" (
"ID" NUMBER(20) NOT NULL ,
"BRANCH_ID" NUMBER(20) NOT NULL ,
"XID" VARCHAR2(100 BYTE) NOT NULL ,
"CONTEXT" VARCHAR2(128 BYTE) NOT NULL ,
"LOG_STATUS" NUMBER(11) NOT NULL ,
"LOG_CREATED" DATE NOT NULL ,
"LOG_MODIFIED" DATE NOT NULL ,
"EXT" VARCHAR2(100 BYTE) DEFAULT NULL  NULL ,
"ROLLBACK_INFO" VARCHAR2(4000 BYTE) NOT NULL 
)
LOGGING
NOCOMPRESS
NOCACHE;
COMMENT ON TABLE "UNDO_LOG" IS 'SEATA回滚日志';
CREATE UNIQUE INDEX "UNDO_LOG_INDEX0"
ON "UNDO_LOG" ("XID" ASC, "BRANCH_ID" ASC)
LOGGING;
ALTER TABLE "UNDO_LOG" ADD UNIQUE ("XID", "BRANCH_ID");
ALTER TABLE "UNDO_LOG" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "UNDO_LOG" ADD CHECK ("BRANCH_ID" IS NOT NULL);
ALTER TABLE "UNDO_LOG" ADD CHECK ("XID" IS NOT NULL);
ALTER TABLE "UNDO_LOG" ADD CHECK ("CONTEXT" IS NOT NULL);
ALTER TABLE "UNDO_LOG" ADD CHECK ("LOG_STATUS" IS NOT NULL);
ALTER TABLE "UNDO_LOG" ADD CHECK ("LOG_CREATED" IS NOT NULL);
ALTER TABLE "UNDO_LOG" ADD CHECK ("LOG_MODIFIED" IS NOT NULL);
ALTER TABLE "UNDO_LOG" ADD CHECK ("ROLLBACK_INFO" IS NOT NULL);
ALTER TABLE "UNDO_LOG" ADD PRIMARY KEY ("ID");

create sequence UNDO_LOG_SEQ
minvalue 1
maxvalue 999999999
start with 1
increment by 1
cache 20;

3、oracle驱动使用 ojdbc6

<dependency>
			<groupId>com.oracle</groupId>
			<artifactId>ojdbc6</artifactId>
			<version>12.1.0.1-atlassian-hosted</version>
		</dependency>

4、好像 where 条件后不支持子查询