Skip to content
New issue

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

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

Already on GitHub? # to your account

Oracle database query blob content is truncated to 32KB #3226

Closed
quwanxing opened this issue Dec 21, 2023 · 0 comments
Closed

Oracle database query blob content is truncated to 32KB #3226

quwanxing opened this issue Dec 21, 2023 · 0 comments
Labels
bug It is confirmed a bug, but don't worry, we'll handle it.

Comments

@quwanxing
Copy link

quwanxing commented Dec 21, 2023

oracle数据库查询blob字段大小只有32K(实际大于1MB),查询结果不完整;
查看数据库驱动的源码发现解决办法:sijms/go-ora#471
在数据库连接的URL中添加:Link: "oracle:XXXX:XXXX@tcp(127.0.0.1:1521)/ORACL?lob fetch=post"
发现oracle数据库连接不上

1. What version of Go and system type/arch are you using?

Go Version: go1.20.6
OS windows 10 64位

2. What version of GoFrame are you using?

GF Version: v2.5.2

3. Can this issue be re-produced with the latest release?

4. What did you do?

在连接数据库的配置中添加Extra属性,值为:lob fetch=post
会触发空格替换为_, lob_fetch=post 生成的连接url异常,
通过配置文件Link添加lob fetch=post,会造成数据库无法连接

5. What did you expect to see?

6. What did you see instead?

@Issues-translate-bot Issues-translate-bot changed the title oracle数据库查询blob内容被截断为32KB Oracle database query blob content is truncated to 32KB Dec 21, 2023
@hailaz hailaz added the bug It is confirmed a bug, but don't worry, we'll handle it. label Dec 22, 2023
hailaz added a commit that referenced this issue Feb 23, 2024
@hailaz hailaz mentioned this issue Feb 23, 2024
@gqcn gqcn closed this as completed in eb0c4b3 Feb 27, 2024
# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
bug It is confirmed a bug, but don't worry, we'll handle it.
Projects
None yet
Development

No branches or pull requests

2 participants