Uploaded image for project: 'Poulpe'
  1. Poulpe
  2. POULPE-374

'Could not execute JDBC batch update[SQL: 1406, 22001]' appears if a user tries to save Email with large name.

    Details

      Description

      1) Sign in by any user
      2) Navigate to the 'A list of Users' page
      3) Double click on any user
      4) Input 'ABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDE@rambler.ru' in the Email field
      5) Click on the Save button

      Actual: 'Could not execute JDBC batch update[SQL: 1406, 22001]' appears if a user tries to save Email with large name.
      Expected: Error message of validation should appear

        Attachments

          Issue Links

            Activity

            Hide
            polarhare Nickolay Polyarniy added a comment -

            Done by adding validation annotation to email field in PoupleUser and message about too big length of email in props file.

            Show
            polarhare Nickolay Polyarniy added a comment - Done by adding validation annotation to email field in PoupleUser and message about too big length of email in props file.
            Hide
            ctapobep Stanislav Bashkyrtsev added a comment -

            Wait a sec.. I was talking about overriding getter method, not about adding additional field to the class. Effectively you ended up with 2 same fields in the class hierarchy.

            Show
            ctapobep Stanislav Bashkyrtsev added a comment - Wait a sec.. I was talking about overriding getter method, not about adding additional field to the class. Effectively you ended up with 2 same fields in the class hierarchy.
            Hide
            polarhare Nickolay Polyarniy added a comment -

            Sorry. While I am doing this, how to rollback this change? Or is it not necessary? Or just delete this field and commit this change?

            Show
            polarhare Nickolay Polyarniy added a comment - Sorry. While I am doing this, how to rollback this change? Or is it not necessary? Or just delete this field and commit this change?
            Hide
            polarhare Nickolay Polyarniy added a comment -

            Added validation of email field's length by overriding getter(and adding to it @Length)

            Show
            polarhare Nickolay Polyarniy added a comment - Added validation of email field's length by overriding getter(and adding to it @Length)
            Hide
            ilzul Ilya Zhulanov added a comment -

            Verified.

            Show
            ilzul Ilya Zhulanov added a comment - Verified.

              People

              • Assignee:
                ilzul Ilya Zhulanov
                Reporter:
                ilzul Ilya Zhulanov
              • Votes:
                0 Vote for this issue
                Watchers:
                Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 4h Original Estimate - 4h
                  4h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 13h 35m
                  13h 35m

                    Structure Helper Panel