[JUDDI-1011] MS SQL Server table - length of field too large

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.3.9
• Component/s: core
• Assignee: Alex O'Ree
• Reporter: Steve Luisser
• Created: 26/Jun/20 14:37
• Updated: 19/Aug/20 00:38
• Resolved: 13/Aug/20 01:54

Description

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.

Issue Links

• is related to: JUDDI-999 Issue with SQL Server Database with JUDDI 3.3.6 : The size (8192) given to the column 'instance_parms' exceeds the maximum allowed for any data type (8000)
• is related to: JUDDI-1015 Oracle database start up issue due to max string length