Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
I am investigating issue #10957 to improve the performance of Import using prepared statements. We have code that uses prepared statements for Import and it is currently turned on for Sybase and Oracle only. We are trying to turn on this option for other databases.
When testing with SQL Server 2000, using prepared statements is ok. However, when testing with SQL Server 2008 and 2012, the code fails with the following error:
The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 3 ("........."): Data type 0x04 is unknown.
The attached source file, MSSQLPreparedStatement.java, demonstrates the problem.
Dear Tariq,
Have sent you a build. Please let me know if it solves this issue.
best regards,
Vikram
Checked in jtds.jar and jtds-src.jar.
We now use prepared statements for batch import for SQL Server.
Checked in jtds.jar and jtds-src.jar.
We now use prepared statements for batch import for SQL Server.
Related issues with Batch Import are logged as new issues.
Related issues with Batch Import are logged as new issues.
Issue #11108 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build ADS 15.0.0-dev-290 |
| No time estimate |
1 issue link |
relates to #10957
Issue #10957Improve Import Performance |
Dear Tariq,
Have sent you a build. Please let me know if it solves this issue.
best regards,
Vikram