Hi, We are seeing this issue intermittently in BPS 3.5.0, even with DB_CLOSE_DELAY=1000. Hence I have re-opened jira [1].
IMO correct fix would be to keep open database as long as the JVM is alive. We can configure it by setting "DB_CLOSE_DELAY=-1" [2]. [1] https://wso2.org/jira/browse/BPS-529 [2] http://www.h2database.com/html/features.html#in_memory_databases Thanks, Hasitha. On Mon, Mar 17, 2014 at 12:24 PM, Waruna Jayaweera <waru...@wso2.com> wrote: > Thanks Amal > > > On Mon, Mar 17, 2014 at 12:22 PM, Amal Gunatilake <am...@wso2.com> wrote: >> >> Hi Waruna, >> >> In-order to make the data persistence across server restarts in >> Activiti-Explorer, once you deploy the war archive in Tomcat server. Go to >> webapps/activiti-explorer/WEB-INF/classes/db.properties file and change the >> jdbc url from jdbc:h2:mem: to jdbc:h2:file: as follows. >> >> jdbc.url=jdbc:h2:file:activiti;DB_CLOSE_DELAY=1000 >> >> When you have this configuration as mem it will create the database only >> in memory and when we restart the sever, data will get lost. Changing the >> property to file will create a permanent database. >> >> >> >> Thank you & Best regards, >> >> Amal Gunatilake >> Software Engineer >> WSO2 Inc.; http://wso2.com >> lean.enterprise.middleware >> >> >> On Mon, Mar 17, 2014 at 12:13 PM, Waruna Jayaweera <waru...@wso2.com> >> wrote: >>> >>> Hi , >>> I had same issue on activity explorer. There is no activiti.cfg.xml in >>> Activity explorer configurations. >>> thanks, >>> Waruna >>> >>> >>> On Sat, Mar 1, 2014 at 10:19 PM, Amal Gunatilake <am...@wso2.com> wrote: >>>> >>>> Hi Chathura, >>>> >>>> Thank you for the info. Until we have a separate xml file for BPMN I'll >>>> configure them in bps.xml. Thanks again for the quick response. >>>> >>>> Thank you & Best regards, >>>> >>>> Amal Gunatilake >>>> Software Engineer >>>> WSO2 Inc.; http://wso2.com >>>> lean.enterprise.middleware >>>> >>>> >>>> On Sat, Mar 1, 2014 at 6:47 PM, Chathura Ekanayake <chath...@wso2.com> >>>> wrote: >>>>> >>>>> >>>>> Hi Amal, >>>>> >>>>> The default configuration in Activiti uses an in-memory H2 database. >>>>> Data can be made persistent (across server restarts) by changing this to a >>>>> disk-based DB. Change the database config in activiti.cfg.xml file to do >>>>> this. Currently BPS also uses the same XML (until we change it to use >>>>> bpmn.xml). >>>>> >>>>> Regards, >>>>> Chathura >>>>> >>>>> >>>>> >>>>> On Sat, Mar 1, 2014 at 4:25 PM, Amal Gunatilake <am...@wso2.com> wrote: >>>>>> >>>>>> Hi All, >>>>>> >>>>>> When running some test on Activiti explorer itself, I observed that >>>>>> the instances we create will get lost after doing a server restart, no >>>>>> matter which state the instances are. Is it a normal behaviour ? I think >>>>>> those has to be permanent data. So we might have to have a contingency >>>>>> plan >>>>>> such as maintaining a separate database for instances or any other better >>>>>> approach. >>>>>> >>>>>> Thank you & Best regards, >>>>>> >>>>>> Amal Gunatilake >>>>>> Software Engineer >>>>>> WSO2 Inc.; http://wso2.com >>>>>> lean.enterprise.middleware >>>>> >>>>> >>>> >>> >>> >>> >>> -- >>> Regards, >>> >>> Waruna Lakshitha Jayaweera >>> Software Engineer >>> WSO2 Inc; http://wso2.com >>> phone: +94713255198 >> >> > > > > -- > Regards, > > Waruna Lakshitha Jayaweera > Software Engineer > WSO2 Inc; http://wso2.com > phone: +94713255198 -- Hasitha Aravinda, Software Engineer, WSO2 Inc. Email: hasi...@wso2.com Mobile: +94 71 8 210 200 _______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev