[esb-issues] [JBoss JIRA] Created: (JBESB-1100) Wrong Juddi-DB initialisation script for Sybase

Wrong Juddi-DB initialisation script for Sybase ----------------------------------------------- Key: JBESB-1100 URL: http://jira.jboss.com/jira/browse/JBESB-1100 Project: JBoss ESB Issue Type: Bug Security Level: Public (Everyone can see) Components: Configuration, Deployment, Registry and Repository Affects Versions: 4.2 Environment: JBoss 4.2, MsSQL 9.0 as a BackEnd Reporter: Mikhail Kolesnikov Assigned To: Mark Little Fix For: 4.2.1, 4.2 For initializing JUDDI data source on MsSQL I have used script for Sybase and there is an error occured in server log: com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated Perform some debugging I had find a root cause - wrong DB structure This script exists in ESB distribution: 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 DATETIME NOT NULL, PRIMARY KEY (BINDING_KEY), FOREIGN KEY (SERVICE_KEY) REFERENCES BUSINESS_SERVICE (SERVICE_KEY) ) But we need in that one: 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 TEXT NULL, -- HERE MUST BE 'TEXT' HOSTING_REDIRECTOR VARCHAR(255) NULL, LAST_UPDATE DATETIME NOT NULL, PRIMARY KEY (BINDING_KEY), FOREIGN KEY (SERVICE_KEY) REFERENCES BUSINESS_SERVICE (SERVICE_KEY) ) Best regards... -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira