topic Configuring Database with Activiti.cfg.xml in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/configuring-database-with-activiti-cfg-xml/m-p/165910#M119565 <HTML><HEAD></HEAD><BODY><SPAN>I am new to activiti. I need to configure one existing database with activiti. I am getting below exception. Please help.</SPAN><BR /><BR /><SPAN>Q: If I use H2 Database. I gave maven dependency already and set datasource as below.</SPAN><BR /><SPAN>&lt;bean id="dataSource"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; class="org.springframework.jdbc.datasource.SimpleDriverDataSource"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="driverClass" value="org.h2.Driver" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="url" value="jdbc:h2:mem:activiti;DB_CLOSE_DELAY=1000" /&gt; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="username" value="sa" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="password" value="" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;/bean&gt;</SPAN><BR /><SPAN>I am using eclipse IDE, Spring, Maven SetUp (Declared H2 DB Jar). Do I need to start this database. I am new to this. Please help.</SPAN><BR /><SPAN>Note, When I am navigating to any of maven dependency jar class files like Property.xml, my eclipse popups 'NPE'. Is it expected? I am getting this exception for existing project also. so i believe this is not causing the below issue.</SPAN><BR /><BR /><SPAN>I am getting below exception on running with datasource (H2 database or my own database)</SPAN><BR /><SPAN>17:14:07.979 [main] DEBUG o.a.i.d.pooled.PooledDataSource - PooledDataSource forcefully closed/removed all connections.</SPAN><BR /><SPAN>org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-132]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.message.DbException.get(DbException.java:167)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.message.DbException.get(DbException.java:144)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.engine.SessionRemote.checkClosed(SessionRemote.java:447)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:326)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:219)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.engine.SessionRemote.createSession(SessionRemote.java:213)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.jdbc.JdbcConnection.&lt;init&gt;(JdbcConnection.java:110)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.jdbc.JdbcConnection.&lt;init&gt;(JdbcConnection.java:94)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.Driver.connect(Driver.java:58)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.sql.DriverManager.getConnection(DriverManager.java:582)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.sql.DriverManager.getConnection(DriverManager.java:154)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:181)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:176)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.getConnection(UnpooledDataSource.java:80)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:371)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.datasource.pooled.PooledDataSource.getConnection(PooledDataSource.java:80)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.initDatabaseType(ProcessEngineConfigurationImpl.java:586)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.initDataSource(ProcessEngineConfigurationImpl.java:548)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.init(ProcessEngineConfigurationImpl.java:393)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:371)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.altisource.MainApp.main(MainApp.java:26)</SPAN><BR /><SPAN>17:14:26.742 [main] DEBUG o.a.e.i.interceptor.LogInterceptor -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>17:14:26.742 [main] DEBUG o.a.e.i.interceptor.LogInterceptor - — starting SchemaOperationsProcessEngineBuild ——————————————————–</SPAN><BR /><SPAN>17:14:26.770 [main] DEBUG o.a.i.t.jdbc.JdbcTransaction - Openning JDBC Connection</SPAN><BR /><SPAN>17:14:45.096 [main] ERROR o.a.e.i.interceptor.CommandContext - Error while closing command context</SPAN><BR /><SPAN>org.apache.ibatis.exceptions.PersistenceException: </SPAN><BR /><SPAN>### Error querying database.&nbsp; Cause: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-132]</SPAN><BR /><SPAN>### The error may exist in org/activiti/db/mapping/entity/Property.xml</SPAN><BR /><SPAN>### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectDbSchemaVersion</SPAN><BR /><SPAN>### The error occurred while executing a query</SPAN><BR /><SPAN>### Cause: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-132]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23) ~[mybatis-3.1.1.jar:3.1.1]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104) ~[mybatis-3.1.1.jar:3.1.1]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95) ~[mybatis-3.1.1.jar:3.1.1]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:59) ~[mybatis-3.1.1.jar:3.1.1]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:54) ~[mybatis-3.1.1.jar:3.1.1]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.getDbVersion(DbSqlSession.java:741) ~[activiti-engine-5.12.jar:5.12]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.dbSchemaCheckVersion(DbSqlSession.java:697) ~[activiti-engine-5.12.jar:5.12]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:1111) ~[activiti-engine-5.12.jar:5.12]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:25) ~[activiti-engine-5.12.jar:5.12]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24) ~[activiti-engine-5.12.jar:5.12]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:61) ~[activiti-engine-5.12.jar:5.12]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:37) [activiti-engine-5.12.jar:5.12]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.ProcessEngineImpl.&lt;init&gt;(ProcessEngineImpl.java:76) [activiti-engine-5.12.jar:5.12]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:372) [activiti-engine-5.12.jar:5.12]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.altisource.MainApp.main(MainApp.java:26) [classes/:na]</SPAN><BR /><SPAN>Caused by: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-132]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.message.DbException.getJdbcSQLException(DbException.java:316) ~[h2-1.2.132.jar:1.2.132]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.message.DbException.get(DbException.java:167) ~[h2-1.2.132.jar:1.2.132]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.message.DbException.get(DbException.java:144) ~[h2-1.2.132.jar:1.2.132]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.engine.SessionRemote.checkClosed(SessionRemote.java:447) ~[h2-1.2.132.jar:1.2.132]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:326) ~[h2-1.2.132.jar:1.2.132]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:219) ~[h2-1.2.132.jar:1.2.132]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.engine.SessionRemote.createSession(SessionRemote.java:213) ~[h2-1.2.132.jar:1.2.132]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.jdbc.JdbcConnection.&lt;init&gt;(JdbcConnection.java:110) ~[h2-1.2.132.jar:1.2.132]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.jdbc.JdbcConnection.&lt;init&gt;(JdbcConnection.java:94) ~[h2-1.2.132.jar:1.2.132]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.Driver.connect(Driver.java:58) ~[h2-1.2.132.jar:1.2.132]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.sql.DriverManager.getConnection(DriverManager.java:582) ~[na:1.6.0_27]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.sql.DriverManager.getConnection(DriverManager.java:154) ~[na:1.6.0_27]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:181) ~[mybatis-3.1.1.jar:3.1.1]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:176) ~[mybatis-3.1.1.jar:3.1.1]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.getConnection(UnpooledDataSource.java:80) ~[mybatis-3.1.1.jar:3.1.1]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:371) ~[mybatis-3.1.1.jar:3.1.1]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.datasource.pooled.PooledDataSource.getConnection(PooledDataSource.java:80) ~[mybatis-3.1.1.jar:3.1.1]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:131) ~[mybatis-3.1.1.jar:3.1.1]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:58) ~[mybatis-3.1.1.jar:3.1.1]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:279) ~[mybatis-3.1.1.jar:3.1.1]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:69) ~[mybatis-3.1.1.jar:3.1.1]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:56) ~[mybatis-3.1.1.jar:3.1.1]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267) ~[mybatis-3.1.1.jar:3.1.1]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:141) ~[mybatis-3.1.1.jar:3.1.1]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105) ~[mybatis-3.1.1.jar:3.1.1]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81) ~[mybatis-3.1.1.jar:3.1.1]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101) ~[mybatis-3.1.1.jar:3.1.1]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 13 common frames omitted</SPAN><BR /><SPAN>Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException: </SPAN><BR /><SPAN>### Error querying database.&nbsp; Cause: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-132]</SPAN><BR /><SPAN>### The error may exist in org/activiti/db/mapping/entity/Property.xml</SPAN><BR /><SPAN>### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectDbSchemaVersion</SPAN><BR /><SPAN>### The error occurred while executing a query</SPAN><BR /><SPAN>### Cause: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-132]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:59)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:54)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.getDbVersion(DbSqlSession.java:741)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.dbSchemaCheckVersion(DbSqlSession.java:697)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:1111)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:61)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:37)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.ProcessEngineImpl.&lt;init&gt;(ProcessEngineImpl.java:76)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:372)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.altisource.MainApp.main(MainApp.java:26)</SPAN><BR /><SPAN>Caused by: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-132]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.message.DbException.get(DbException.java:167)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.message.DbException.get(DbException.java:144)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.engine.SessionRemote.checkClosed(SessionRemote.java:447)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:326)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:219)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.engine.SessionRemote.createSession(SessionRemote.java:213)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.jdbc.JdbcConnection.&lt;init&gt;(JdbcConnection.java:110)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.jdbc.JdbcConnection.&lt;init&gt;(JdbcConnection.java:94)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.Driver.connect(Driver.java:58)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.sql.DriverManager.getConnection(DriverManager.java:582)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.sql.DriverManager.getConnection(DriverManager.java:154)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:181)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:176)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.getConnection(UnpooledDataSource.java:80)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:371)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.datasource.pooled.PooledDataSource.getConnection(PooledDataSource.java:80)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:131)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:58)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:279)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:69)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:56)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:141)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101)17:14:45.097 [main] DEBUG o.a.e.i.c.s.StandaloneMybatisTransactionContext - firing event rolling back…</SPAN><BR /><SPAN>17:14:45.098 [main] DEBUG o.a.e.i.c.s.StandaloneMybatisTransactionContext - rolling back ibatis sql session…</SPAN><BR /><SPAN>17:14:45.098 [main] DEBUG o.a.e.i.c.s.StandaloneMybatisTransactionContext - firing event rolled back…</SPAN><BR /><SPAN>17:14:45.098 [main] DEBUG o.a.e.i.interceptor.LogInterceptor - — SchemaOperationsProcessEngineBuild finished ——————————————————–</SPAN><BR /><SPAN>17:14:45.098 [main] DEBUG o.a.e.i.interceptor.LogInterceptor -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 13 more</SPAN><BR /><BR /></BODY></HTML> Tue, 26 Nov 2013 12:01:24 GMT monika_b 2013-11-26T12:01:24Z Configuring Database with Activiti.cfg.xml https://connect.hyland.com/t5/alfresco-archive/configuring-database-with-activiti-cfg-xml/m-p/165910#M119565 I am new to activiti. I need to configure one existing database with activiti. I am getting below exception. Please help.Q: If I use H2 Database. I gave maven dependency already and set datasource as below.&lt;bean id="dataSource"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; class="org.springframework.jdbc.datasource.SimpleDriverDataSou Tue, 26 Nov 2013 12:01:24 GMT https://connect.hyland.com/t5/alfresco-archive/configuring-database-with-activiti-cfg-xml/m-p/165910#M119565 monika_b 2013-11-26T12:01:24Z Re: Configuring Database with Activiti.cfg.xml https://connect.hyland.com/t5/alfresco-archive/configuring-database-with-activiti-cfg-xml/m-p/165911#M119566 <HTML><HEAD></HEAD><BODY><SPAN>That's a specific database issue. make sure your H2 is running and is reachable from the machine activiti runs on…</SPAN></BODY></HTML> Thu, 05 Dec 2013 09:08:39 GMT https://connect.hyland.com/t5/alfresco-archive/configuring-database-with-activiti-cfg-xml/m-p/165911#M119566 frederikherema1 2013-12-05T09:08:39Z