seata AT mode oracle some dateTypes not support

fdx2calv  于 2022-11-05  发布在  Oracle
关注(0)|答案(1)|浏览(179)
  • I have searched the issues of this repository and believe that this is not a duplicate.

Ⅰ. Issue Description

AT模式下,oracle的某些时间类型支持有问题
问题一:
ORACLE中的TIMESTAMP类型也会Map成和date类型一样的TIMESTAMP一个类型,导致序列化失败

问题二:
ORACLE的TIMESTAMP(3) WITH TIME ZONE类型会被解析成TIMESTAMPTZ对象,导致无法序列化报错

解决方案:可以考虑将TIMESTAMPTZ对象转换成OffsetDateTime尝试解决此问题

问题三:
ORACLE的TIMESTAMP(3) WITH LOCAL TIME ZONE类型会被解析成TIMESTAMPLTZ对象,导致无法序列化报错

解决方案:可以考虑将TIMESTAMPLTZ对象转换成OffsetDateTime尝试解决此问题

Ⅱ. Describe what happened

If there is an exception, please attach the exception trace:

Just paste your stack trace here!

Ⅲ. Describe what you expected to happen

Ⅳ. How to reproduce it (as minimally and precisely as possible)

  1. xxx
  2. xxx
  3. xxx

Ⅴ. Anything else we need to know?

Ⅵ. Environment:

  • JDK version : 1.8
  • Seata version: develop
  • OS : mac OS
  • ORACLE version 11
  • Others:

相关问题