Uploaded image for project: 'JITL - JobScheduler Integrated Template Library'
  1. JITL - JobScheduler Integrated Template Library
  2. JITL-696

SQLPLUSJob should not throw a NullPointerException if SQL statements include errors

    XMLWordPrintable

Details

    • Fix
    • Status: Released (View Workflow)
    • Minor
    • Resolution: Fixed
    • 2.3.1
    • 2.4.0
    • None

    Description

      Current Situation

      • The JITL SQLPLUSJob throws a NullPointerException if the SQL statements to execute includes errors, for example when executing the following SQL statements from the command argument
        select 1 from dual; exit;
      • The above SQL statement is wrong as it includes two statements in the same line. The correct syntax is:
        select 1 from dual; 
        exit;
        
      • The above wrong SQL statements result in the error message:
        msg=java.lang.NullPointerException

      Desired Behavior

      • The JITL SQLPLUSJob should show the correct error message provided by SQLPlus if the script to execute includes errors.
      • For the above example the correct error message is:
        SQL Exception raised. Msg='ORA-00933: SQL command not properly ended'

      Attachments

        Activity

          People

            ur Uwe Risse
            ur Uwe Risse
            Divyani Rathore Divyani Rathore
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: