setQueryTimeout not works when bulk copy to Azure Data Warehouse

[tilumi]

Driver version

7.0.0.jre8

SQL Server version

Azure SQL Data Warehouse Gen1

Client Operating System

Ubuntu

JAVA/JVM version

1.8

Problem description

1. I use the method mention here: https://github.com/Microsoft/mssql-jdbc/wiki/How-to-enable-Bulk-Copy-API-for-batch-insert-operations to bulk copy data to Data Warehouse

2. I use insertStatement.setQueryTimeout(10 * 60) to set timeout.

3. I don't specify timeout properties on connection string.

4. Expected behaviour: Timeout exception will be thrown after 10 mins

5. Actual behaviour:
   Timeout exception thrown only after 1 min, like this:
   

6. Error message/stack trace:

2018-09-18 06:54:33 Executor task launch worker for task 486 ERROR Executor:91 - Exception in task 162.0 in stage 9.0 (TID 486)
java.sql.BatchUpdateException: The query has timed out.
	at com.shaded.com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:2022)
	at com.microsoft.antispam.outputWriters.SQLDataWarehouseWriter$$anonfun$5$$anonfun$apply$1$$anonfun$6.apply(SQLDataWarehouseWriter.scala:89)
	at com.microsoft.antispam.outputWriters.SQLDataWarehouseWriter$$anonfun$5$$anonfun$apply$1$$anonfun$6.apply(SQLDataWarehouseWriter.scala:89)
	at scala.util.Try$.apply(Try.scala:192)

[peterbae]

Hi @tilumi, thanks for reporting this issue. The team has confirmed that this was not the intended behavior, and we'll be pushing a fix for this soon. We will let you know when we have an update.

[tilumi]

Ok, thanks a lot

[peterbae]

Hi @tilumi, I've made PR #817 to fix this issue. In the meantime, I've created this jar for you to use. Please let me know if this jar solves your problem.

issue-803-fix-jre8.zip

[peterbae]

Fixed in #817, closing issue.