Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ShellUtil Java 方法返回的 String 转换到 varchar2 类型时若数据过长则无法接收到响应 #68

Open
peter5he1by opened this issue Jun 20, 2023 · 2 comments
Labels
bug Something isn't working

Comments

@peter5he1by
Copy link

peter5he1by commented Jun 20, 2023

系统环境

  • Win10 x64
  • JDK 8

软件版本

  • Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

Bug 详细描述

Oracle varchar2 数据类型的长度是有限的(我没有细看 Oracle 版本,记得是 11g),ShellUtil中的方法执行返回的 String 如果太长会发生错误,实战中的缓解措施是 重复执行同一个命令,在 ShellUtil 中一段一段地把结果读出来的。

暂时还没想到好的解决办法,可以考虑用 GLOB(但是 Oracle 的驱动把这个接口标记为废弃了)。

@peter5he1by peter5he1by added the bug Something isn't working label Jun 20, 2023
@Ch1ngg
Copy link
Contributor

Ch1ngg commented Jul 17, 2023

收到,我也得搭建环境来复现一下,Oracle 太麻烦,应该没那么快

@peter5he1by
Copy link
Author

师傅看下PR呗,Oracle11g的一个小bug我也修了下。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants