Uploaded image for project: 'Bamboo Data Center'
  1. Bamboo Data Center
  2. BAM-6298

Storing login attempts in Bamboo database when a username is not specified throws ORA-01400 error

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Low
    • 5.6.0
    • 2.6, 2.6.1, 4.4.5
    • Database (Oracle)
    • None

    Description

      We enforce a non-null constraint on the USER_NAME column, if username is not specified during loging:

      2010-07-19 12:50:00,469 INFO [7373191@qtp-16554308-202] [DefaultAuthenticator] login : '' does not exist and cannot be authenticated.

      Bamboo throws a SQL error, as Oracle interprets empty strings as NULL:

      2010-07-19 12:50:00,479 ERROR [7373191@qtp-16554308-202] [FiveOhOh] 500 Exception was thrown.
org.springframework.dao.DataIntegrityViolationException: Hibernate operation: Could not execute JDBC batch update; SQL []; ORA-01400: cannot insert NULL into ("BAMBOO"."AUTH_ATTEMPT_INFO"."USER_NAME")
; nested exception is java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("BAMBOO"."AUTH_ATTEMPT_INFO"."USER_NAME")

      Attachments

        Issue Links

          relates to

          BDEV-5456 Loading...

          Activity

            People

              pbruski Przemek Bruski
              asridhar AjayA
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: