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

juddi / JBossESB MySQL/PostGres ACCESS_POINT_URL size

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.0rc5
    • Component/s: None
    • Labels:
      None
    • Environment:
      Mac OS X

      Description

      JBoss ESB requires larger ACCESS_POINT_URL strings - currently, the create_database.sql script limits the string to 255 characters, it should be increased to something much higher (2000?).

      See http://jira.jboss.com/jira/browse/JBESB-1195

      1. postgres.patch
        0.6 kB
        Tom Cunningham

        Activity

        Hide
        tcunning Tom Cunningham added a comment - - edited

        Having trouble attaching patch :

        Index: src/main/resources/juddi-sql/mysql/create_database.sql
        ===================================================================
        — create_database.sql (revision 586096)
        +++ create_database.sql (working copy)
        @@ -189,7 +189,7 @@
        SERVICE_KEY VARCHAR(41) NOT NULL,
        BINDING_KEY VARCHAR(41) NOT NULL,
        ACCESS_POINT_TYPE VARCHAR(20) NULL,

        • ACCESS_POINT_URL VARCHAR(255) NULL,
          + ACCESS_POINT_URL VARCHAR(2000) NULL,
          HOSTING_REDIRECTOR VARCHAR(255) NULL,
          LAST_UPDATE TIMESTAMP NOT NULL,
          PRIMARY KEY (BINDING_KEY),
        Show
        tcunning Tom Cunningham added a comment - - edited Having trouble attaching patch : Index: src/main/resources/juddi-sql/mysql/create_database.sql =================================================================== — create_database.sql (revision 586096) +++ create_database.sql (working copy) @@ -189,7 +189,7 @@ SERVICE_KEY VARCHAR(41) NOT NULL, BINDING_KEY VARCHAR(41) NOT NULL, ACCESS_POINT_TYPE VARCHAR(20) NULL, ACCESS_POINT_URL VARCHAR(255) NULL, + ACCESS_POINT_URL VARCHAR(2000) NULL, HOSTING_REDIRECTOR VARCHAR(255) NULL, LAST_UPDATE TIMESTAMP NOT NULL, PRIMARY KEY (BINDING_KEY),
        Hide
        tcunning Tom Cunningham added a comment -

        Patch for Postgresql create_database.sql

        Show
        tcunning Tom Cunningham added a comment - Patch for Postgresql create_database.sql
        Hide
        kurtstam Kurt T Stam added a comment -

        Closing, also fixed the same problem for the sql scripts of the other dbs.

        Show
        kurtstam Kurt T Stam added a comment - Closing, also fixed the same problem for the sql scripts of the other dbs.

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development