...
If you use an older version of the JDBC Driver, ( e.g. msbase.jar, mssqlserver.jar, msutil.jar ), then the URL for the JDBC connection in the configuration file ./config/factory.ini is different from the newer version sqljdbc.jar.
Older version:
| Code Block |
|---|
db = jdbc -class=com.microsoft.jdbc.sqlserver.SQLServerDriver jdbc:microsoft:sqlserver://localhost:1433; selectMethod=Cursor;databaseName=scheduler -user=scheduler -password=scheduler |
Newer version:
| Code Block |
|---|
db = jdbc -class=com.microsoft.sqlserver.jdbc.SQLServerDriver jdbc:sqlserver://localhost:1433; sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=scheduler -user=scheduler -password=scheduler |
Please regard the different classnames and use of lowercase letters in the value "cursor".