[jira] [Commented] (JUDDI-1005) Need To have correct options to upgrade JUDDI DB Schema

2020-02-18 Thread Alex O'Ree (Jira) 


[ 
https://issues.apache.org/jira/browse/JUDDI-1005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17039614#comment-17039614
 ] 

Alex O'Ree commented on JUDDI-1005:
---

it should be in 
[uddi-client-distro-3.3.7.zip|http://apache.claz.org/juddi/juddi/3.3.7/uddi-client-distro-3.3.7.zip]

 

> Need To have correct options to upgrade JUDDI DB Schema
> ---
>
> Key: JUDDI-1005
> URL: https://issues.apache.org/jira/browse/JUDDI-1005
> Project: jUDDI
>  Issue Type: Bug
>  Components: juddi-tomcat
>Affects Versions: 3.3.6, 3.3.7
>Reporter: Amol Bhonsle
>Priority: Major
> Attachments: 
> uddi-migration-tool-3.3.8-SNAPSHOT-jar-with-dependencies.jar
>
>
> We are trying to update JUDDI DB from JUDDI-3.0.4 to JUDDI-3.3.7. JUDDI DB is 
> hosted on SQL Server. We use openjpa-2.3.0 which is provided by juddi-3.3.7 
> distribution.
>  
> As per openjpa-2.3.0 documentation:
> {{drop option of SchemaTool should do following:}}
> {{drop}}: Drop all schema components in the schema XML. Tables will only be 
> dropped if they would have 0 columns after dropping all columns listed in the 
> XML.
> and add option should do following:
> {{add}}: This is the default action if you do not specify one. It brings the 
> schema up-to-date with the given XML document by adding tables, columns, 
> indexes, etc. This action never drops any schema components.
> Also it is allowed in persistence.xml to use options as comma separated, so 
> we tried following option in persistence.xml to drop old tables and create 
> new tables as per juddi-3.3.7 schema but it did not work:
>  value="buildSchema(SchemaAction='drop,add')"/>
>  
> This gives following Exception when JUDDI is deployed by tomcat :
>  
> {code:java}
> SEVERE: Exception sending context initialized event to listener instance of 
> class org.springframework.web.context.ContextLoaderListenerSEVERE: Exception 
> sending context initialized event to listener instance of class 
> org.springframework.web.context.ContextLoaderListenerorg.springframework.beans.factory.BeanCreationException:
>  Error creating bean with name 'inquiry': Cannot create inner bean '(inner 
> bean)#fa6535a' 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)#fa6535a': 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  general error> org.apache.openjpa.persistence.PersistenceException: The 
> object 'PK__j3_clerk__5609ADDDCF01D08E' is dependent on column 'clerk_name'. 
> \{stmnt 1807668378 ALTER TABLE j3_clerk DROP COLUMN clerk_name} [code=5074, 
> state=S0001] at 
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.java:389)
>  at 
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:134)
>  at 
> org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:691)
>  at 
> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:196)
>  at 
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1358)
>  at 
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1204)
>  at 
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:557)
>  at 
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517)
>  at 
> org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323)
>  at 
> org.springframework.beans.factory.support.AbstractBeanFactory$$Lambda$208/1654431226.getObject(Unknown
>  Source) at 
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
>  at 
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321)
>  at 
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
>  at 
> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:879)
>  at 
> org.springframework.context.support.AbstractApplicationContext.finishBeanFacto

[jira] [Commented] (JUDDI-1005) Need To have correct options to upgrade JUDDI DB Schema

2020-02-18 Thread Alex O'Ree (Jira) 


[ 
https://issues.apache.org/jira/browse/JUDDI-1005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17039613#comment-17039613
 ] 

Alex O'Ree commented on JUDDI-1005:
---

just attached the correct jar, sorry about that.

