juddi & postgres issue:

[beve]

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

[kurtstam]

Thanks Daniel,

I have updated the script for Postgres so it is a TEXT field, rather then a VARCHAR. Please let me know if you have any more issues and thank you for the patch!

--Kurt

[beve]

Hi Kurt,

don't know if this is the correct place to mention this but I found that if I configure a filegateway listener and place an empty file in the inputDir, a NullPointerException is thrown from BodyImpl.fromXml(Element):

CDATASection cdata = (CDATASection) child.getFirstChild();
if ( cdata != null ) // Added by me so that no exception is thrown
 _content = Base64.decode(cdata.getWholeText());

The exception is then caught in MessageImpl.fromXml(Document) and the stacktrace is printed to stdout. Don't really know if this is a valid usecase but I guess there might be situations where people want to simply trigger an action by using an empty file.

What is the correct way to report these sort of things?

Thanks,

Daniel

[kurtstam]

Jira would be good place: http://jira.jboss.com/jira/browse/JBESB

It'd be great if you could add it there, and maybe suggest a patch :)

Thx!

--Kurt

[marklittle]

Reporting here will be fine. Thanks.

We'll take a look and see if this is something we can fix in the GA release.

[marklittle]

I thought that was the patch ;-)

[marklittle]

Done and in the process of being checked in.

http://jira.jboss.com/jira/browse/JBESB-249