Rahul S created JUDDI-999:
-----------------------------
Summary: 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)
Key: JUDDI-999
URL: https://issues.apache.org/jira/browse/JUDDI-999
Project: jUDDI
Issue Type: Bug
Components: juddi-tomcat
Affects Versions: 3.3.6
Reporter: Rahul S
We were using SQLServer with JUDDI 3.0.4. It is working fine so far.
Now, we are trying to move to JUDDI version 3.3.6. We are encountering issue on
start-up.
{code:java}
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'inquiry': Cannot create inner bean '(inner bean)#699515f0' of type
[org.apache.juddi.api.impl.UDDIInquiryImpl] while setting constructor argument;
nested exception is org.springframework.beans.factory.BeanCreationException:
Error creating bean with name '(inner bean)#699515f0': Instantiation of bean
failed; nested exception is
org.springframework.beans.BeanInstantiationException: Failed to instantiate
[org.apache.juddi.api.impl.UDDIInquiryImpl]: Constructor threw exception;
nested exception is <openjpa-2.3.0-r422266:1540826 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: The size (8192) given to
the column 'instance_parms' exceeds the maximum allowed for any data type
(8000). {stmnt 1090863652 CREATE TABLE j3_tmodel_instance_info (id BIGINT NOT
NULL, instance_parms VARCHAR(8192), tmodel_key VARCHAR(255) NOT NULL,
entity_key VARCHAR(255) NOT NULL, PRIMARY KEY (id))} [code=131,
state=S0002]{code}
The error is "The size (8192) given to the column 'instance_parms' exceeds the
maximum allowed for any data type (8000)"
Eventually the table "j3_tmodel_instance_info" failed to create. We are using
SQLServer version 12.0.5207.0. It poses a limit on varchar fields to 8000.
We have tried modifying the column length in class "TmodelInstanceInfo" and
redeploying the app, however then it starts giving other issue.
{noformat}
The type "class org.apache.juddi.model.TmodelInstanceInfo" has not been
enhanced.{noformat}
Could anyone please help us. We are in RED flag and our application cease to
work after update to JUDDI 3.3.6
Any help be greatly appreciated.
Thanks a lot
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