> Need To have correct options to upgrade JUDDI DB Schema
> ---
>
> Key: JUDDI-1005
> URL: https://issues.apache.org/jira/browse/JUDDI-1005
> Project: jUDDI
>  Issue Type: Bug
>  Components: juddi-tomcat
>Affects Versions: 3.3.6, 3.3.7
>Reporter: Amol Bhonsle
>Priority: Major
> Attachments: 
> uddi-migration-tool-3.3.8-SNAPSHOT-jar-with-dependencies.jar
>
>
> We are trying to update JUDDI DB from JUDDI-3.0.4 to JUDDI-3.3.7. JUDDI DB is 
> hosted on SQL Server. We use openjpa-2.3.0 which is provided by juddi-3.3.7 
> distribution.
>  
> As per openjpa-2.3.0 documentation:
> {{drop option of SchemaTool should do following:}}
> {{drop}}: Drop all schema components in the schema XML. Tables will only be 
> dropped if they would have 0 columns after dropping all columns listed in the 
> XML.
> and add option should do following:
> {{add}}: This is the default action if you do not specify one. It brings the 
> schema up-to-date with the given XML document by adding tables, columns, 
> indexes, etc. This action never drops any schema components.
> Also it is allowed in persistence.xml to use options as comma separated, so 
> we tried following option in persistence.xml to drop old tables and create 
> new tables as per juddi-3.3.7 schema but it did not work:
>  value="buildSchema(SchemaAction='drop,add')"/>
>  
> This gives following Exception when JUDDI is deployed by tomcat :
>  
> {code:java}
> SEVERE: Exception sending context initialized event to listener instance of 
> class org.springframework.web.context.ContextLoaderListenerSEVERE: Exception 
> sending context initialized event to listener instance of class 
> org.springframework.web.context.ContextLoaderListenerorg.springframework.beans.factory.BeanCreationException:
>  Error creating bean with name 'inquiry': Cannot create inner bean '(inner 
> bean)#fa6535a' 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)#fa6535a': 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  general error> org.apache.openjpa.persistence.PersistenceException: The 
> object 'PK__j3_clerk__5609ADDDCF01D08E' is dependent on column 'clerk_name'. 
> \{stmnt 1807668378 ALTER TABLE j3_clerk DROP COLUMN clerk_name} [code=5074, 
> state=S0001] at 
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.java:389)
>  at 
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:134)
>  at 
> org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:691)
>  at 
> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:196)
>  at 
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1358)
>  at 
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1204)
>  at 
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:557)
>  at 
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517)
>  at 
> org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323)
>  at 
> org.springframework.beans.factory.support.AbstractBeanFactory$$Lambda$208/1654431226.getObject(Unknown
>  Source) at 
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
>  at 
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321)
>  at 
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
>  at 
> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:879)
>  at 
> org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:878)
>  at 
> org.sprin

[jira] [Updated] (JUDDI-1005) Need To have correct options to upgrade JUDDI DB Schema

2020-02-18 Thread Alex O'Ree (Jira) 


 [ 
https://issues.apache.org/jira/browse/JUDDI-1005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Alex O'Ree updated JUDDI-1005:
--
Attachment: uddi-migration-tool-3.3.8-SNAPSHOT-jar-with-dependencies.jar

> Need To have correct options to upgrade JUDDI DB Schema
> ---
>
> Key: JUDDI-1005
> URL: https://issues.apache.org/jira/browse/JUDDI-1005
> Project: jUDDI
>  Issue Type: Bug
>  Components: juddi-tomcat
>Affects Versions: 3.3.6, 3.3.7
>Reporter: Amol Bhonsle
>Priority: Major
> Attachments: 
> uddi-migration-tool-3.3.8-SNAPSHOT-jar-with-dependencies.jar
>
>
> We are trying to update JUDDI DB from JUDDI-3.0.4 to JUDDI-3.3.7. JUDDI DB is 
> hosted on SQL Server. We use openjpa-2.3.0 which is provided by juddi-3.3.7 
> distribution.
>  
> As per openjpa-2.3.0 documentation:
> {{drop option of SchemaTool should do following:}}
> {{drop}}: Drop all schema components in the schema XML. Tables will only be 
> dropped if they would have 0 columns after dropping all columns listed in the 
> XML.
> and add option should do following:
> {{add}}: This is the default action if you do not specify one. It brings the 
> schema up-to-date with the given XML document by adding tables, columns, 
> indexes, etc. This action never drops any schema components.
> Also it is allowed in persistence.xml to use options as comma separated, so 
> we tried following option in persistence.xml to drop old tables and create 
> new tables as per juddi-3.3.7 schema but it did not work:
>  value="buildSchema(SchemaAction='drop,add')"/>
>  
> This gives following Exception when JUDDI is deployed by tomcat :
>  
> {code:java}
> SEVERE: Exception sending context initialized event to listener instance of 
> class org.springframework.web.context.ContextLoaderListenerSEVERE: Exception 
> sending context initialized event to listener instance of class 
> org.springframework.web.context.ContextLoaderListenerorg.springframework.beans.factory.BeanCreationException:
>  Error creating bean with name 'inquiry': Cannot create inner bean '(inner 
> bean)#fa6535a' 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)#fa6535a': 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  general error> org.apache.openjpa.persistence.PersistenceException: The 
> object 'PK__j3_clerk__5609ADDDCF01D08E' is dependent on column 'clerk_name'. 
> \{stmnt 1807668378 ALTER TABLE j3_clerk DROP COLUMN clerk_name} [code=5074, 
> state=S0001] at 
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.java:389)
>  at 
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:134)
>  at 
> org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:691)
>  at 
> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:196)
>  at 
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1358)
>  at 
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1204)
>  at 
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:557)
>  at 
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517)
>  at 
> org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323)
>  at 
> org.springframework.beans.factory.support.AbstractBeanFactory$$Lambda$208/1654431226.getObject(Unknown
>  Source) at 
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
>  at 
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321)
>  at 
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
>  at 
> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:879)
>  at 
> org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:878)
>  at 
> org.springframework.context.support.Abs

