jUDDI
  1. jUDDI
  2. JUDDI-44

MySQL "InnoDB" complains of foreign keys with jUDDI schema

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Cannot Reproduce
    • Affects Version/s: 0.9rc3
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Mac OS X 10.3.5, MySQL 4.0.21

      Description

      I prefer to use the "InnoDB" MySQL storage engine whenever possible because it is the only one that is ACID compliant. I tried to load the create_database.sql script though I got 3 errors. MySQL couldn't create the BUSINESS_SERVICE, BINDING_TEMPLATE, and PUBLISHER_ASSERTION tables for the same reason:
      ERROR 1005: Can't create table './juddi/<table-name-here>.frm' (errno: 150)
      This is an InnoDB error code that has to do with foreign key constraints. I've searched the net a bit and studied the SQL hard and I really can't figure out why it's failing.

      Good luck fixing this one.

        Activity

          People

          • Assignee:
            Kurt T Stam
            Reporter:
            David Smiley
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development