[JDBC] jTDS SQL Server JDBC Driver Properties

jTDS SQL Server JDBC Driver

Property Name	Description	Reqired	Choices	Sample Value
PREPARESQL	Use stored procedures for prepared statements.	false	0 1 2 3	3
SERVERTYPE	The type of database (1 is SQL Server, 2 is Sybase).	true	1 2	1
DATABASENAME	The database name.	false		master
XAEMULATION	Set to false to use the Microsoft Distributed Transaction Coordinator.	false	true false	true
PROGNAME	The program name advertised by the driver.	false		jTDS
LOGINTIMEOUT	The time to wait for a successful login before timing out.	false		0
MACADDRESS	Hex-encoded client MAC address.	false		000000000000
USEJCIFS	Force use of jCIFS library on Windows for connecting via named pipes.	false		false
SSL	Set the SSL level.	false	off request require authenticate	off
PASSWORD	The database password.	false		btc0btc
LOBBUFFER	The amount of LOB data to buffer in memory before caching to disk.	false		32768
TCPNODELAY	Enable/disable TCP_NODELAY	false	true false	true
LASTUPDATECOUNT	Return only the last update count on executeUpdate.	false	true false	true
CACHEMETADATA	Set to true to enable the caching of column meta data for prepared statements.	false	true false	false
SENDSTRINGPARAMETERSASUNICODE	If strings should be sent as unicode values.	false	true false	true
bufferMinPackets	The minimum number of packets per statement to buffer to memory.	false		8
SOCKETKEEPALIVE	Use TCP/IP socket keep alive feature.	false		false
BUFFERDIR	The directory to buffer data to.	false		C:\Users\ADMINI~1\AppData\Local\Temp
DOMAIN	The domain used for authentication.	false
INSTANCE	The database server instance.	false
TDS	The database server protocol.	false	4.2 5.0 7.0 8.0	8.0
WSID	Workstation ID or client host name override. Will be stored in master.dbo.sysprocesses, column hostname.	false
LOGFILE	Set the name of a file for the capture of logging information.	false
bufferMaxMemory	The global buffer memory limit for all connections (in kilobytes).	false		1024
BATCHSIZE	The number of statements to submit at once. Batches are broken up in pieces this large.	false		0
CHARSET	Server character set for non-Unicode character values.	false
SERVERNAME	The database server hostname.	true		192.168.0.88
USECURSORS	Use SQL Server fast forward only result sets for forward only result sets.	false	true false	false
BINDADDRESS	The IP address of the local interface that jTDS should bind to when connecting to a database via TCP/IP.	false
PORTNUMBER	The database server port number.	false		1433
MAXSTATEMENTS	The maximum number of statements to keep open. This is only a target for the cache.	false		500
USELOBS	Map large types (IMAGE and TEXT/NTEXT) to LOBs vs. String/byte[].	false	true false	true
APPNAME	The application name advertised by the driver.	false		jTDS
SOCKETTIMEOUT	The TCP/IP socket timeout value in seconds or 0 for no timeout.	false		0
USENTLMV2	Set to true to send LMv2/NTLMv2 responses when using Windows authentication	false		null
LANGUAGE	The language for server messages.	false
USER	The database user.	false		sa
PACKETSIZE	The network packet size (a multiple of 512).	false		0
NAMEDPIPE	Use named pipes to connect instead of TCP/IP sockets.	false	true false	false
PROCESSID	The process ID reported by the driver.	false		123