tx-lcn icon indicating copy to clipboard operation
tx-lcn copied to clipboard

TX-LCN支持oracle数据库吗?有报错呢?

Open qiangzi201907 opened this issue 5 years ago • 5 comments

2019-11-13 21:13:29.594 ERROR 5932 --- [io-12002-exec-5] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: Error getting generated key or setting result to parameter object. Cause: java.sql.SQLException: 未执行语句句柄 ; uncategorized SQLException; SQL state [99999]; error code [17144]; 未执行语句句柄; nested exception is java.sql.SQLException: 未执行语句句柄] with root cause

java.sql.SQLException: 未执行语句句柄

qiangzi201907 avatar Nov 13 '19 13:11 qiangzi201907

mysql的数据源改为oracle,其他没改动,互调就有问题,单独点报错,请问这个怎么解决呢?

linhaibing001 avatar Nov 18 '19 07:11 linhaibing001

@LcnTransaction使用方式不同导致的,是可以支持oracle的

linhaibing001 avatar Nov 18 '19 10:11 linhaibing001

现在用Oracle的已经很少了

yizhishang avatar Nov 18 '19 10:11 yizhishang

你们知道数据源mysql类型bigint转oracle转什么类型吗?number 的话,TC日志报错,java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.Long

linhaibing001 avatar Nov 18 '19 12:11 linhaibing001

驱动要6以上,问题解决

发自我的iPhone

------------------ 原始邮件 ------------------ 发件人: linhaibing001 <[email protected]> 发送时间: 2019年11月18日 20:42 收件人: codingapi/tx-lcn <[email protected]> 抄送: qiangzi201907 <[email protected]>, Author <[email protected]> 主题: 回复:[codingapi/tx-lcn] TX-LCN支持oracle数据库吗?有报错呢? (#461)

你们知道数据源mysql类型bigint转oracle转什么类型吗?number 的话,TC日志报错,java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.Long

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or unsubscribe.

qiangzi201907 avatar Nov 21 '19 03:11 qiangzi201907