Skip to main content
Skip table of contents

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.