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

[Kurt Stam (JIRA)]

     [ http://jira.jboss.com/jira/browse/JBESB-1100?page=all ]

Work on JBESB-1100 started by Kurt Stam.

> 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: Kurt Stam
>
> 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