cancel
Showing results for 
Search instead for 
Did you mean: 

Error hibernate after creating 2 new tables

mrey
Champ in-the-making
Champ in-the-making
Hi there

I have a problem after creating 2 new tables within alfresco database. I have configured alfresco to get access to the data stored in those tables, but after the confituration alfresco doesn´t startup. Somebody could help me? I followed the next steps.

Create the databases in mysql:
table name: nombre_empresas, fields: CIF and nombre
table2 name:   patrones_CIF, fields: CIF, patrones

Methods:

CifPatronesVO:

package org.alfresco.model;

public class CifPatronesVO {

   private String patrones;
   private String CIF;
   public String getCIF() {
      return CIF;
   }
   public void setCIF(String CIFPatrones) {
      CIF = CIFPatrones;
   }
   public String getPatrones() {
      return patrones;
   }
   public void setPatrones(String patrones) {
      this.patrones = patrones;
   }   
}

CifEmpresasVO

public class CifEmpresasVO {

   private String CIF;
   private String nombre;
   
   public String getCIF() {
      return CIF;
   }
   public void setCIF(String cif) {
      this.CIF = cif;
   }
   public String getNombre() {
      return nombre;
   }
   public void setNombre(String nombre) {
      this.nombre= nombre;
   }
   
}

DAO Methods:

CifNombreEmpresasDAO:
public interface CifNombreEmpresasDAO {

   public CifEmpresasVO buscaCIFEmpr(String cif);
   
   public void registerNombre(CifEmpresasVO cifEmpresasVO);
   
   public void actualizaEmpresa(CifEmpresasVO cifEmpresasVO);
}

CifNombreEmpresasDAOImpl:

public class CifNombreEmpresasDAOImpl  extends HibernateDaoSupport implements CifNombreEmpresasDAO {
   
   public CifEmpresasVO buscaCIFEmpr(String cif) {
      return (CifEmpresasVO) getHibernateTemplate()
         .get(CifEmpresasVO.class, cif);
   }
   
   public void registerNombre(CifEmpresasVO cifEmpresasVO) {
      
      HibernateTemplate temp = getHibernateTemplate();
      temp.flush();
      temp.clear();
      temp.save(cifEmpresasVO);
   }
   
   public void actualizaEmpresa(CifEmpresasVO cifEmpresasVO) {
      
      HibernateTemplate temp = getHibernateTemplate();
      temp.flush();
      temp.clear();
      temp.update(cifEmpresasVO);
   }
}

CifPatronesDAO:

import org.alfresco.model.CifPatronesVO;

   public interface CifPatronesDAO {      
      public CifPatronesVO buscaCIF(String cif);
      
      public void registerPatron(CifPatronesVO cifPatronesVO);
      
      public void actualizaPatron(CifPatronesVO cifPatronesVO);
}
   


CifPatronesDAOImpl:

   
public class CifPatronesDAOImpl extends HibernateDaoSupport implements CifPatronesDAO {
         
         public CifPatronesVO buscaCIF(String cif) {
            return (CifPatronesVO) getHibernateTemplate()
               .get(CifPatronesVO.class, cif);
         }
   
         public void registerPatron(CifPatronesVO cifPatronesVO) {
            
            HibernateTemplate temp = getHibernateTemplate();
            temp.flush();
            temp.clear();
            temp.save(cifPatronesVO);      
         }
         public void actualizaPatron(CifPatronesVO cifPatronesVO) {
            
            HibernateTemplate temp = getHibernateTemplate();
            temp.flush();
            temp.clear();
            temp.update(cifPatronesVO);
         }
   }


Mapping files
NombreEmpresa.hbm.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
   "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
   
<hibernate-mapping>
   <class name="org.alfresco.model.CifEmpresasVO" table="nombre_empresas">
      <id name="CIF" column="CIF" type="string">
         <generator class="assigned" />
      </id>
      <property name="nombre" column="nombre" type="string" not-null="true"/>
   </class>
</hibernate-mapping>

Patrones.hbm.xml:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
   "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
   <class name="org.alfresco.model.CifPatronesVO" table="patrones_cif">
      <id name="CIF" column="CIF" type="string">
         <generator class="assigned" />
      </id>
      <property name="patrones" column="patrones" type="string" not-null="true"/>
   </class>
</hibernate-mapping>

hibernate-context.xml
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE beans PUBLIC '-//SPRING//DTD BEAN//EN' 'http://www.springframework.org/dtd/spring-beans.dtd'>

