Package scriptella.driver.mssql

package scriptella.driver.mssql
Microsoft SQL Server Driver Adapter for Scriptella.

See Overview of JDBC package for a description of common features and connection properties.

See the core database compatibility matrix for the current validation target and status.

Note: The adapter uses the current Microsoft JDBC Driver for SQL Server. Current driver versions enable TLS encryption by default and validate the server certificate by default. Keep encrypt=true and trustServerCertificate=false for production connections, and use a server name that matches the certificate. Configure the JVM trust store or the driver's trustStore properties when the certificate is not already trusted. Setting trustServerCertificate=true disables certificate validation and is suitable only for controlled local tests.

General information

Driver class:scriptella.driver.mssql.Driver
JDBC driver class:com.microsoft.sqlserver.jdbc.SQLServerDriver
URL:jdbc:sqlserver://host:1433;databaseName=database
Runtime dependencies: Microsoft JDBC Driver for SQL Server (mssql-jdbc-VERSION.jre11.jar for JDK 17), supplied through the connection classpath.

Driver Specific Properties

Name Description Required

Examples

    <connection id="c1" driver="mssql"
                url="jdbc:sqlserver://db.example.com:1433;databaseName=test;encrypt=true;trustServerCertificate=false"
                user="username" password="password"
                classpath="lib/mssql-jdbc-VERSION.jre11.jar">
    </connection>

See the Microsoft JDBC encryption guidance for trust-store configuration details.

  • Classes
    Class
    Description
    Driver
    Scriptella Adapter for Microsoft SQL Server database JDBC driver.