[unixODBC-support] Support for batch insert
nick.gorham at easysoft.com
Fri Jan 11 18:16:15 GMT 2008
Ramin Javanbakht wrote:
>Thanks for your quick response. If I use arrays of parameters in ODBC world,
>is it as efficient as JDBC batch where database server is contacted only
>once to submit the batch info?
>My understanding of JDBC batch mode is that the as long as the batch is
>being built (statement.addBatch() is executed), the database server is not
>used. Only when the statement.executeBatch() is called, the database server
>is used and the batch info is submitted.
>Assuming that is the right understanding, is that how arrays of parameters
>work in ODBC world?
Should be, nothing happens untill the SQLExecute is called.
More information about the unixODBC-support