[
https://issues.apache.org/jira/browse/JUDDI-1011?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alex O'Ree reassigned JUDDI-1011:
---------------------------------
Assignee: Alex O'Ree
> MS SQL Server table - length of field too large
> -----------------------------------------------
>
> Key: JUDDI-1011
> URL: https://issues.apache.org/jira/browse/JUDDI-1011
> Project: jUDDI
> Issue Type: Bug
> Components: core
> Reporter: Steve Luisser
> Assignee: Alex O'Ree
> Priority: Major
> Fix For: 3.3.9
>
>
> File mssql2000.ddl
>
> create table j3_tmodel_instance_info (id numeric(19,0) not null,
> instance_parms varchar(8192), tmodel_key varchar(255) not null, entity_key
> varchar(255) not null, primary key (id));
>
> The instance_parms column exceeds the maximum length of a varchar field in
> SQL Server of 8000 characters. I’ve reviewed the scripts for the other
> database engines and the best option is to define this column as
> instance_parms varchar(max). Another option is to define this column as
> instance_parms varchar(8000) although if there was a good reason to make it
> 8192 this value could overflow.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
