Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-2606

Derby should print the parameters to failed statements to the derby.log when it logs the error

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.3.1.4
    • 10.1.3.2, 10.2.2.1, 10.3.1.4
    • Services
    • None

    Description

      It would be good if when derby dumped an error to derby.log it printed the parameters for the failed statement. Currently the default behaviour is that only the statement text will print. Users have to set derby.language.logStatementText=true if they want to see the parameters. It would be useful if any errors included the parameters as well as the statement text.

      To reproduce

      put derby.stream.error.logSeverityLevel=0 in your derby.properties and run this script:

      connect 'jdbc:derby:wombat;create=true';
      create table t (i int);
      prepare p as 'insert into t values';

      execute p using 'values(1)';
      execute p using 'values(10000000000000000000000000000000000000000000)';

      Attachments

        1. d2602.java
          2 kB
          Katherine Marsden
        2. DERBY_2606_diff.txt
          0.6 kB
          Katherine Marsden
        3. DERBY_2606_stat.txt
          0.1 kB
          Katherine Marsden

        Activity

          People

            kmarsden Katherine Marsden
            kmarsden Katherine Marsden
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: