Sqoop
  1. Sqoop
  2. SQOOP-1042

Sqoop2: Name constraints in Derby repository

    Details

    • Type: Improvement Improvement
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 1.99.2
    • Fix Version/s: 1.99.3
    • Component/s: None
    • Labels:
      None

      Description

      When dealing with foreign key constraints, derby will print similar exceptions:

      Exception: java.sql.SQLIntegrityConstraintViolationException Message: INSERT on table 'SQ_JOB_INPUT' caused a violation of foreign key constraint 'SQL130511152808250' for key (20).  The statement has been rolled back
      

      Constraint name SQL130511152808250 is auto generated because we are not explicitly naming them in the create script. For simpler debugging, I would suggest to explicitly name all constraints.

      1. bugSQOOP-1042.patch
        13 kB
        Jarek Jarcec Cecho

        Issue Links

          Activity

          Hide
          Kathleen Ting added a comment -
          Show
          Kathleen Ting added a comment - Thanks Jarcec for the contribution. The patch is in: https://git-wip-us.apache.org/repos/asf?p=sqoop.git;a=commit;h=67f6340344c833eae8f565347f60f37b1ac95c6d
          Hide
          Hudson added a comment -

          Integrated in Sqoop2-hadoop200 #280 (See https://builds.apache.org/job/Sqoop2-hadoop200/280/)
          SQOOP-1042: Sqoop2: Name constraints in Derby repository (Revision 67f6340344c833eae8f565347f60f37b1ac95c6d)

          Result = FAILURE
          kathleen : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=67f6340344c833eae8f565347f60f37b1ac95c6d
          Files :

          • repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbySchemaConstants.java
          • repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbySchemaQuery.java
          Show
          Hudson added a comment - Integrated in Sqoop2-hadoop200 #280 (See https://builds.apache.org/job/Sqoop2-hadoop200/280/ ) SQOOP-1042 : Sqoop2: Name constraints in Derby repository (Revision 67f6340344c833eae8f565347f60f37b1ac95c6d) Result = FAILURE kathleen : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=67f6340344c833eae8f565347f60f37b1ac95c6d Files : repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbySchemaConstants.java repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbySchemaQuery.java
          Hide
          Hudson added a comment -

          Integrated in Sqoop2-hadoop100 #280 (See https://builds.apache.org/job/Sqoop2-hadoop100/280/)
          SQOOP-1042: Sqoop2: Name constraints in Derby repository (Revision 67f6340344c833eae8f565347f60f37b1ac95c6d)

          Result = FAILURE
          kathleen : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=67f6340344c833eae8f565347f60f37b1ac95c6d
          Files :

          • repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbySchemaConstants.java
          • repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbySchemaQuery.java
          Show
          Hudson added a comment - Integrated in Sqoop2-hadoop100 #280 (See https://builds.apache.org/job/Sqoop2-hadoop100/280/ ) SQOOP-1042 : Sqoop2: Name constraints in Derby repository (Revision 67f6340344c833eae8f565347f60f37b1ac95c6d) Result = FAILURE kathleen : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=67f6340344c833eae8f565347f60f37b1ac95c6d Files : repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbySchemaConstants.java repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbySchemaQuery.java

            People

            • Assignee:
              Jarek Jarcec Cecho
              Reporter:
              Jarek Jarcec Cecho
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development