[esb-issues] [JBoss JIRA] Assigned: (JBESB-1100) Wrong Juddi-DB initialisation script for Sybase
Kurt Stam (JIRA)
jira-events at lists.jboss.org
Fri Sep 28 10:21:09 EDT 2007
[ http://jira.jboss.com/jira/browse/JBESB-1100?page=all ]
Kurt Stam reassigned JBESB-1100:
--------------------------------
Assignee: Kurt Stam (was: Mark Little)
> 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
> 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
More information about the esb-issues
mailing list