IBM / JTOpen

IBM Toolbox for Java, an IBM i communications library
https://ibm.github.io/JTOpen/
Other
62 stars 28 forks source link

JDBC "use block update" still a supported connection property? What does it actually do? #217

Open charles-slc opened 6 days ago

charles-slc commented 6 days ago

In the 7.4 docs, There is

"use block update" - This property allows the toolbox JDBC driver to use a block update mode when updating blocks of data into the database. This is an optimized version of the batch update. Default - false

But it's not show in the 7.5 docs

Looking at the code, it's seems to still be recognized, but a quick glance didn't show any real usage of it.

So first question, is it still a functional properties and if so, then what does it do? I'm guessing it changes something about UPDATE via AddBatch()

jeber-ibm commented 1 day ago

The "use block update" setting allows updates made using PreparedStatement.addBatch() and PreparedStatement.executeBatch() to be sent in a single request to the server. Otherwise, the JDBC driver sends each update as individual requests to the server.

The setting is supported. For the javadoc, its best to refer to the latest JTOpen documentation at https://javadoc.io/doc/net.sf.jt400/jt400/latest/index.html.