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

Fri Sep 28 10:18:41 EDT 2007

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