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

Parameter in one of the error messages is not replaced by the desired value.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.1.1.0
    • 10.1.1.0, 10.2.1.6
    • JDBC
    • None

    Description

      In one of the error messages the parameter does not get replaced with the actual value to make the message meaningful.
      Here is a sample message:

      ===> XJ084=Column does not correspond to a column in the base table. Cant issue

      {0} on this column.

      More info:

      Table:

      ij version 10.1
      ij> connect 'jdbc:derby:tvtm';
      ij> select * from t1;
      C1 |C2
      --------------------------------
      1 |aa
      2 |bb
      3 |cc

      3 rows selected


      To get the above message use the following Java snippet:

      private static void runTestXJ084(Connection conn){
      try{ Statement stmt = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE); ResultSet rs = stmt.executeQuery("SELECT 1, 2 FROM t1 FOR UPDATE"); rs.next(); rs.updateInt(1,22); }catch (SQLException sqe){ System.out.println(" ===> "+ sqe.getSQLState()+"="+ sqe.getMessage()); }
      }

      The message obtained is:
      ===> XJ084=Column does not correspond to a column in the base table. Cant issue {0}

      on this column.

      The

      {0}

      above should have been replaced by the appropriate operation perfomed - update in the above case.

      Attachments

        1. Derby416FixErrorText062905.txt
          395 kB
          Mamta A. Satoor

        Activity

          People

            mamtas Mamta A. Satoor
            kartha Rajesh Kartha
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: