Uploaded image for project: 'JS - JobScheduler'
  1. JS - JobScheduler
  2. JS-1883

Support use of character stream data with JDBC Drivers

    XMLWordPrintable

Details

    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.

      Attachments

        Activity

          People

            jz Joacim Zschimmer
            ap Andreas Püschel
            Andreas Püschel Andreas Püschel
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: