Driver version

7.0.0 Fails
4.0.0 OK

SQL Server version

Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 (X64)
Apr 29 2016 23:23:58
Copyright (c) Microsoft Corporation
Developer Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 (Build 9600: )

Client Operating System

Windows 10

JAVA/JVM version

Oracle JVM 1.8.0_181

Table schema

X INTEGER

Problem description

1. Expected behaviour: I should be able to get parameter metadata for inserts into temp table.
2. Actual behaviour: Invalid object name '#test_jdbc_insert'

The problem appears to be from the use of sp_describe_undeclared_parameters. The driver appears to be throwing from this exec sp_describe_undeclared_parameters @tsl=N'insert into [tempdb].[#test_insert_jdbc] values(@P0)'. This is understandable since sp_describe_undeclared_parameters doesn't support temp tables. But does this mean that getParameterMetadata doesn't work for statements against temp tables by design? This scenario works using sqljdbc 4.0.0.

Reproduction code

Connection connect = DriverManager.getConnection(connectMssql);
Statement statement = connect.createStatement();
statement.execute("create table [#test_jdbc_insert] (x int)");
PreparedStatement pstmt = connect.prepareStatement("insert into [#test_jdbc_insert] (x) values(?)");
System.out.println(pstmt.getParameterMetaData());