topic ActivityException: Error while building ibatis SqlSessionFactory: null in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/activityexception-error-while-building-ibatis-sqlsessionfactory/m-p/232816#M185946 <HTML><HEAD></HEAD><BODY><SPAN>Hi All,</SPAN><BR /><BR /><SPAN>I'm new to activiti, trying to configure with Spring.</SPAN><BR /><BR /><SPAN>Please find the below java based configurations:</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;@Bean </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;public DataSource dataSource() throws PropertyVetoException </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;{ </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ComboPooledDataSource dataSource = new ComboPooledDataSource(); </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dataSource.setDriverClass(env.getProperty("jdbc.driverClassName")); </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dataSource.setJdbcUrl(env.getProperty("jdbc.url")); </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dataSource.setUser(env.getProperty("jdbc.username")); </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dataSource.setPassword(env.getProperty("jdbc.password")); </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dataSource.setAcquireIncrement(5);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dataSource.setIdleConnectionTestPeriod(60);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dataSource.setMaxPoolSize(10);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dataSource.setMaxStatements(5);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dataSource.setMinPoolSize(3);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return dataSource; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;} </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;//activiti setup for workflow</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;@Bean</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;@DependsOn("transactionManager")</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;public SpringProcessEngineConfiguration processEngineConfiguration() throws PropertyVetoException{</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SpringProcessEngineConfiguration configuration = new SpringProcessEngineConfiguration();</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;configuration.setDataSource(dataSource());</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;configuration.setDatabaseType("postgresql");</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;configuration.setTransactionManager(transactionManager());</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;configuration.setDatabaseSchemaUpdate("true");</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;configuration.setJobExecutorActivate(true);</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return configuration;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;}</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;@Bean</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;@DependsOn("processEngineConfiguration")</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;public ProcessEngineFactoryBean processEngineFactoryBean() throws PropertyVetoException{</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ProcessEngineFactoryBean bean = new ProcessEngineFactoryBean();</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;bean.setProcessEngineConfiguration(processEngineConfiguration());</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return bean;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;}</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;@Bean</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;@DependsOn("processEngineFactoryBean")</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;RepositoryService repositoryService() throws PropertyVetoException{</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return processEngineFactoryBean().getProcessEngineConfiguration().getRepositoryService();</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;}</SPAN><BR /><BR /><BR /><BR /><SPAN>Please see the below exception:</SPAN><BR /><BR /><BR /><SPAN>15:33:55,000 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) 15:33:54.999 [ServerService Thread Pool – 56] WARN&nbsp; o.s.w.c.s.XmlWebApplicationContext - Exception encountered during context initialization - cancelling refresh attempt</SPAN><BR /><BR /><SPAN>15:33:55,000 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngineFactoryBean': FactoryBean threw exception on object creation; nested exception is org.activiti.engine.ActivitiException: Error while building ibatis SqlSessionFactory: null</SPAN><BR /><BR /><SPAN>15:33:55,000 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:175) ~[spring-beans-4.2.0.RELEASE.jar:4.2.0.RELEASE]</SPAN><BR /><BR /><SPAN>15:33:55,000 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:103) ~[spring-beans-4.2.0.RELEASE.jar:4.2.0.RELEASE]</SPAN><BR /><BR /><SPAN>15:33:55,001 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1574) ~[spring-beans-4.2.0.RELEASE.jar:4.2.0.RELEASE]</SPAN><BR /><BR /><SPAN>15:33:55,001 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:253) ~[spring-beans-4.2.0.RELEASE.jar:4.2.0.RELEASE]</SPAN><BR /><BR /><SPAN>15:33:55,001 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:196) ~[spring-beans-4.2.0.RELEASE.jar:4.2.0.RELEASE]</SPAN><BR /><BR /><SPAN>15:33:55,001 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:295) ~[spring-beans-4.2.0.RELEASE.jar:4.2.0.RELEASE]</SPAN><BR /><BR /><SPAN>15:33:55,001 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:196) ~[spring-beans-4.2.0.RELEASE.jar:4.2.0.RELEASE]</SPAN><BR /><BR /><SPAN>15:33:55,001 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:772) ~[spring-beans-4.2.0.RELEASE.jar:4.2.0.RELEASE]</SPAN><BR /><BR /><SPAN>15:33:55,001 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:834) ~[spring-context-4.2.0.RELEASE.jar:4.2.0.RELEASE]</SPAN><BR /><BR /><SPAN>15:33:55,001 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:537) ~[spring-context-4.2.0.RELEASE.jar:4.2.0.RELEASE]</SPAN><BR /><BR /><SPAN>15:33:55,001 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:446) [spring-web-4.2.0.RELEASE.jar:4.2.0.RELEASE]</SPAN><BR /><BR /><SPAN>15:33:55,001 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:328) [spring-web-4.2.0.RELEASE.jar:4.2.0.RELEASE]</SPAN><BR /><BR /><SPAN>15:33:55,002 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107) [spring-web-4.2.0.RELEASE.jar:4.2.0.RELEASE]</SPAN><BR /><BR /><SPAN>15:33:55,002 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.contextListenerStart(StandardContext.java:3339) [jbossweb-7.4.8.Final-redhat-4.jar!/:7.4.8.Final-redhat-4]</SPAN><BR /><BR /><SPAN>15:33:55,002 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.start(StandardContext.java:3777) [jbossweb-7.4.8.Final-redhat-4.jar!/:7.4.8.Final-redhat-4]</SPAN><BR /><BR /><SPAN>15:33:55,002 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at org.jboss.as.web.deployment.WebDeploymentService.doStart(WebDeploymentService.java:161) [jboss-as-web-7.4.0.Final-redhat-19.jar!/:7.4.0.Final-redhat-19]</SPAN><BR /><BR /><SPAN>15:33:55,002 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at org.jboss.as.web.deployment.WebDeploymentService.access$000(WebDeploymentService.java:59) [jboss-as-web-7.4.0.Final-redhat-19.jar!/:7.4.0.Final-redhat-19]</SPAN><BR /><BR /><SPAN>15:33:55,002 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:94) [jboss-as-web-7.4.0.Final-redhat-19.jar!/:7.4.0.Final-redhat-19]</SPAN><BR /><BR /><SPAN>15:33:55,002 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_45]</SPAN><BR /><BR /><SPAN>15:33:55,002 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_45]</SPAN><BR /><BR /><SPAN>15:33:55,002 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_45]</SPAN><BR /><BR /><SPAN>15:33:55,003 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_45]</SPAN><BR /><BR /><SPAN>15:33:55,003 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at java.lang.Thread.run(Thread.java:745) [na:1.8.0_45]</SPAN><BR /><BR /><SPAN>15:33:55,003 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at org.jboss.threads.JBossThread.run(JBossThread.java:122) [jboss-threads-2.1.1.Final-redhat-1.jar!/:2.1.1.Final-redhat-1]</SPAN><BR /><BR /><SPAN>15:33:55,003 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) Caused by: org.activiti.engine.ActivitiException: Error while building ibatis SqlSessionFactory: null</SPAN><BR /><BR /><SPAN>15:33:55,003 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.initSqlSessionFactory(ProcessEngineConfigurationImpl.java:744) ~[activiti-engine-5.19.0.jar:5.19.0]</SPAN><BR /><BR /><SPAN>15:33:55,003 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.init(ProcessEngineConfigurationImpl.java:470) ~[activiti-engine-5.19.0.jar:5.19.0]</SPAN><BR /><BR /><SPAN>15:33:55,003 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:440) ~[activiti-engine-5.19.0.jar:5.19.0]</SPAN><BR /><BR /><SPAN>15:33:55,003 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringProcessEngineConfiguration.buildProcessEngine(SpringProcessEngineConfiguration.java:65) ~[activiti-spring-5.19.0.jar:5.19.0]</SPAN><BR /><BR /><SPAN>15:33:55,004 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:60) ~[activiti-spring-5.19.0.jar:5.19.0]</SPAN><BR /><BR /><SPAN>15:33:55,004 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:32) ~[activiti-spring-5.19.0.jar:5.19.0]</SPAN><BR /><BR /><SPAN>15:33:55,004 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:168) ~[spring-beans-4.2.0.RELEASE.jar:4.2.0.RELEASE]</SPAN><BR /><BR /><SPAN>15:33:55,004 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) &nbsp;&nbsp;&nbsp;… 23 common frames omitted</SPAN><BR /><BR /><SPAN>15:33:55,004 INFO&nbsp; [stdout] (ServerService Thread Pool – 56) Caused by: java.lang.NullPointerException: null</SPAN></BODY></HTML> Tue, 22 Mar 2016 11:44:44 GMT imkeshav 2016-03-22T11:44:44Z ActivityException: Error while building ibatis SqlSessionFactory: null https://connect.hyland.com/t5/alfresco-archive/activityexception-error-while-building-ibatis-sqlsessionfactory/m-p/232816#M185946 Hi All,I'm new to activiti, trying to configure with Spring.Please find the below java based configurations:&nbsp;&nbsp;&nbsp;@Bean &nbsp;&nbsp;&nbsp;public DataSource dataSource() throws PropertyVetoException &nbsp;&nbsp;&nbsp;{ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ComboPooledDataSource dataSource = new ComboPooledDataSource(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dataSource.setDriverClass(env.getProper Tue, 22 Mar 2016 11:44:44 GMT https://connect.hyland.com/t5/alfresco-archive/activityexception-error-while-building-ibatis-sqlsessionfactory/m-p/232816#M185946 imkeshav 2016-03-22T11:44:44Z Re: ActivityException: Error while building ibatis SqlSessionFactory: null https://connect.hyland.com/t5/alfresco-archive/activityexception-error-while-building-ibatis-sqlsessionfactory/m-p/232817#M185947 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><SPAN>try adding a breakpoint in ProcessEngineConfigurationImpl.java in the method:&nbsp;&nbsp; protected void initSqlSessionFactory() </SPAN><BR /><BR /><SPAN>so you can see step by step which call throws the exception and start investigating from here.</SPAN><BR /></BODY></HTML> Thu, 24 Mar 2016 08:20:20 GMT https://connect.hyland.com/t5/alfresco-archive/activityexception-error-while-building-ibatis-sqlsessionfactory/m-p/232817#M185947 vasile_dirla 2016-03-24T08:20:20Z