Microsoft SQL Server (jTDS)
Connector Configuration
SQL Server connector requires the following parameters:
For the official Microsoft JDBC driver:
host (default: localhost)
port (no default; for connection to a Microsoft SQL Server with dynamic port allocation configured, instanceName needs to be provided via jdbc-properties)
db
user-name
password (default: empty)
driver (default: com.microsoft.sqlserver)
jdbc-properties (arbitrary extra properties)
min-pool-size (default: 2)
max-pool-size (default: 70)
For the open source jTDS driver:
host (default: localhost)
port (default: 1433)
db
user-name
password (default: empty)
driver (default: jtds)
jdbc-properties (arbitrary extra properties)
min-pool-size (default: 2)
max-pool-size (default: 70)
Translator Properties Specific to SQL Server Connector
Name | Description | Default Value |
maxColumnNameLength | The maximum length of a column name. The default value relies on underlying DBMS. Five chars of defined maximum length will be reserved for internal purposes and cannot be used for column-identifier. | 128 |
maxTableNameLength | The maximum length of a table name. The default value relies on underlying DBMS. | 128 |