- I have searched the issues of this repository and believe that this is not a duplicate.
Ⅰ. Issue Description
seata AT mode error, XA mode is normal,The error message is as follows
2023-03-14 16:08:38.538 [http-nio-9003-exec-1] ERROR c.c.k.c.c.f.aop.LogRemoteAspect - [?,?] - [TID: N/A] ERROR-Remote-当前业务执行类:cn.xxx.north.remote.resource.XxxxResource,方法名:newLabel,异常信息:org.springframework.jdbc.UncategorizedSQLException:
### Error updating database. Cause: java.sql.SQLException: 无效的列类型
### The error may exist in xxx/south/port/repository/XxxxxMapper.java (best guess)
### The error may involve xxxx.south.port.repository.XxxxxMapper.insert-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO XXXXX ( ID, user_id, user_type, label_content, sort, create_user, create_time, update_user, update_time ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ? )
### Cause: java.sql.SQLException: 无效的列类型
; uncategorized SQLException; SQL state [99999]; error code [17004]; 无效的列类型; nested exception is java.sql.SQLException: 无效的列类型
Ⅵ. Environment:
- JDK version : 1.8
- Seata version: client 1.5.1 server 1.6.0
- OS :
- Others:
4条答案
按热度按时间brtdzjyr1#
@malversation Can you provide table structures and complete SQL statements?
0x6upsns2#
@slievrly
table structures
SQL statements
qyyhg6bp3#
It is recommended to provide a text.
kyvafyod4#
@slievrly
Table Structure:
CREATE TABLE T_CUSTOMER_LABEL(
ID NVARCHAR2(32) NOT NULL,
USER_ID NVARCHAR2(36) NOT NULL,
USER_TYPE NVARCHAR2(1) NOT NULL,
LABEL_CONTENT NVARCHAR2(20) NOT NULL,
SORT DECIMAL(24,6),
CREATE_USER NVARCHAR2(20),
CREATE_TIME DATE,
UPDATE_USER NVARCHAR2(20),
UPDATE_TIME DATE,
DELETE_FLAG NVARCHAR2(1) DEFAULT 0,
PRIMARY KEY (ID)
);
COMMENT ON TABLE T_CUSTOMER_LABEL IS '客户标签信息';
COMMENT ON COLUMN T_CUSTOMER_LABEL.ID IS '主键';
COMMENT ON COLUMN T_CUSTOMER_LABEL.USER_ID IS '用户ID';
COMMENT ON COLUMN T_CUSTOMER_LABEL.USER_TYPE IS '用户类型(1-客户 2-游客)';
COMMENT ON COLUMN T_CUSTOMER_LABEL.LABEL_CONTENT IS '标签内容';
COMMENT ON COLUMN T_CUSTOMER_LABEL.SORT IS '排序';
COMMENT ON COLUMN T_CUSTOMER_LABEL.CREATE_USER IS '创建人';
COMMENT ON COLUMN T_CUSTOMER_LABEL.CREATE_TIME IS '创建时间';
COMMENT ON COLUMN T_CUSTOMER_LABEL.UPDATE_USER IS '更新人';
COMMENT ON COLUMN T_CUSTOMER_LABEL.UPDATE_TIME IS '更新时间';
COMMENT ON COLUMN T_CUSTOMER_LABEL.DELETE_FLAG IS '删除标识(0-未删除 1-已删除)';
Execute SQL:
INSERT INTO T_CUSTOMER_LABEL( ID, user_id, user_type, label_content, sort, create_user, create_time, update_user, update_time )
VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
830(String), 20190228112945827266(String), 1(String), gg 111测126试seat21113(String), 3014656(BigDecimal),
20221207021330396369(String), 2023-3-21 10:43:56.672(Timestamp), 2221207021330396369(String), 2023-03-21 10:43:56.672(Timestamp)