mybatis+oracle存储大文本类型

业务需求存大文本字段，不能使用NVARCHAR2 默认2000字符，使用CLOB字段，表结构

CREATE TABLE "wait_authorization" (
"id" NVARCHAr2(255) NOT NULL ,
"content" CLOB NULL ,
constraint WAIT_AUTH_PK primary key("id")
)
LOGGING
NOCOMPRESS
NOCACHE

;
COMMENT ON COLUMN "wait_authorization"."id" IS '主键ID';
COMMENT ON COLUMN "wait_authorization"."content" IS '内容';
 

 java实体

clob类型用String类型

package com.cloud.entity.sub;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.ToString;

import java.util.Date;

@Data
@AllArgsConstructor
@NoArgsConstructor
@ToString
public class WaitAuthorization {

    private String id;
    // 内容(JSON字符串)
    private String content;

  

}

 测试 写了一个新增和查询

package com.cloud.resource.controller;

import com.cloud.entity.sub.WaitAuthorization;
import com.cloud.framework.bean.Result;
import com.cloud.framework.util.ResponseUtils;
import com.cloud.framework.util.UUIDGenerator;
import com.cloud.resource.repository.ResourcesApprovalMapper;
import com.cloud.security.i18nbase.BaseResource;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

@CrossOrigin(origins = "*", allowCredentials = "true", maxAge = 3600)
@RestController
@RequestMapping("/test")
@Api("项目管理")
public class TestController  extends BaseResource {

    @Autowired
    private ResourcesApprovalMapper resourcesApprovalMapper;
    @PostMapping("/add")
    @ApiOperation(value = "新建项目")
    public Result