[jira] [Created] (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)

["Rahul S (Jira)" <ju...@ws.apache.org>]

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)