[JUDDI-1015] Oracle database start up issue due to max string length

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.3.9
• Assignee: Alex O'Ree
• Reporter: Alex O'Ree
• Created: 11/Jul/20 01:12
• Updated: 19/Aug/20 00:38
• Resolved: 14/Aug/20 00:48

Description

from the juddi mailing list

 

Oracle Version of Juddi Due to string limit for a column CREATE TABLE j3_binding_template (entity_key VARCHAR2(255) NOT NULL, access_point_type VARCHAR2(255), access_point_url VARCHAR2(4096), hosting_redirector VARCHAR2(255), service_key VARCHAR2(255) NOT NULL, PRIMARY KEY (entity_key)) Oracle max varchar limit: 4000  

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)
• relates to: JUDDI-1011 MS SQL Server table - length of field too large