juddi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steve Luisser (Jira)" <juddi-...@ws.apache.org>
Subject [jira] [Created] (JUDDI-1011) MS SQL Server table - length of field too large
Date Fri, 26 Jun 2020 14:38:00 GMT
Steve Luisser created JUDDI-1011:
------------------------------------

             Summary: 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


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)

Mime
View raw message