Lets turn on prepared statements for addl DBs and see if we also gain performance improvements.
In addition to Sybase BCP Import and Oracle, the following databases now use prepared statements when the Transaction Type is Batch.
Notes to QA:
- Test all possible data types that each database server supports.
- If you run into any errors, verify whether the same errors occur when the Transaction Type is Full.
- When reporting a problem or error, please create a new issue rather than re-opening this issue, and include the CREATE TABLE statement and the data used for import.
Starting with build 15.0.0-dev-290, SQL Server also uses prepared statements when the Transaction Type is Batch (issue #11108).
Notes to QA:
- Test all possible data types.
- If you run into any errors, verify whether the same errors occur when the Transaction Type is Full.
- When reporting a problem or error, please create a new issue rather than re-opening this issue, and include the CREATE TABLE statement and the data used for import.
Starting with build 15.0.0-dev-290, SQL Server also uses prepared statements when the Transaction Type is Batch (issue #11108).
Notes to QA:
- Test all possible data types.
- If you run into any errors, verify whether the same errors occur when the Transaction Type is Full.
- When reporting a problem or error, please create a new issue rather than re-opening this issue, and include the CREATE TABLE statement and the data used for import.
Issue #10957 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build ADS 15.0.0-dev-57 |
No time estimate |
2 issue links |
relates to #11850
Issue #11850Retrofit Netezza Batch Import to V14 |
relates to #11108
Issue #11108SQL Server JTDS Driver - PreparedStatement.executeBatch returns error |
In addition to Sybase BCP Import and Oracle, the following databases now use prepared statements when the Transaction Type is Batch.
Notes to QA:
- Test all possible data types that each database server supports.
- If you run into any errors, verify whether the same errors occur when the Transaction Type is Full.
- When reporting a problem or error, please create a new issue rather than re-opening this issue, and include the CREATE TABLE statement and the data used for import.