Tigase configuration - init.properties

Configuration of the MS SQL Server follows general database convention. For MS SQL Support --user-db needs to be set to sqlserver:

--user-db=sqlserver

and the --user-db-uri needs to point to the configured database:

--user-db-uri=jdbc:[jtds:]sqlserver://db_hostname:port[;property=val]

where any number of additional parameters can (and should) consist of:

  • databaseName - name of the database
  • user - username configured to access database
  • password - password for the above username
  • schema - name of the database schema
  • lastUpdateCount - 'false' value causes all update counts to be returned, including those returned by server triggers

Example:

--user-db-uri=jdbc:sqlserver://hostname:1433;databaseName=tigasedb;user=tigase;password=tigase12;schema=dbo;lastUpdateCount=false