<beans>
    <!– load hibernate configuration properties –>
    <bean id="hibernateConfigProperties" class="org.springframework.beans.factory.config.PropertiesFactoryBean">
        <property name="locations">
            <list>
                <value>classpath:alfresco/domain/hibernate-cfg.properties</value>
            </list>
        </property>
    </bean>
    <!– load hibernate entity cache strategies –>
    <bean id="cacheStrategiesPlaceholderConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="ignoreUnresolvablePlaceholders">
            <value>true</value>
        </property>
        <property name="locations">
            <list>
                <value>classpath:alfresco/domain/cache-strategies.properties</value>
            </list>
        </property>
    </bean>

    <bean id="defaltOnLoadListsner" class="org.hibernate.event.def.DefaultLoadEventListener" />
   
    <bean id="clearCGLibThreadLocal" class="org.alfresco.repo.domain.hibernate.HibernateLoadListener" />
   
    <!– Hibernate session factory –>
    <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean" parent="sessionFactoryBase">
        <property name="dataSource">
            <ref bean="dataSource" />
        </property>
    </bean>
   
    <bean id="sessionFactoryBase" abstract="true">
        <property name="schemaUpdate">
           <value>false</value>
        </property>
        <property name="eventListeners" >
            <map>
                <entry key="load">
                    <list>
                        <ref bean="defaltOnLoadListsner" />
                        <ref bean="clearCGLibThreadLocal" />
                    </list>
                </entry>
            </map>
        </property>
        <property name="mappingResources">
            <list>
                <!–  –>
                <!– Alfresco Node Storage –>
                <!–  –>

                <value>org/alfresco/repo/domain/hibernate/Locale.hbm.xml</value>
                <value>org/alfresco/repo/domain/hibernate/QName.hbm.xml</value>
                <value>org/alfresco/repo/domain/hibernate/Node.hbm.xml</value>
                <value>org/alfresco/repo/domain/hibernate/Transaction.hbm.xml</value>
                <value>org/alfresco/repo/domain/hibernate/VersionCount.hbm.xml</value>
                <value>org/alfresco/repo/domain/hibernate/AppliedPatch.hbm.xml</value>
                <value>org/alfresco/repo/domain/hibernate/Permission.hbm.xml</value>
                <value>org/alfresco/repo/avm/hibernate/AVM.hbm.xml</value>
                <value>org/alfresco/repo/attributes/hibernate/Attributes.hbm.xml</value>
                <value>org/alfresco/repo/domain/hibernate/UsageDelta.hbm.xml</value>
                <value>org/alfresco/repo/activities/hibernate/Activities.hbm.xml</value>

                <!– Audit config –>
                <!– TODO: Move into org/alfresco/repo/domain/hibernate/ –>
                <value>org/alfresco/repo/audit/hibernate/Audit.hbm.xml</value>

                <!– Content URL config –>
                <value>org/alfresco/repo/domain/hibernate/ContentUrl.hbm.xml</value>

                <!–  –>
                <!– JBoss jBPM Workflow Engine –>
                <!–  –>
                <!– TODO: Determine if it's possible to inject the following mappings –>
                <!–       from elsewhere –>
                <!–  –>
                <value>org/jbpm/graph/action/Script.hbm.xml</value>
                <value>org/jbpm/db/hibernate.queries.hbm.xml</value>
                <value>org/jbpm/graph/def/ProcessDefinition.hbm.xml</value>
                <value>org/jbpm/graph/def/Node.hbm.xml</value>
                <value>org/jbpm/graph/def/Transition.hbm.xml</value>
                <value>org/jbpm/graph/def/Event.hbm.xml</value>
                <value>org/jbpm/graph/def/Action.hbm.xml</value>
                <value>org/jbpm/graph/def/SuperState.hbm.xml</value>
                <value>org/jbpm/graph/def/ExceptionHandler.hbm.xml</value>
                <value>org/jbpm/instantiation/Delegation.hbm.xml</value>
                <value>org/jbpm/graph/node/StartState.hbm.xml</value>
                <value>org/jbpm/graph/node/EndState.hbm.xml</value>
                <value>org/jbpm/graph/node/ProcessState.hbm.xml</value>
                <value>org/jbpm/graph/node/Decision.hbm.xml</value>
                <value>org/jbpm/graph/node/Fork.hbm.xml</value>
                <value>org/alfresco/repo/workflow/jbpm/jbpm.Join.hbm.xml</value>
                <value>org/jbpm/graph/node/State.hbm.xml</value>
                <value>org/jbpm/graph/node/TaskNode.hbm.xml</value>
                <value>org/jbpm/context/def/ContextDefinition.hbm.xml</value>
                <value>org/jbpm/context/def/VariableAccess.hbm.xml</value>
                <value>org/jbpm/taskmgmt/def/TaskMgmtDefinition.hbm.xml</value>
                <value>org/jbpm/taskmgmt/def/Swimlane.hbm.xml</value>
                <value>org/jbpm/taskmgmt/def/Task.hbm.xml</value>
                <value>org/jbpm/taskmgmt/def/TaskController.hbm.xml</value>
                <value>org/jbpm/module/def/ModuleDefinition.hbm.xml</value>
                <value>org/jbpm/bytes/ByteArray.hbm.xml</value>
                <value>org/jbpm/file/def/FileDefinition.hbm.xml</value>
                <value>org/alfresco/repo/workflow/jbpm/jbpm.CreateTimerAction.hbm.xml</value>
                <value>org/jbpm/scheduler/def/CancelTimerAction.hbm.xml</value>
                <value>org/jbpm/graph/exe/Comment.hbm.xml</value>
                <value>org/jbpm/graph/exe/ProcessInstance.hbm.xml</value>
                <value>org/jbpm/graph/exe/Token.hbm.xml</value>
                <value>org/jbpm/graph/exe/RuntimeAction.hbm.xml</value>
                <value>org/jbpm/module/exe/ModuleInstance.hbm.xml</value>
                <value>org/jbpm/context/exe/ContextInstance.hbm.xml</value>
                <value>org/jbpm/context/exe/TokenVariableMap.hbm.xml</value>
                <value>org/jbpm/context/exe/VariableInstance.hbm.xml</value>
                <value>org/jbpm/context/exe/variableinstance/ByteArrayInstance.hbm.xml</value>
                <value>org/jbpm/context/exe/variableinstance/DateInstance.hbm.xml</value>
                <value>org/jbpm/context/exe/variableinstance/DoubleInstance.hbm.xml</value>
                <value>org/jbpm/context/exe/variableinstance/HibernateLongInstance.hbm.xml</value>
                <value>org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml</value>
                <value>org/jbpm/context/exe/variableinstance/LongInstance.hbm.xml</value>
                <value>org/jbpm/context/exe/variableinstance/NullInstance.hbm.xml</value>
                <value>org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml</value>
                <value>org/jbpm/job/Job.hbm.xml</value>
                <value>org/jbpm/job/Timer.hbm.xml</value>
                <value>org/alfresco/repo/workflow/jbpm/jbpm.Timer.hbm.xml</value>
                <value>org/jbpm/job/ExecuteNodeJob.hbm.xml</value>
                <value>org/jbpm/job/ExecuteActionJob.hbm.xml</value>
                <value>org/jbpm/taskmgmt/exe/TaskMgmtInstance.hbm.xml</value>
                <value>org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml</value>
                <value>org/alfresco/repo/workflow/jbpm/WorkflowTaskInstance.hbm.xml</value>
                <value>org/jbpm/taskmgmt/exe/PooledActor.hbm.xml</value>
                <value>org/jbpm/taskmgmt/exe/SwimlaneInstance.hbm.xml</value>
                <value>org/jbpm/logging/log/ProcessLog.hbm.xml</value>
                <value>org/jbpm/logging/log/MessageLog.hbm.xml</value>
                <value>org/jbpm/logging/log/CompositeLog.hbm.xml</value>
                <value>org/jbpm/graph/log/ActionLog.hbm.xml</value>
                <value>org/jbpm/graph/log/NodeLog.hbm.xml</value>
                <value>org/jbpm/graph/log/ProcessInstanceCreateLog.hbm.xml</value>
                <value>org/jbpm/graph/log/ProcessInstanceEndLog.hbm.xml</value>
                <value>org/jbpm/graph/log/ProcessStateLog.hbm.xml</value>
                <value>org/jbpm/graph/log/SignalLog.hbm.xml</value>
                <value>org/jbpm/graph/log/TokenCreateLog.hbm.xml</value>
                <value>org/jbpm/graph/log/TokenEndLog.hbm.xml</value>
                <value>org/jbpm/graph/log/TransitionLog.hbm.xml</value>
                <value>org/jbpm/context/log/VariableLog.hbm.xml</value>
                <value>org/jbpm/context/log/VariableCreateLog.hbm.xml</value>
                <value>org/jbpm/context/log/VariableDeleteLog.hbm.xml</value>
                <value>org/jbpm/context/log/VariableUpdateLog.hbm.xml</value>
                <value>org/jbpm/context/log/variableinstance/ByteArrayUpdateLog.hbm.xml</value>
                <value>org/jbpm/context/log/variableinstance/DateUpdateLog.hbm.xml</value>
                <value>org/jbpm/context/log/variableinstance/DoubleUpdateLog.hbm.xml</value>
                <value>org/jbpm/context/log/variableinstance/HibernateLongUpdateLog.hbm.xml</value>
                <value>org/jbpm/context/log/variableinstance/HibernateStringUpdateLog.hbm.xml</value>
                <value>org/jbpm/context/log/variableinstance/LongUpdateLog.hbm.xml</value>
                <value>org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml</value>
                <value>org/jbpm/taskmgmt/log/TaskLog.hbm.xml</value>
                <value>org/jbpm/taskmgmt/log/TaskCreateLog.hbm.xml</value>
                <value>org/jbpm/taskmgmt/log/TaskAssignLog.hbm.xml</value>
                <value>org/jbpm/taskmgmt/log/TaskEndLog.hbm.xml</value>
                <value>org/jbpm/taskmgmt/log/SwimlaneLog.hbm.xml</value>
                <value>org/jbpm/taskmgmt/log/SwimlaneCreateLog.hbm.xml</value>
                <value>org/jbpm/taskmgmt/log/SwimlaneAssignLog.hbm.xml</value>
            <value>config/org/hibernate/mapping/NombreEmpresa.hbm.xml</value>
                <value>config/org/hibernate/mapping/Patrones.hbm.xml</value>
            </list>
        </property>
        <property name="hibernateProperties" ref="hibernateConfigProperties" />
        <property name="entityCacheStrategies" >
            <props>
                <prop key="org.alfresco.repo.domain.hibernate.NamespaceEntityImpl">${cache.strategy}</prop>
                <prop key="org.alfresco.repo.domain.hibernate.QNameEntityImpl">${cache.strategy}</prop>
                <prop key="org.alfresco.repo.domain.hibernate.NodeImpl">${cache.strategy}</prop>
                <prop key="org.alfresco.repo.domain.hibernate.ChildAssocImpl">${cache.strategy}</prop>
                <prop key="org.alfresco.repo.domain.hibernate.NodeAssocImpl">${cache.strategy}</prop>
                <prop key="org.alfresco.repo.domain.hibernate.StoreImpl">${cache.strategy}</prop>
                <prop key="org.alfresco.repo.domain.hibernate.TransactionImpl">${cache.strategy}</prop>
                <prop key="org.alfresco.repo.domain.hibernate.ServerImpl">${cache.strategy}</prop>
                <prop key="org.alfresco.repo.domain.hibernate.VersionCountImpl">${cache.strategy}</prop>
                <prop key="org.alfresco.repo.domain.hibernate.AppliedPatchImpl">${cache.strategy}</prop>

                <prop key="org.alfresco.repo.domain.hibernate.DbAccessControlEntryContextImpl">${cache.strategy}</prop>
                <prop key="org.alfresco.repo.domain.hibernate.DbAccessControlEntryImpl">${cache.strategy}</prop>
                <prop key="org.alfresco.repo.domain.hibernate.DbAccessControlListChangeSetImpl">${cache.strategy}</prop>
                <prop key="org.alfresco.repo.domain.hibernate.DbAccessControlListImpl">${cache.strategy}</prop>
                <prop key="org.alfresco.repo.domain.hibernate.DbAccessControlListMemberImpl">${cache.strategy}</prop>
                <prop key="org.alfresco.repo.domain.hibernate.DbAuthorityAliasImpl">${cache.strategy}</prop>
                <prop key="org.alfresco.repo.domain.hibernate.DbAuthorityImpl">${cache.strategy}</prop>
                <prop key="org.alfresco.repo.domain.hibernate.DbPermissionImpl">${cache.strategy}</prop>
                
                <prop key="org.alfresco.repo.audit.hibernate.AuditConfigImpl">${cache.strategy}</prop>
                <prop key="org.alfresco.repo.audit.hibernate.AuditDateImpl">${cache.strategy}</prop>
                <prop key="org.alfresco.repo.audit.hibernate.AuditSourceImpl">${cache.strategy}</prop>
               
                <prop key="org.alfresco.repo.domain.hibernate.ContentUrlImpl">${cache.strategy}</prop>
            </props>
        </property>
        <property name="collectionCacheStrategies" >
            <props>
                <prop key="org.alfresco.repo.domain.hibernate.NodeImpl.properties">${cache.strategy}</prop>
                <prop key="org.alfresco.repo.domain.hibernate.NodeImpl.aspects">${cache.strategy}</prop>
            </props>
        </property>
    </bean>

    <!– create a transaction manager –>
    <bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
        <property name="transactionSynchronizationName">
            <value>SYNCHRONIZATION_ALWAYS</value>
        </property>
        <property name="sessionFactory">
            <ref bean="sessionFactory" />
        </property>
    </bean>

    <!– Hibernate-specific implementations of persistence components –>
   <bean id="qnameDAO" class="org.alfresco.repo.domain.hibernate.HibernateQNameDAOImpl">
      <property name="sessionFactory">
         <ref bean="sessionFactory" />
      </property>
      <property name="qnameEntityCache">
         <ref bean="qnameEntityCache"/>
      </property>
      <property name="namespaceEntityCache">
         <ref bean="namespaceEntityCache"/>
      </property>
   </bean>

   <bean id="versionCounterDaoComponent" class="org.alfresco.repo.domain.hibernate.VersionCounterDaoComponentImpl">
      <property name="sessionFactory">
         <ref bean="sessionFactory" />
      </property>
   </bean>

   <bean id="permissionsDaoComponent" class="org.alfresco.repo.service.StoreRedirectorProxyFactory">
      <property name="proxyInterface">
         <value>org.alfresco.repo.security.permissions.impl.PermissionsDaoComponent</value>
      </property>
      <property name="defaultBinding">
         <ref bean="dmPermissionsDaoComponent"></ref>
      </property>
      <property name="redirectedProtocolBindings">
         <map>
            <entry key="workspace"><ref bean="dmPermissionsDaoComponent"></ref></entry>
            <entry key="versionStore"><ref bean="dmPermissionsDaoComponent"></ref></entry>
            <entry key="avm"><ref bean="avmPermissionsDaoComponent"/></entry>
         </map>
      </property>
   </bean>
   
   <bean id="avmPermissionsDaoComponent" class="org.alfresco.repo.domain.hibernate.PermissionsDaoComponentImpl">
      <property name="aclDaoComponent">
         <ref bean="aclDaoComponent" />
      </property>
      <property name="protocolToACLDAO">
         <map>
            <entry key="workspace"><ref bean="nodeACLDAO"></ref></entry>
            <entry key="avm"><ref bean="avmACLDAO"/></entry>
         </map>
      </property>
      <property name="defaultACLDAO">
          <ref bean="nodeACLDAO"/>
       </property>
   </bean>
   
   <bean id="dmPermissionsDaoComponent" class="org.alfresco.repo.domain.hibernate.DMPermissionsDaoComponentImpl">
      <property name="aclDaoComponent">
         <ref bean="aclDaoComponent" />
      </property>
      <property name="protocolToACLDAO">
         <map>
            <entry key="workspace"><ref bean="nodeACLDAO"></ref></entry>
            <entry key="avm"><ref bean="avmACLDAO"/></entry>
         </map>
      </property>
      <property name="defaultACLDAO">
          <ref bean="nodeACLDAO"/>
       </property>
   </bean>
   
   <bean id="aclDaoComponent" class="org.alfresco.repo.domain.hibernate.AclDaoComponentImpl">
      <property name="sessionFactory">
         <ref bean="sessionFactory" />
      </property>
      <property name="qnameDAO">
         <ref bean="qnameDAO" />
      </property>
     <property name="aclCache">
         <ref bean="aclCache" />
      </property>
   </bean>
  
    <bean id="nodeACLDAO" class="org.alfresco.repo.domain.hibernate.DMAccessControlListDAO">
        <property name="nodeDaoService">
            <ref bean="nodeDaoService" />
        </property>
      <property name="aclDaoComponent">
            <ref bean="aclDaoComponent"/>
        </property>
      <property name="hibernateSessionHelper">
            <ref bean="hibernateSessionHelper"/>
        </property>
      <property name="nodeService">
            <ref bean="dbNodeService"/>
        </property>
    </bean>
   
    <bean id="avmACLDAO" class="org.alfresco.repo.domain.hibernate.AVMAccessControlListDAO">
        <property name="avmRepository">
            <ref bean="avmRepository"/>
        </property>
        <property name="avmService">
            <ref bean="avmService"/>
        </property>
        <property name="aclDaoComponent">
            <ref bean="aclDaoComponent"/>
        </property>
        <property name="avmSnapShotTriggeredIndexingMethodInterceptor">
            <ref bean="avmSnapShotTriggeredIndexingMethodInterceptor"/>
        </property>
        <property name="hibernateSessionHelper">
            <ref bean="hibernateSessionHelper"/>
      </property>
    </bean>

    <bean id="usageDeltaDAO" class="org.alfresco.repo.domain.hibernate.HibernateUsageDeltaDAO">
       <property name="sessionFactory">
           <ref bean="sessionFactory"/>
       </property>
       <property name="nodeDaoService">
           <ref bean="nodeDaoServiceImpl" />
       </property>
   </bean>
   
   <bean id="nodeDaoServiceImpl" class="org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl" >
      <property name="qnameDAO">
         <ref bean="qnameDAO" />
      </property>
      <property name="usageDeltaDAO">
          <ref bean="usageDeltaDAO"/>
      </property>
      <property name="aclDaoComponent">
          <ref bean="aclDaoComponent"/>
      </property>
      <property name="localeDAO">
         <ref bean="localeDAO" />
      </property>
      <property name="dictionaryService">
         <ref bean="dictionaryService" />
      </property>
      <property name="sessionFactory">
         <ref bean="sessionFactory" />
      </property>
      <property name="storeAndNodeIdCache">
         <ref bean="storeAndNodeIdCache"/>
      </property>
      <property name="parentAssocsCache">
         <ref bean="parentAssocsCache"/>
      </property>
   </bean>

   <bean id="dbNodeDaoServiceTxnRegistration" class="org.alfresco.repo.transaction.TransactionalDaoInterceptor" >
      <property name="daoService">
         <ref bean="nodeDaoServiceImpl" />
      </property>
   </bean>

   <bean id="daoServiceDirtySessionInterceptor" class="org.alfresco.repo.domain.hibernate.DirtySessionMethodInterceptor" />

   <bean id="nodeDaoService" class="org.springframework.aop.framework.ProxyFactoryBean">
      <property name="target">
         <ref bean="nodeDaoServiceImpl" />
      </property>
      <property name="interceptorNames">
         <list>
            <value>daoServiceDirtySessionInterceptor</value>
            <value>dbNodeDaoServiceTxnRegistration</value>
         </list>
      </property>
   </bean>

   <bean id="localeDAOImpl" class="org.alfresco.repo.domain.hibernate.HibernateLocaleDAOImpl" >
      <property name="sessionFactory">
         <ref bean="sessionFactory" />
      </property>
      <property name="localeIdCache">
         <ref bean="localeIdCache"/>
      </property>
   </bean>

   <bean id="localeDAO" class="org.springframework.aop.framework.ProxyFactoryBean">
      <property name="target">
         <ref bean="localeDAOImpl" />
      </property>
      <property name="interceptorNames">
         <list>
            <value>daoServiceDirtySessionInterceptor</value>
         </list>
      </property>
   </bean>
   
    <bean id="auditDao" class="org.alfresco.repo.audit.hibernate.HibernateAuditDAO">
        <property name="sessionFactory">
            <ref bean="sessionFactory"/>
        </property>
        <property name="contentStore">
            <ref bean="auditFileContentStore"/>
        </property>
        <property name="localSessionFactory">
          <ref bean="&amp;sessionFactory"></ref>  <!– inject the actual factory, not a session –>
        </property>
    </bean>

   <bean id="contentUrlDAO" class="org.springframework.aop.framework.ProxyFactoryBean">
      <property name="proxyInterfaces">
         <value>org.alfresco.repo.domain.ContentUrlDAO</value>
      </property>
      <property name="target">
         <ref bean="contentUrlDAOImpl" />
      </property>
      <property name="interceptorNames">
         <list>
            <value>sessionSizeResourceInterceptor</value>
         </list>
      </property>
   </bean>
  
   <bean id="contentUrlDAOImpl" class="org.alfresco.repo.domain.hibernate.HibernateContentUrlDAOImpl">
      <property name="sessionFactory">
         <ref bean="sessionFactory"/>
      </property>
   </bean>
  
   
   <bean id="hibernateSessionHelper" class="org.alfresco.repo.domain.hibernate.HibernateSessionHelper">
       <property name="sessionFactory">
           <ref bean="sessionFactory"/>
       </property>
   </bean>
  
   <bean id="hibernateL1CacheBulkLoader" class="org.alfresco.repo.domain.hibernate.HibernateL1CacheBulkLoader">
      <property name="sessionFactory">
         <ref bean="sessionFactory" />
      </property>
   </bean>
