Skip to main content

Spring

See also: Spring Batch

Log Levelsโ€‹

# Default logging level
logging.level.root=INFO
# Specify logging level for a whole package
logging.level.<package>=DEBUG
# Specify logging level for a class
logging.level.<package>.<class>=WARN

###
# Log Groups
###
# Define a group
logging.group.foo=<package>, <package>, <package>.<class>
# Set logging level for the group
logging.level.foo=DEBUG

MSSQL Connectivity with NTLM on Non-Windows Hostsโ€‹

You need the following pieces of information:

  • Username (in user@domain format)
  • Password
  • Server host and port (usually 1433)
  • Database name
  • Server SPN
spring.datasource.url=jdbc:sqlserver://<host>:<port>;databaseName=<dbname>;authenticationScheme=NTLM;integratedSecurity=true;serverSpn=<spn>
spring.datasource.username=<username>
spring.datasource.password=<password>
  • You may also need to append trustServerCertificate=true to spring.datasource.url if you get an error like unable to find valid certification path to requested target (or fix the certificate path properly).
  • Unless you have a good reason to (you probably donโ€™t), append encrypt=true to the data source URL.

Validationโ€‹