TDM: Can we set SQL Server packet size in application properties?

book

Article ID: 206140

calendar_today

Updated On:

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.

Cause

N/A

Environment

Release : 4.9

Component : CA Test Data Manager - TDM Web Portal

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://lvntest013157.bpc.broadcom.net:1433;database=gtrep;PacketSize=1024

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