2 Replies Latest reply on Jan 2, 2018 2:45 PM by Erik van Roon

    Errors in sql.bat

    Erik van Roon

      For those running into the same problems I found:



      SQLcl which was released on December 22, 2017 has a couple of problems in the shipped sql.bat file for windows.


      Running it results in:

      • Message: "Environment variable echo on not defined"
      • Message: "The input line is too long"
      • SQLcl does'n start



      comment-out 4 lines in the supplied [sqlcl]\bin\sql.bat

      (Add "rem " to the beginning of eachof these lines)

      • Line 37
        SET DEBUG=-agentlib:jdwp=transport=dt_socket,server=y,suspend=y,address=8000
      • Line 47
        set echo on

        This line causes the 'environment variable error'
        If you really want to set echo on, turn it into:
        @echo on
        But then, be prepared for lots of junk echoed to screen

      • Line 77 and Line 88
        Two comments, both starting with "<!-- " and ending with "-->"

        These redirection symbols (< and >) cause the "input line is too long"