Closed wangxiaochao closed 2 months ago
查看表内是否有主键,是否建立了undo_log表
According to the ojdbc8 19.3.0.0 version driver source code I found, the parameter input error may be caused by the obtained schema or table name not meeting the specification. You can debug the specific problem in your own environment. The relevant code is located in io.seata.rm.datasource.sql.struct.cache.OracleTableMetaCache; or provide more detailed information to help us troubleshoot, such as database version, table structure, etc., and pay attention to removing sensitive information.
由于太久没有相关回复,我暂时先关闭这个issue Since there is no relevant reply for too long, I will close this issue for the time being.
JDBC Connection [io.seata.rm.datasource.ConnectionProxy@74a0573e] will not be managed by Spring
==> Preparing: update sy_ythpt_ydchdqyjl SET ywclzt = ?, shzt = ?, utime = ?, slr_id = ?, slr_name = ?, sltime = ? where ywbh = ?
==> Parameters: 02(String), 2(Integer), 2024-07-11T13:46:13.294(LocalDateTime), KH010620240417000006(String), 廉龙昌(String), 2024-07-11T13:46:13.294(LocalDateTime), 05621300202407110003(String)
2024-07-11 13:46:13.346 ERROR 1 --- [io-29001-exec-7] i.s.r.d.s.s.c.AbstractTableMetaCache : get table meta of the table
sy_ythpt_ydchdqyjl
error: Invalid argument(s) in calljava.sql.SQLException: Invalid argument(s) in call
2024-07-11 13:46:13.362 ERROR 1 --- [io-29001-exec-7] i.s.r.d.exec.AbstractDMLBaseExecutor : execute executeAutoCommitTrue error:[xid:10.10.30.126:8091:5864220163728211998] Get table meta failed, please check whether the table
sy_ythpt_ydchdqyjl
exists.io.seata.common.exception.ShouldNeverHappenException: [xid:10.10.30.126:8091:5864220163728211998] Get table meta failed, please check whether the table
sy_ythpt_ydchdqyjl
exists.org.springframework.jdbc.UncategorizedSQLException:
Error updating database. Cause: java.sql.SQLException: io.seata.common.exception.ShouldNeverHappenException: [xid:10.10.30.126:8091:5864220163728211998] Get table meta failed, please check whether the table
sy_ythpt_ydchdqyjl
exists.The error may exist in com/jzkj/z/db/dao/SyYthptYdchdqyjlMapper.xml
The error may involve com.jzkj.z.db.dao.SyYthptYdchdqyjlMapper.updateByPrimaryKeySelective-Inline
The error occurred while setting parameters
SQL: update sy_ythpt_ydchdqyjl SET ywclzt = ?, shzt = ?, utime = ?, slr_id = ?, slr_name = ?, sltime = ? where ywbh = ?
Cause: java.sql.SQLException: io.seata.common.exception.ShouldNeverHappenException: [xid:10.10.30.126:8091:5864220163728211998] Get table meta failed, please check whether the table
sy_ythpt_ydchdqyjl
exists.; uncategorized SQLException; SQL state [null]; error code [0]; io.seata.common.exception.ShouldNeverHappenException: [xid:10.10.30.126:8091:5864220163728211998] Get table meta failed, please check whether the table
sy_ythpt_ydchdqyjl
exists.; nested exception is java.sql.SQLException: io.seata.common.exception.ShouldNeverHappenException: [xid:10.10.30.126:8091:5864220163728211998] Get table meta failed, please check whether the tablesy_ythpt_ydchdqyjl
exists.Ⅵ. Environment:
java -version
): 1.8uname -a
):