[jira] [Commented] (JUDDI-1005) Need To have correct options to upgrade JUDDI DB Schema

2020-02-18 Thread Amol Bhonsle (Jira) 


[ 
https://issues.apache.org/jira/browse/JUDDI-1005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17039004#comment-17039004
 ] 

Amol Bhonsle commented on JUDDI-1005:
-

Hi [~spyhunter99]

Can you help me here. 

I checked documentation on Migration Tool on below link:
https://juddi.apache.org/docs/3.3/juddi-client-guide/pdf/jUDDI_Guide.pdf ( 
Chapter 8 on page 73) and also got uddi-migration-tool from 
https://juddi.apache.org/uddi-client-dist/source-repository.html

When, I am trying to run it, I am getting error as "no main manifest attribute, 
in uddi-migration-tool-3.3.7.jar". Am I using incorrect jar here ? document 
talks about juddi-migration-tool-(VERSION)-jar-with-dependencies.jar which 
seems to be a different file but I don't see it anywhere on apache site.


> Need To have correct options to upgrade JUDDI DB Schema
> ---
>
> Key: JUDDI-1005
> URL: https://issues.apache.org/jira/browse/JUDDI-1005
> Project: jUDDI
>  Issue Type: Bug
>  Components: juddi-tomcat
>Affects Versions: 3.3.6, 3.3.7
>Reporter: Amol Bhonsle
>Priority: Major
>
> We are trying to update JUDDI DB from JUDDI-3.0.4 to JUDDI-3.3.7. JUDDI DB is 
> hosted on SQL Server. We use openjpa-2.3.0 which is provided by juddi-3.3.7 
> distribution.
>  
> As per openjpa-2.3.0 documentation:
> {{drop option of SchemaTool should do following:}}
> {{drop}}: Drop all schema components in the schema XML. Tables will only be 
> dropped if they would have 0 columns after dropping all columns listed in the 
> XML.
> and add option should do following:
> {{add}}: This is the default action if you do not specify one. It brings the 
> schema up-to-date with the given XML document by adding tables, columns, 
> indexes, etc. This action never drops any schema components.
> Also it is allowed in persistence.xml to use options as comma separated, so 
> we tried following option in persistence.xml to drop old tables and create 
> new tables as per juddi-3.3.7 schema but it did not work:
>  value="buildSchema(SchemaAction='drop,add')"/>
>  
> This gives following Exception when JUDDI is deployed by tomcat :
>  
> {code:java}
> SEVERE: Exception sending context initialized event to listener instance of 
> class org.springframework.web.context.ContextLoaderListenerSEVERE: Exception 
> sending context initialized event to listener instance of class 
> org.springframework.web.context.ContextLoaderListenerorg.springframework.beans.factory.BeanCreationException:
>  Error creating bean with name 'inquiry': Cannot create inner bean '(inner 
> bean)#fa6535a' 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)#fa6535a': 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  general error> org.apache.openjpa.persistence.PersistenceException: The 
> object 'PK__j3_clerk__5609ADDDCF01D08E' is dependent on column 'clerk_name'. 
> \{stmnt 1807668378 ALTER TABLE j3_clerk DROP COLUMN clerk_name} [code=5074, 
> state=S0001] at 
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.java:389)
>  at 
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:134)
>  at 
> org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:691)
>  at 
> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:196)
>  at 
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1358)
>  at 
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1204)
>  at 
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:557)
>  at 
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517)
>  at 
> org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323)
>  at 
> org.springframework.beans.factory.support.AbstractBeanFactory$$Lambda$208/1654431226.getObject(Unknown
>  Source) at 
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
>  at 
> org.springframework.beans.factory