为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM Database Server 64 V8
DB Version: 0x7000c
【操作系统】:cat /proc/version
Linux version 3.10.0-1160.21.1.el7.x86_64 (mockbuild@kbuilder.bsys.centos.org) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-44) (GCC) ) #1 SMP Tue Mar 16 18:28:22 UTC 2021
【CPU】:cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 85
model name : Intel® Xeon® Gold 5120 CPU @ 2.20GHz
stepping : 4
microcode : 0x200005e
cpu MHz : 2194.843
cache size : 19712 KB
physical id : 0
siblings : 1
core id : 0
cpu cores : 1
apicid : 0
initial apicid : 0
fpu : yes
fpu_exception : yes
cpuid level : 22
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon nopl xtopology tsc_reliable nonstop_tsc eagerfpu pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm 3dnowprefetch invpcid_single ssbd ibrs ibpb stibp fsgsbase tsc_adjust bmi1 hle avx2 smep bmi2 invpcid rtm mpx avx512f avx512dq rdseed adx smap clflushopt clwb avx512cd avx512bw avx512vl xsaveopt xsavec arat pku ospke md_clear spec_ctrl intel_stibp flush_l1d arch_capabilities
bogomips : 4389.68
clflush size : 64
cache_alignment : 64
address sizes : 43 bits physical, 48 bits virtual
power management:
processor : 1
vendor_id : GenuineIntel
cpu family : 6
model : 85
model name : Intel® Xeon® Gold 5120 CPU @ 2.20GHz
stepping : 4
microcode : 0x200005e
cpu MHz : 2194.843
cache size : 19712 KB
physical id : 2
siblings : 1
core id : 0
cpu cores : 1
apicid : 2
initial apicid : 2
fpu : yes
fpu_exception : yes
cpuid level : 22
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon nopl xtopology tsc_reliable nonstop_tsc eagerfpu pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm 3dnowprefetch invpcid_single ssbd ibrs ibpb stibp fsgsbase tsc_adjust bmi1 hle avx2 smep bmi2 invpcid rtm mpx avx512f avx512dq rdseed adx smap clflushopt clwb avx512cd avx512bw avx512vl xsaveopt xsavec arat pku ospke md_clear spec_ctrl intel_stibp flush_l1d arch_capabilities
bogomips : 4389.68
clflush size : 64
cache_alignment : 64
address sizes : 43 bits physical, 48 bits virtual
power management:
【问题描述】*:达梦数据库使用docker安装,使用springboot+mybatisPlus访问数据库;插入text数据比较大,约2MB,插入成功,使用客户端能够查询成功;但java使用驱动查询index out of range;
详细堆栈信息如下:
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
at com.sun.proxy.$Proxy226.query(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
... 120 common frames omitted
Caused by: java.lang.RuntimeException: index out of range
at dm.jdbc.b.a.a.f(Buffer.java:791)
at dm.jdbc.b.a.a.k(Buffer.java:772)
at dm.jdbc.b.a.a.readLong(Buffer.java:712)
at dm.jdbc.b.b.k.w(GET_LOB_LEN.java:63)
at dm.jdbc.b.b.k.q(GET_LOB_LEN.java:1)
at dm.jdbc.b.b.o.C(MSG.java:501)
at dm.jdbc.b.a.a(DBAccess.java:219)
at dm.jdbc.b.a.a(DBAccess.java:918)
at dm.jdbc.desc.AbstractLob.do_length(AbstractLob.java:180)
at dm.jdbc.driver.DmdbClob.length(DmdbClob.java:409)
at com.alibaba.druid.filter.FilterChainImpl.clob_length(FilterChainImpl.java:4899)
at com.alibaba.druid.filter.FilterAdapter.clob_length(FilterAdapter.java:2681)
at com.alibaba.druid.filter.FilterChainImpl.clob_length(FilterChainImpl.java:4897)
at com.alibaba.druid.proxy.jdbc.ClobProxyImpl.length(ClobProxyImpl.java:88)
at org.apache.ibatis.type.ClobTypeHandler.toString(ClobTypeHandler.java:59)
at org.apache.ibatis.type.ClobTypeHandler.getNullableResult(ClobTypeHandler.java:41)
at org.apache.ibatis.type.ClobTypeHandler.getNullableResult(ClobTypeHandler.java:28)
at org.apache.ibatis.type.BaseTypeHandler.getResult(BaseTypeHandler.java:81)
... 148 common frames omitted
【dm驱动】配置信息
数据库查询正常,程序查询报错,有没有可能是你java程序中用来存取test内容的变量定义长度不够导致的下标越界。