</beans>


And the log we find after start up is:

10:57:26,640 INFO  [org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]
10:57:29,609 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
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/SetSmiley WinkLjava/util/Set;
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/SetSmiley WinkLjava/util/Set;
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/SetSmiley WinkLjava/util/Set;
Caused by: java.lang.NoSuchMethodError: org.apache.commons.collections.SetUtils.orderedSet(Ljava/util/SetSmiley WinkLjava/util/Set;
   at org.quartz.JobDetail.<init>(JobDetail.java:85)
   at org.springframework.scheduling.quartz.JobDetailBean.<init>(JobDetailBean.java:45)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
   at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:85)
   at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:61)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:756)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:721)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:384)
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.java:215)
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:122)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1099)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:861)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:421)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
   at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:287)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:830)
   at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:719)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
   at org.apache.catalina.core.StandardService.start(StandardService.java:516)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)

Sorry if the post is too long, however wanted to try to show you all the configuration to see if you could identify the root cause that is producing this starut up error.

Sugestions are very welcome!

Thanks in advance mates!
5 REPLIES 5

mrey
Champ in-the-making
Champ in-the-making
Nobody can help? I´m very newbie and I need help


Thank you so much

janv
Employee
Employee
Caused by: java.lang.NoSuchMethodError: org.apache.commons.collections.SetUtils.orderedSet(Ljava/util/Set;)Ljava/util/Set;

