mailweb.opengauss.org
Manage this list

Keyboard Shortcuts

Thread View

  • j: Next unread message
  • k: Previous unread message
  • j a: Jump to all threads
  • j l: Jump to MailingList overview

Community

Threads by month
  • ----- 2025 -----
  • May
  • April
  • March
  • February
  • January
  • ----- 2024 -----
  • December
  • November
  • October
  • September
  • August
  • July
  • June
  • May
  • April
  • March
  • February
  • January
  • ----- 2023 -----
  • December
  • November
  • October
  • September
  • August
  • July
  • June
  • May
  • April
  • March
  • February
  • January
  • ----- 2022 -----
  • December
  • November
  • October
  • September
  • August
  • July
  • June
  • May
  • April
  • March
  • February
  • January
  • ----- 2021 -----
  • December
  • November
  • October
  • September
  • August
  • July
  • June
  • May
  • April
  • March
  • February
  • January
  • ----- 2020 -----
  • December
  • November
  • October
  • September
  • August
  • July
  • June
  • May
  • April
  • March
community@opengauss.org

September 2024

  • 3 participants
  • 2 discussions
oracle迁移至opengauss数据集列名大小写问题
by mahaibo2004 26 Sep '24

26 Sep '24
您好,我有个项目从Oracle迁移至opengauss,该项目为java项目,采用框架spring+mybatis。 项目中好多SQL在mybatis中返回数据类型为java.util.Map,这些SQL以前查询Oracle,返回数据集列名为大写,迁移至opengauss后,返回数据集列名变小写,导致原应用程序无法正常读取结果集。 如SQL:select col1, col2 from tab 查询Oracle数据表返回类似以下数据集: [{"COL1":"xx","COL2":"xx"} ...] 迁移至opengauss后返回类似下数据集: [{"col1":"xx","col2":"xx"} ...] 有个办法是,通过增加列别名实现返回数据集列名为大写,将SQL改为以下格式: select col1 as "COL1", col2 as "COL2" from tab 采用该方法,考虑到项目中SQL太多,全部修改需要很大工作量。 还有办法是添加Mybatis新的ObjectWrapperFactory派生类,将Map中小写key改为大写key,但该方法会影响到类似以下SQL结果集: select col1 as "col1", col2 as "col1" from tab 该方法会将这些SQL结果集列名全部变为大写,导致原程序无法正常读取数据。 想问一下,是否有快捷办法,让mybatis读取opengauss,如果SQL中未指定带双引号别名,返回的java.util.Map结果集中,所有列名变为大写?
2 5
0 0
在鲲鹏920安装openGauss 5.0.3 (LTS)时python执行一直是100%
by 82560651 09 Sep '24

09 Sep '24
&nbsp; [root@yzcdc script]# lscpu Architecture:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; aarch64 CPU op-mode(s):&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 64-bit Byte Order:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Little Endian CPU(s):&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 64 On-line CPU(s) list:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0-63 Thread(s) per core:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 Core(s) per socket:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 32 Socket(s):&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 NUMA node(s):&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 Vendor ID:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;HiSilicon Model:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0 Model name:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Kunpeng-920 Stepping:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0x1 CPU max MHz:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2600.0000 CPU min MHz:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200.0000 BogoMIPS:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200.00 L1d cache:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4 MiB L1i cache:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4 MiB L2 cache:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 32 MiB L3 cache:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 64 MiB ============================= [root@yzcdc script]# cat /etc/os-release&nbsp; NAME="FusionOS" VERSION="22" ID="fusionos" ID_LIKE="openEuler" VERSION_ID="22.0.4" PRETTY_NAME="FusionOS 22" ANSI_COLOR="0;31 ============================= 在arm架构鲲鹏920的fusionos 22系统安装opengauss5.0.3时当执行到gs_preinstall脚本时一直卡在那里,top显示cpu100%也无报错。已经安装python3&nbsp;paramiko模块,问题依旧。假如加入参数--unused-third-party会提示系统和软件架构不匹配,但实际上是匹配的。 Traceback (most recent call last): &nbsp; File "./gs_preinstall", line 30, in <module&gt; &nbsp; &nbsp; check_os_and_package_arch() &nbsp; File "/opt/openGauss/script/gspylib/common/CheckPythonVersion.py", line 67, in check_os_and_package_arch &nbsp; &nbsp; "Error: os architecture is %s, package architecture is %s" % (os_arch, package_arch)) Exception: System and software package architecture mismatch. Error: os architecture is aarch64, package architecture is &nbsp; 不知是否有其他同学碰到相同的问题。还请指教。 时间不等人 82560651(a)qq.com &nbsp;
1 0
0 0

HyperKitty Powered by HyperKitty