Details
-
Feature
-
Status: Released (View Workflow)
-
Minor
-
Resolution: Fixed
-
None
Description
Current Situation
- JobScheduler Master makes use of a number of JDBC Drivers depending on the DBMS in use.
- For Microsoft JDBC Drivers 6.x to 7.x for SQL Server 14.0 (2017) in a single case the following error is observed:
.Exception Z-JAVA-105 Java exception com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from ntext to AsciiStream is unsupported., method=getAsciiStream
- This error is due to the fact that datatypes are used (ntext) that suggest to hold unicode values when in fact the getAsciiStream method is called. This is a compatibility issue that is raised when running JobScheduler Master in a cluster. Use of the jTDS JDBC Driver that ships with JobScheduler prevents this problem, however, we discourage use of the jTDS JDBC Driver that is no longer under development.
Desired Behavior
- The getAsciiStream method is replaced by getCharacterStream.
- This change applies to use of any JDBC Drivers with JobScheduler Master.