Yeah, running both, I believe without the class string it uses the non-Microsoft jTDS version. Although I could be wrong on that.
We're running with versions 5.1.0.34 and version 4 in a Docker container...
this.datasources[Request.DB.DSN.Reports] = {
type: "MSSQL",
host: Request.DB.Host,
database: Request.DB.DB.Reports,
port: 1433,
username: Request.DB.DB.Username,
password: Request.DB.DB.Password,
custom: {
characterEncoding: "UTF-8",
useUnicode: true,
connectionTimeout: 5,
validate: true,
clob: true
}
}
and some with class: "com.microsoft.jdbc.sqlserver.SQLServerDriver" added
I also have some defined as:
this.datasources[Request.DB.DSN.Reports] = {
class: "com.microsoft.jdbc.sqlserver.SQLServerDriver",
connectionString: "jdbc:sqlserver://" & Request.DB.Host & ":1433;DatabaseName=" & Request.DB.DB.Reports & ";SelectMethod=direct",
username: Request.DB.Username,
password: Request.DB.PasswordEnc,
clob:true,
useUnicode: true,
connectionTimeout:5,
characterEncoding: "UTF-8",
validate: true,
custom: {
characterEncoding: "UTF-8",
useUnicode: true,
connectionTimeout: 5,
validate: true,
clob: true
}
};
At some point I'll update everything to a standard... But at the moment those are the configurations I'm using.
And confirm they are in the pseudo constructor portion of Application.cfc an not onApplication/RequestStart functions.