Bulk copy metadata should not be cached for temporary tables

[ulfeks]

Driver version

12.8.1.jre11

SQL Server version

Microsoft SQL Server 2019 (RTM-CU19) (KB5023049) - 15.0.4298.1 (X64)
Jan 27 2023 16:44:09
Copyright (C) 2019 Microsoft Corporation Enterprise Edition:
Core-based Licensing (64-bit) on Windows Server 2022 Datacenter 10.0 (Build 20348: ) (Hypervisor)

Client Operating System

Microsoft Windows Server 2022 Datacenter

JAVA/JVM version

22.0.2

Table schema

N/A

Problem description

When using cacheBulkCopyMetadata=true, metadata about temporary tables are also cached. If the temporary tables have unique names the application will eventually run out of memory.

Expected behavior

Do not cache metadata for temporary tables, or make it optional.

Actual behavior

OutOfMemory Exception

Error message/stack trace

N/A

Any other details that can be helpful

N/A

JDBC trace logs

N/A

[lilgreenbird]

hi @ulfeks

Thanks for reporting this we will investigate and work on a fix as soon as possible.