[unixODBC-support] Support for batch insert

Nick Gorham nick.gorham at easysoft.com
Fri Jan 11 18:16:15 GMT 2008


Ramin Javanbakht wrote:

>Nick,
>
>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.

-- 
Nick Gorham
Easysoft Limited
http://www.easysoft.com, http://www.unixODBC.org




More information about the unixODBC-support mailing list