Redian新闻
>
what is the size limitation of Oracle JDBC Statement?
avatar
what is the size limitation of Oracle JDBC Statement?# Database - 数据库
h*r
1
Want to know how large is the limiation of one complete SQL
insert string can be place into a JDBC Statement and can
insert the big record successfully. I tried up to 13K, JDBC
still can accept it. Does some experienced guru can tell me
what is the size limitation for insert or update SQL string
JDBC can accept it?
Thanks a lot.
avatar
m*n
2
if you use CLOB type in your table it's 4G

【在 h****r 的大作中提到】
: Want to know how large is the limiation of one complete SQL
: insert string can be place into a JDBC Statement and can
: insert the big record successfully. I tried up to 13K, JDBC
: still can accept it. Does some experienced guru can tell me
: what is the size limitation for insert or update SQL string
: JDBC can accept it?
: Thanks a lot.

avatar
h*r
3
Thanks, CLOB is up to 2G, I know this, but CLOB is use
prepare/store/execute
to insert, not using statement directly with a 2G string.
actually I want to
know what is the size limit of statement.

【在 m******n 的大作中提到】
: if you use CLOB type in your table it's 4G
相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。