Ubuntu jpa hibernate problem

[mort sahl]

I've got a problem (so what else is new!) and I'm not sure what's causing it.

I'm using Ubuntu 8.10 (same problem with 8.04), JPA with Hibernate as the provider and Spring 2.5.5. This problem does not exist when running the same code in windows.

I've a junit 4 test ...

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = "classpath:applicationContext.xml")
@Transactional
public class ArticleServiceTest {
 
   private Article article;
 
   @Autowired
   private ArticleService articleService;
 
   /**
    * Create test article before each test is run. Because of the
    * @Transaction annotation at the class level, the transaction should be rolled back after each class is run.
    */
   @Before
   public void createArticle() {
     
      List<Article> articlesToCreate = new ArrayList<Article>();
     
      article = new Article();
      article.setAuthor("Author");
 
      articlesToCreate.add(article);
      assertTrue(articleService.create(articlesToCreate) == 1);
      assertNotNull(article.getId());
}
 
   @Test
   public void create() {
      Article a = articleService.getArticleById(article);
      assertNotNull(article.getId());
      assertSame(article, a);
   }
}

The problem is, in Ubuntu, the article is not rolled back ... it should be.

In Windows, after the test is run, the article is rolled back.

Any ideas why I'm getting this behavior in Ubuntu?

[Jaikiran Pai]

Based on the @Autowire annotation, i guess you are using Spring. I don't have any experience in Spring. Looking at your code, i don't see any specific reason why the transaction should be rolled back. Can you please provide more details about you test case and why you are expecting the transaction to rollback?

[mort sahl]

It's a JPA thing ... unless entityManager.persist(article) is called, the transaction should not be committed. Under Windows it works correctly, under Ubuntu, the transaction is committed when it should not be.

[mort sahl]

Eventually found the answer to the problem. It seems that on Windows I had MySQL set to use INNODB and on Ubuntu it was using MyISAM. MyISAM isn't transactional, therefore my rows weren't being rolled back.

Sorry to have blamed Ubuntu. (Now to get this Windows virus off my machine and reinstall Ubuntu)