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 |