Handle writeErrors in executeUpdate

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Currently, executeUpdate does not handle duplicate key errors or other write errors returned in BulkWriteResult.writeErrors. As a result, users do not receive clear feedback (e.g., a ConstraintViolationException) when a unique constraint violation occurs - only a generic transaction aborted message from the server when Hibernate attempts to commit the transaction, because it did not know that the bulk write had errors.

      What is currently thrown:

      Caused by: com.mongodb.MongoCommandException: Command failed with error 251 (NoSuchTransaction): 'Transaction with { txnNumber: 2 } has been aborted 

      Acceptance Criteria:

      • Extract and handle relevant error codes from writeErrors in bulk write results, and propagate them via SQLException.
      • Ensure SQLExceptionConversionDelegate maps MongoDB error codes to the appropriate Hibernate exceptions.
      • Enable any disabled tests that depend on this exception handling logic.
      • Investigate and implement any additional steps needed to handle these exceptions properly.

      References:

              Assignee:
              Unassigned
              Reporter:
              Slav Babanin
              None
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated: