Batch Size and Fetch Size in Spring Boot JDBC client

Question

I am exploring JDBC client of spring boot, and looking options to set batch size and fetch size.

But can not find any document/article explaining the same.

Is there a way preferbly in properties file to instruct spring boot to use it?

talex · Accepted Answer · 2024-11-17 13:08:51Z

0

"Is there a way preferbly in properties file to instruct spring boot to use it?"

Short answer is NO.

Long answer you need to do it manually for each query you execute.

Also there is no universal way to do it. Solution will be different for different DB.

answered Nov 17, 2024 at 13:08

talex

20.8k3 gold badges34 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Yash Over a year ago

I am executing query like this - jdbcClient.sql("myQuery").param("someParam).query(new MyRowMapper()).optional();...where to set batchsize and fetch size?

talex Over a year ago

Inside myQuery.

Collectives™ on Stack Overflow

Batch Size and Fetch Size in Spring Boot JDBC client

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related