6 Replies Latest reply on Nov 29, 2006 9:27 AM by Mark Little

    juddi & postgres issue:

    Daniel Bevenius Master

      Hi,

      I hade a problem when running juddi with postgres. I got the following error message:
      "value too long for type character varying(255)".

      I found that when the method JAXRRegistryImpl.saveRegistryObject(registryObject) is called the registryObject's(instance of ServiceBinding) field accessuri is much larger then the allowed size of the column ACCESS_POINT_URL in the following table:

      CREATE TABLE BINDING_TEMPLATE
      (
      SERVICE_KEY VARCHAR(41) NOT NULL,
      BINDING_KEY VARCHAR(41) NOT NULL,
      ACCESS_POINT_TYPE VARCHAR(20) NULL,
      ACCESS_POINT_URL VARCHAR(255) NULL,
      HOSTING_REDIRECTOR VARCHAR(255) NULL,
      LAST_UPDATE TIMESTAMP NOT NULL DEFAULT now(),
      CONSTRAINT FK_BINDING_TEMPLATE_01 FOREIGN KEY (SERVICE_KEY)
      REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
      ON UPDATE CASCADE ON DELETE CASCADE,
      CONSTRAINT PK_BINDING_TEMPLATE PRIMARY KEY (BINDING_KEY)
      );

      Simply changing the size of the ACCESS_POINT_URL column to be greater than 1500 worked for me(the size of the sting in my case was about 1200). The create_database.sql file can be found in product/build/dist/install/jUDDI-registry/sql/postgresql

      /Daniel