topic Error in Hibernate with two new tables in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/error-in-hibernate-with-two-new-tables/m-p/238339#M191469 <HTML><HEAD></HEAD><BODY><SPAN>Hi there</SPAN><BR /><BR /><SPAN>We need to create two new tables in the Alfresco DB in MySQL for an extension we are building. In then we need to save the Id of a Company and the Company Name (that is the&nbsp; first table) and in another one the Id of the company and special invoice patterns.</SPAN><BR /><BR /><SPAN>We have created the two tables in the alfresco db and now we are trying to access them using hibernate, however when I start alfresco this is what I get:</SPAN><BR /><BLOCKQUOTE class="jive-quote">09:26:51,453 INFO [org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]<BR />09:26:55,687 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed<BR />org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'ftsIndexerTrigger' defined in class path resource [alfresco/scheduled-jobs-context.xml]: Cannot create inner bean 'ftsIndexerJobDetail' of type [org.springframework.scheduling.quartz.JobDetailBean] while setting bean property 'jobDetail'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'ftsIndexerJobDetail' defined in class path resource [alfresco/scheduled-jobs-context.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.scheduling.quartz.JobDetailBean]: Constructor threw exception; nested exception is java.lang.NoSuchMethodError: org.apache.commons.collections.SetUtils.orderedSet(Ljava/util/Set<img id="smileywink" class="emoticon emoticon-smileywink" src="https://connect.hyland.com/i/smilies/16x16_smiley-wink.png" alt="Smiley Wink" title="Smiley Wink" />Ljava/util/Set;<BR />Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'ftsIndexerJobDetail' defined in class path resource [alfresco/scheduled-jobs-context.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.scheduling.quartz.JobDetailBean]: Constructor threw exception; nested exception is java.lang.NoSuchMethodError: org.apache.commons.collections.SetUtils.orderedSet(Ljava/util/Set<img id="smileywink" class="emoticon emoticon-smileywink" src="https://connect.hyland.com/i/smilies/16x16_smiley-wink.png" alt="Smiley Wink" title="Smiley Wink" />Ljava/util/Set;<BR />Caused by: org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.scheduling.quartz.JobDetailBean]: Constructor threw exception; nested exception is java.lang.NoSuchMethodError: org.apache.commons.collections.SetUtils.orderedSet(Ljava/util/Set<img id="smileywink" class="emoticon emoticon-smileywink" src="https://connect.hyland.com/i/smilies/16x16_smiley-wink.png" alt="Smiley Wink" title="Smiley Wink" />Ljava/util/Set;<BR />Caused by: java.lang.NoSuchMethodError: org.apache.commons.collections.SetUtils.orderedSet(Ljava/util/Set<img id="smileywink" class="emoticon emoticon-smileywink" src="https://connect.hyland.com/i/smilies/16x16_smiley-wink.png" alt="Smiley Wink" title="Smiley Wink" />Ljava/util/Set;<BR />at org.quartz.JobDetail.&lt;init&gt;(JobDetail.java:85)<BR />at org.springframework.scheduling.quartz.JobDetailBean.&lt;init&gt;(JobDetailBean.java:45)<BR />at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<BR />at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)<BR />at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)<BR />at java.lang.reflect.Constructor.newInstance(Constructor.java:513)<BR />at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:85)<BR />at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:61)<BR />at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:756)<BR />at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:721)<BR />at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:384)<BR />at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.java:215)<BR />at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:122)<BR />at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1099)<BR />at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:861)<BR />at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:421)<BR />at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)<BR />at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)<BR />at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)<BR />at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)<BR />at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:287)<BR />at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)<BR />at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)<BR />at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)<BR />at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)<BR />at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)<BR />at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)<BR />at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)<BR />at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)<BR />at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)<BR />at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:830)<BR />at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:719)<BR />at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)<BR />at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)<BR />at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)<BR />at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)<BR />at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)<BR />at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)<BR />at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)<BR />at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)<BR />at org.apache.catalina.core.StandardService.start(StandardService.java:516)<BR />at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)<BR />at org.apache.catalina.startup.Catalina.start(Catalina.java:578)<BR />at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR />at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR />at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />at java.lang.reflect.Method.invoke(Method.java:597)<BR />at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)<BR />at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)</BLOCKQUOTE><BR /><SPAN>I dont see exactly what the error is, any ideas or suggestions you might find??</SPAN><BR /><BR /><SPAN>Here I pass you also the XML mapping files I have configured to get access to these tables :</SPAN><BR /><BR /><SPAN>NombreEmpresa.hbm.xml</SPAN><BR /><PRE class="language-none line-numbers"><CODE>&lt;?xml version="1.0" encoding="UTF-8"?&gt;<BR />&lt;!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"<BR />&nbsp;&nbsp; "<A href="http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" rel="nofollow noopener noreferrer">http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd</A>"&gt;<BR />&lt;hibernate-mapping&gt;<BR />&nbsp;&nbsp; &lt;class name="org.alfresco.model.CifPatronesVO" table="patrones_cif"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;id name="CIF" column="CIF" type="string"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;generator class="assigned" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/id&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="patrones" column="patrones" type="string" not-null="true"/&gt;<BR />&nbsp;&nbsp; &lt;/class&gt;<BR />&lt;/hibernate-mapping&gt;<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>and Patrones.hbm.xml</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>&lt;?xml version="1.0" encoding="UTF-8"?&gt;<BR /><BR />&lt;!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"<BR />&nbsp;&nbsp; "<A href="http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" rel="nofollow noopener noreferrer">http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd</A>"&gt;<BR />&nbsp;&nbsp; <BR />&lt;hibernate-mapping&gt;<BR />&nbsp;&nbsp; &lt;class name="org.alfresco.model.CifEmpresasVO" table="nombre_empresas"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;id name="CIF" column="CIF" type="string"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;generator class="assigned" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/id&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="nombre" column="nombre" type="string" not-null="true"/&gt;<BR />&nbsp;&nbsp; &lt;/class&gt;<BR />&lt;/hibernate-mapping&gt;<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Any idea or suggestion will be much appreciated!!&nbsp; <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://connect.hyland.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /> </SPAN><BR /><BR /><SPAN>Thanks a lot in advance guys!!</SPAN></BODY></HTML> Wed, 30 Sep 2009 15:41:58 GMT jlabuelo 2009-09-30T15:41:58Z Error in Hibernate with two new tables https://connect.hyland.com/t5/alfresco-archive/error-in-hibernate-with-two-new-tables/m-p/238339#M191469 Hi thereWe need to create two new tables in the Alfresco DB in MySQL for an extension we are building. In then we need to save the Id of a Company and the Company Name (that is the&nbsp; first table) and in another one the Id of the company and special invoice patterns.We have created the two tables in t Wed, 30 Sep 2009 15:41:58 GMT https://connect.hyland.com/t5/alfresco-archive/error-in-hibernate-with-two-new-tables/m-p/238339#M191469 jlabuelo 2009-09-30T15:41:58Z Re: Error in Hibernate with two new tables https://connect.hyland.com/t5/alfresco-archive/error-in-hibernate-with-two-new-tables/m-p/238340#M191470 <HTML><HEAD></HEAD><BODY><SPAN>Hello all</SPAN><BR /><BR /><SPAN>We are trying to do something similar and are interested knowing how to access alfresco database directly to read and write in customized tables.</SPAN><BR /><BR /><SPAN>Thanks a lot in advance.</SPAN></BODY></HTML> Wed, 30 Sep 2009 15:44:27 GMT https://connect.hyland.com/t5/alfresco-archive/error-in-hibernate-with-two-new-tables/m-p/238340#M191470 mrey 2009-09-30T15:44:27Z Re: Error in Hibernate with two new tables https://connect.hyland.com/t5/alfresco-archive/error-in-hibernate-with-two-new-tables/m-p/238341#M191471 <HTML><HEAD></HEAD><BODY><SPAN>That particular error does not look like anything to do with your database.</SPAN></BODY></HTML> Wed, 30 Sep 2009 16:00:27 GMT https://connect.hyland.com/t5/alfresco-archive/error-in-hibernate-with-two-new-tables/m-p/238341#M191471 mrogers 2009-09-30T16:00:27Z Re: Error in Hibernate with two new tables https://connect.hyland.com/t5/alfresco-archive/error-in-hibernate-with-two-new-tables/m-p/238342#M191472 <HTML><HEAD></HEAD><BODY><SPAN>Hi there</SPAN><BR /><BR /><SPAN>Hey thanks for the spot!!… when you mean "that particular error"… is it because you know what the error is related to&nbsp; <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://connect.hyland.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /> ?&nbsp; if so would you mind pointing me where should I drive my review to??</SPAN><BR /><BR /><SPAN>Thanks again!</SPAN></BODY></HTML> Wed, 30 Sep 2009 16:15:02 GMT https://connect.hyland.com/t5/alfresco-archive/error-in-hibernate-with-two-new-tables/m-p/238342#M191472 jlabuelo 2009-09-30T16:15:02Z Re: Error in Hibernate with two new tables https://connect.hyland.com/t5/alfresco-archive/error-in-hibernate-with-two-new-tables/m-p/238343#M191473 <HTML><HEAD></HEAD><BODY><SPAN>Sorry to bother again, but I am quite stuck with this issue. If you mean it is not related to the way I am trying to access the DB in this configuration I created… any ideas of what it could be??… any directions from your side will be much appreciated</SPAN><BR /><BR /><SPAN>Thanks again :wink:</SPAN></BODY></HTML> Thu, 01 Oct 2009 15:07:02 GMT https://connect.hyland.com/t5/alfresco-archive/error-in-hibernate-with-two-new-tables/m-p/238343#M191473 jlabuelo 2009-10-01T15:07:02Z