Can we set SQL Server packet size in application properties?

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Is CA TDM using the default packet size based upon the server? Can we add a line in application properties to manage this? 

If yes please give me a sample/example line. 

packetSize int [-1 | 0 | 512..32767] 8000

The network packet size used to communicate with SQL Server, specified in bytes. A value of -1 indicates using the server default packet size. A value of 0 indicates using the maximum value, which is 32767. If this property is set to a value outside the acceptable range, an exception occurs. Important: We do not recommend using the packetSize property when the encryption is enabled (encrypt=true). Otherwise, the driver might raise a connection error. For more information, see the setPacketSize method of the SQLServerDataSource class.

Environment

All supported TDM releases.

Component : CA Test Data Manager - TDM Web Portal

Cause

N/A

Resolution

The packet Size is set by the JDBC driver.

You would need to add this at the end of this property in the application.properties file:

Here is an example:

spring.datasource.url=jdbc:sqlserver://[server]:1433;database=gtrep;PacketSize=1024

And if you need to set it on the connection profiles do it here: