Uploaded image for project: 'jUDDI'
  1. jUDDI
  2. JUDDI-184

Derby db is not created correctly on initialization

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0rc6
    • Fix Version/s: 2.0rc6
    • Component/s: None
    • Labels:
      None

      Description

      When running juddi-tomcat out-of-the-box the derby database

      1. is called juddi-derby-test-db; which we should probably change to juddi-db

      2. when the first statement is executed in the RegistryEngine on line 302

      CREATE TABLE BUSINESS_ENTITY
      (
      BUSINESS_KEY VARCHAR(41) NOT NULL,
      AUTHORIZED_NAME VARCHAR(255) NOT NULL,
      PUBLISHER_ID VARCHAR(20) NULL,
      OPERATOR VARCHAR(255) NOT NULL,
      LAST_UPDATE TIMESTAMP NOT NULL,
      PRIMARY KEY (BUSINESS_KEY)
      )

      it throws the following exception:

      SQL Exception: Syntax error: Encountered "NULL" at line 5, column 28.

      So something is wrong when it goes to create the derby database.

        Attachments

          Activity

            People

            • Assignee:
              tcunning Thomas Cunningham
              Reporter:
              kurtstam Kurt T Stam
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: