topic Re: a strange question about jta transaction in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/a-strange-question-about-jta-transaction/m-p/198481#M151611 <HTML><HEAD></HEAD><BODY><SPAN>How is your H2 configured. Did you add the close delay?</SPAN><BR /><BR /><SPAN>"By default, closing the last connection to a database closes the database. For an in-memory database, this means the content is lost. To keep the database open, add ;DB_CLOSE_DELAY=-1 to the database URL. To keep the content of an in-memory database as long as the virtual machine is alive, use jdbc:h2:mem:test;DB_CLOSE_DELAY=-1"</SPAN><BR /><BR /><SPAN>We are not using H2 for testing JTA (but mysql) in our qa env, so no real experience there.</SPAN></BODY></HTML> Fri, 04 Jul 2014 09:29:00 GMT jbarrez 2014-07-04T09:29:00Z a strange question about jta transaction https://connect.hyland.com/t5/alfresco-archive/a-strange-question-about-jta-transaction/m-p/198480#M151610 I use JTA manage my transaction, and from spring my service bean like this:@Transactional@Component("myService")public class MyServiceImpl implements MyService {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;@PersistenceContext(unitName="platform")&nbsp;&nbsp;&nbsp;private EntityManager em;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;@Autowired&nbsp;&nbsp;&nbsp;private TaskService taskService;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;@Overrid Tue, 24 Jun 2014 08:02:03 GMT https://connect.hyland.com/t5/alfresco-archive/a-strange-question-about-jta-transaction/m-p/198480#M151610 jonlee 2014-06-24T08:02:03Z Re: a strange question about jta transaction https://connect.hyland.com/t5/alfresco-archive/a-strange-question-about-jta-transaction/m-p/198481#M151611 <HTML><HEAD></HEAD><BODY><SPAN>How is your H2 configured. Did you add the close delay?</SPAN><BR /><BR /><SPAN>"By default, closing the last connection to a database closes the database. For an in-memory database, this means the content is lost. To keep the database open, add ;DB_CLOSE_DELAY=-1 to the database URL. To keep the content of an in-memory database as long as the virtual machine is alive, use jdbc:h2:mem:test;DB_CLOSE_DELAY=-1"</SPAN><BR /><BR /><SPAN>We are not using H2 for testing JTA (but mysql) in our qa env, so no real experience there.</SPAN></BODY></HTML> Fri, 04 Jul 2014 09:29:00 GMT https://connect.hyland.com/t5/alfresco-archive/a-strange-question-about-jta-transaction/m-p/198481#M151611 jbarrez 2014-07-04T09:29:00Z