A simple google search may help you … it looks as if you have an incompatible version of commons-collection.jar on your classpath ?

Regards,
Jan

mrogers
Star Contributor
Star Contributor
And what you are trying to do (create your own tables in the alfresco schema) is almost certainly the wrong approach and should be avoided.     If you are a newbie, you should start by learning about alfresco content modeling first.

There should be no need to touch the alfresco database, the only exception for this is reading the audit tables.

mrey
Champ in-the-making
Champ in-the-making
Hi MRogers

Thanks a lot for the advice, I appreciate it and know what you mean  :wink: . Let me explain you, we are trying to create a extension for Alfresco to configure an automatic process to manage paper invoices and integrate it with OpenBravo another OpenSource ERP system.
There is a time in our "system model" that we need to store the relationships between company VAT id's-company names- and Invoice number pattern, and this must be stored in two tables in a 1:n relationship as far as we see it. (Please if you know another way we will appreciate if you can share it with us).

Maybe the place where we created the two tables is the wrong one as you mention, after your post seems that the best thing to do would be creating a new external DB model and use our tables in there.

However related to the problem with the Commons-collections, we found that Alfresco 3.0 had the common-collections-3.1.jar included and this is causing us errors.
We have searched in google about this issue, and we found that people quickly fixed this issue by using the latest version "common-collections-3.2.1.jar".
We have tried to add this library to our extension in Eclipse, and then build the new alfresco.war, however when we lauch tomcat we still can see the old
common-collections-3.1.jar under "webapps/alfresco/WEB_INF/lib", and of course we still get the same error.

We have also tried to manually change the "common-collections-3.1.jar" by the "common-collections-3.2.1.jar" in "webapps/alfresco/WEB_INF/lib"…however that would not work either…. we still get the same error.

Any ideas that we can follow to solve this situation?

Thanks a lot

mrey
Champ in-the-making
Champ in-the-making
Hi Jan, Rogers

Sorry to disturb you, could you please let me know how I can do to update the Common Collection jar file to version 3.2? I  have readed in google that my problem should be gone with this update (please let me know if I am wrong). I have added this new jar version to my project in Eclipse and recompile the alfresco war but still it does not appear in the tomcat/webapps/alfresco directory and I still get the same error.

thanks a lot in advance